PREVIEW / etf_5min / 2020-05-18

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-05-18.parquet
  size:    1.7 MB
  rows:    79,522

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
2020-05-18 04:00:00	SPY	ETF	289.1	289.7	289.1	289.66	52178.0
2020-05-18 04:05:00	SPY	ETF	289.68	289.97	289.67	289.81	8898.0
2020-05-18 04:10:00	SPY	ETF	289.69	289.69	289.42	289.48	8187.0
2020-05-18 04:15:00	SPY	ETF	289.47	289.76	289.43	289.73	3921.0
2020-05-18 04:20:00	SPY	ETF	289.74	289.8	289.34	289.49	6782.0
2020-05-18 04:25:00	SPY	ETF	289.51	289.51	289.45	289.45	1408.0
2020-05-18 04:30:00	SPY	ETF	289.59	289.63	289.29	289.29	5210.0
2020-05-18 04:35:00	SPY	ETF	289.6	289.89	289.49	289.89	16881.0
2020-05-18 04:40:00	SPY	ETF	289.82	289.9	289.64	289.64	16300.0
2020-05-18 04:45:00	SPY	ETF	289.66	289.67	289.52	289.54	1547.0
2020-05-18 04:50:00	SPY	ETF	289.5	289.5	289.48	289.49	639.0
2020-05-18 04:55:00	SPY	ETF	289.59	289.59	289.44	289.57	2228.0
2020-05-18 05:00:00	SPY	ETF	289.5	289.61	289.25	289.25	5896.0
2020-05-18 05:05:00	SPY	ETF	289.18	289.18	289.13	289.14	10471.0
2020-05-18 05:10:00	SPY	ETF	289.35	289.37	289.26	289.35	1726.0
2020-05-18 05:15:00	SPY	ETF	289.14	289.17	289.1	289.17	995.0
2020-05-18 05:20:00	SPY	ETF	289.23	289.35	289.23	289.35	200.0
2020-05-18 05:25:00	SPY	ETF	289.27	289.27	289.0	289.0	639.0
2020-05-18 05:30:00	SPY	ETF	288.97	288.97	288.97	288.97	112.0
2020-05-18 05:35:00	SPY	ETF	288.86	289.0	288.76	289.0	23876.0
2020-05-18 05:40:00	SPY	ETF	288.99	289.22	288.99	289.22	1335.0
2020-05-18 05:45:00	SPY	ETF	289.18	289.28	289.17	289.28	3603.0
2020-05-18 05:50:00	SPY	ETF	289.15	289.29	289.15	289.29	1711.0
2020-05-18 06:00:00	SPY	ETF	289.17	289.28	289.14	289.28	9290.0
2020-05-18 06:05:00	SPY	ETF	289.29	289.45	289.29	289.33	9155.0
2020-05-18 06:10:00	SPY	ETF	289.39	289.4	289.39	289.39	3483.0
2020-05-18 06:15:00	SPY	ETF	289.43	289.43	289.21	289.21	10288.0
2020-05-18 06:20:00	SPY	ETF	289.19	289.25	289.18	289.25	10820.0
2020-05-18 06:25:00	SPY	ETF	289.16	289.22	289.16	289.2	1957.0
2020-05-18 06:30:00	SPY	ETF	289.16	289.16	288.99	289.16	11120.0
2020-05-18 06:35:00	SPY	ETF	289.16	289.35	289.16	289.31	6002.0
2020-05-18 06:40:00	SPY	ETF	289.39	289.58	289.39	289.46	17023.0
2020-05-18 06:45:00	SPY	ETF	289.43	289.43	289.34	289.35	3712.0
2020-05-18 06:50:00	SPY	ETF	289.36	289.38	289.34	289.35	13367.0
2020-05-18 06:55:00	SPY	ETF	289.42	289.7	289.4	289.7	4901.0
2020-05-18 07:00:00	SPY	ETF	289.78	289.79	289.46	289.57	30026.0
2020-05-18 07:05:00	SPY	ETF	289.55	289.61	289.51	289.51	10541.0
2020-05-18 07:10:00	SPY	ETF	289.49	289.68	289.45	289.59	16037.0
2020-05-18 07:15:00	SPY	ETF	289.51	289.73	289.5	289.73	15815.0
2020-05-18 07:20:00	SPY	ETF	289.68	289.68	289.57	289.59	53034.0
2020-05-18 07:25:00	SPY	ETF	289.61	289.65	289.53	289.61	9062.0
2020-05-18 07:30:00	SPY	ETF	289.6	290.0	289.43	289.44	145628.0
2020-05-18 07:35:00	SPY	ETF	289.45	289.99	289.45	289.93	140697.0
2020-05-18 07:40:00	SPY	ETF	289.94	290.7	289.94	290.5	182523.0
2020-05-18 07:45:00	SPY	ETF	290.51	291.52	290.5	291.3	378121.0
2020-05-18 07:50:00	SPY	ETF	291.25	291.6	291.23	291.4	141111.0
2020-05-18 07:55:00	SPY	ETF	291.4	291.94	291.36	291.78	149130.0
2020-05-18 08:00:00	SPY	ETF	291.76	292.2902	287.9	292.01	576866.0
2020-05-18 08:05:00	SPY	ETF	292.02	292.47	291.92	292.38	310768.0
2020-05-18 08:10:00	SPY	ETF	292.45	292.66	288.75	292.64	179983.0

> showing 50 of 79,522 rows — these rows as CSV

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