PREVIEW / etf_5min / 2019-08-14

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-08-14.parquet
  size:    1.7 MB
  rows:    70,552

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2019-08-14 04:00:00	SPY	ETF	292.34	292.36	292.13	292.27	5730.0
2019-08-14 04:05:00	SPY	ETF	292.23	292.3	292.23	292.3	1150.0
2019-08-14 04:15:00	SPY	ETF	292.29	292.29	292.14	292.29	1115.0
2019-08-14 04:20:00	SPY	ETF	292.24	292.31	292.24	292.31	850.0
2019-08-14 04:25:00	SPY	ETF	292.21	292.21	292.19	292.19	400.0
2019-08-14 04:30:00	SPY	ETF	292.2	292.2	292.2	292.2	500.0
2019-08-14 04:35:00	SPY	ETF	292.0	292.0	292.0	292.0	129.0
2019-08-14 04:40:00	SPY	ETF	292.0	292.0	291.71	291.71	6935.0
2019-08-14 04:45:00	SPY	ETF	291.76	291.76	291.62	291.71	1763.0
2019-08-14 04:50:00	SPY	ETF	291.74	291.76	291.74	291.76	600.0
2019-08-14 04:55:00	SPY	ETF	291.86	291.86	291.79	291.84	1850.0
2019-08-14 05:00:00	SPY	ETF	291.87	291.87	291.68	291.69	4305.0
2019-08-14 05:05:00	SPY	ETF	291.61	291.66	291.61	291.64	1418.0
2019-08-14 05:10:00	SPY	ETF	291.5	291.51	291.49	291.5	1854.0
2019-08-14 05:15:00	SPY	ETF	291.44	291.61	291.44	291.54	5100.0
2019-08-14 05:20:00	SPY	ETF	291.64	291.64	291.54	291.54	600.0
2019-08-14 05:25:00	SPY	ETF	291.44	291.46	291.37	291.37	300.0
2019-08-14 05:30:00	SPY	ETF	291.49	291.49	291.44	291.44	1050.0
2019-08-14 05:35:00	SPY	ETF	291.38	291.38	291.19	291.19	3240.0
2019-08-14 05:40:00	SPY	ETF	291.27	291.32	291.27	291.27	1823.0
2019-08-14 05:45:00	SPY	ETF	291.22	291.27	291.15	291.27	1900.0
2019-08-14 05:50:00	SPY	ETF	291.25	291.32	291.15	291.15	3550.0
2019-08-14 05:55:00	SPY	ETF	291.23	291.23	291.12	291.12	400.0
2019-08-14 06:00:00	SPY	ETF	291.12	291.12	291.0	291.04	2669.0
2019-08-14 06:05:00	SPY	ETF	291.05	291.05	290.66	290.67	6938.0
2019-08-14 06:10:00	SPY	ETF	290.68	290.82	290.62	290.62	3393.0
2019-08-14 06:15:00	SPY	ETF	290.7	290.7	290.35	290.4	6356.0
2019-08-14 06:20:00	SPY	ETF	290.44	290.44	290.18	290.18	36465.0
2019-08-14 06:25:00	SPY	ETF	290.22	290.36	290.0	290.34	18589.0
2019-08-14 06:30:00	SPY	ETF	290.35	290.54	290.34	290.4	19648.0
2019-08-14 06:35:00	SPY	ETF	290.4	290.41	290.2	290.33	16154.0
2019-08-14 06:40:00	SPY	ETF	290.34	290.59	290.34	290.57	9005.0
2019-08-14 06:45:00	SPY	ETF	290.62	290.74	290.52	290.55	44217.0
2019-08-14 06:50:00	SPY	ETF	290.52	290.52	290.2	290.2	1789.0
2019-08-14 06:55:00	SPY	ETF	290.23	290.37	290.23	290.34	7050.0
2019-08-14 07:00:00	SPY	ETF	290.4	290.47	290.32	290.4	15032.0
2019-08-14 07:05:00	SPY	ETF	290.38	290.38	290.13	290.19	65683.0
2019-08-14 07:10:00	SPY	ETF	290.15	290.36	290.05	290.26	36593.0
2019-08-14 07:15:00	SPY	ETF	290.3	290.36	290.2	290.34	41111.0
2019-08-14 07:20:00	SPY	ETF	290.31	290.54	290.29	290.53	45880.0
2019-08-14 07:25:00	SPY	ETF	290.51	290.52	290.38	290.47	24921.0
2019-08-14 07:30:00	SPY	ETF	290.42	290.47	290.0	290.05	35039.0
2019-08-14 07:35:00	SPY	ETF	290.0	290.13	289.94	290.11	156228.0
2019-08-14 07:40:00	SPY	ETF	290.01	290.05	289.05	289.36	293383.0
2019-08-14 07:45:00	SPY	ETF	289.3	289.5	289.14	289.37	100343.0
2019-08-14 07:50:00	SPY	ETF	289.35	289.35	288.76	288.9	113993.0
2019-08-14 07:55:00	SPY	ETF	288.94	289.19	288.86	289.11	79402.0
2019-08-14 08:00:00	SPY	ETF	290.43	293.0	288.8	289.16	159025.0
2019-08-14 08:05:00	SPY	ETF	289.13	289.48	288.69	288.92	244386.0
2019-08-14 08:10:00	SPY	ETF	288.97	289.08	288.42	288.86	325008.0

> showing 50 of 70,552 rows — these rows as CSV

> unlock the full archive -- $79 one-time