PREVIEW / etf_5min / 2020-04-29

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-04-29.parquet
  size:    1.8 MB
  rows:    79,378

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-04-29 04:00:00	SPY	ETF	289.47	289.48	289.21	289.31	12855.0
2020-04-29 04:05:00	SPY	ETF	289.25	289.32	289.02	289.1	8770.0
2020-04-29 04:10:00	SPY	ETF	289.12	289.16	288.94	288.94	4146.0
2020-04-29 04:15:00	SPY	ETF	289.25	289.31	289.24	289.24	6848.0
2020-04-29 04:20:00	SPY	ETF	289.22	289.22	289.18	289.18	1167.0
2020-04-29 04:25:00	SPY	ETF	289.04	289.07	288.81	289.07	12101.0
2020-04-29 04:30:00	SPY	ETF	289.06	289.35	289.04	289.23	4137.0
2020-04-29 04:35:00	SPY	ETF	289.3	289.5	289.3	289.5	390.0
2020-04-29 04:40:00	SPY	ETF	289.5	289.56	289.3	289.3	2101.0
2020-04-29 04:45:00	SPY	ETF	289.28	289.5	289.28	289.5	300.0
2020-04-29 04:50:00	SPY	ETF	289.43	289.61	289.43	289.61	1111.0
2020-04-29 04:55:00	SPY	ETF	289.52	289.69	289.5	289.69	4213.0
2020-04-29 05:00:00	SPY	ETF	289.66	289.66	289.65	289.65	2200.0
2020-04-29 05:05:00	SPY	ETF	289.73	289.8	289.73	289.8	1640.0
2020-04-29 05:10:00	SPY	ETF	289.69	289.7	289.63	289.63	2801.0
2020-04-29 05:15:00	SPY	ETF	289.65	289.65	289.65	289.65	200.0
2020-04-29 05:20:00	SPY	ETF	289.7	289.81	289.68	289.73	3260.0
2020-04-29 05:25:00	SPY	ETF	289.81	289.87	289.75	289.87	841.0
2020-04-29 05:30:00	SPY	ETF	289.82	289.83	289.69	289.71	1250.0
2020-04-29 05:35:00	SPY	ETF	289.72	289.78	289.72	289.78	4100.0
2020-04-29 05:40:00	SPY	ETF	289.8	289.84	289.8	289.84	409.0
2020-04-29 05:45:00	SPY	ETF	289.57	289.57	289.32	289.32	432.0
2020-04-29 05:50:00	SPY	ETF	289.4	289.63	289.34	289.63	2057.0
2020-04-29 05:55:00	SPY	ETF	289.4	289.5	289.4	289.5	685.0
2020-04-29 06:00:00	SPY	ETF	289.57	289.57	289.11	289.12	6399.0
2020-04-29 06:05:00	SPY	ETF	289.11	289.16	288.92	289.09	4547.0
2020-04-29 06:10:00	SPY	ETF	289.15	289.2	289.0	289.0	2924.0
2020-04-29 06:15:00	SPY	ETF	289.02	289.14	289.0	289.13	3331.0
2020-04-29 06:20:00	SPY	ETF	289.07	289.08	289.04	289.08	2300.0
2020-04-29 06:25:00	SPY	ETF	288.95	289.02	288.82	288.82	2905.0
2020-04-29 06:30:00	SPY	ETF	288.79	288.79	288.6	288.65	3985.0
2020-04-29 06:40:00	SPY	ETF	288.92	288.92	288.84	288.84	1146.0
2020-04-29 06:45:00	SPY	ETF	288.88	289.0	288.88	288.97	41705.0
2020-04-29 06:50:00	SPY	ETF	288.97	289.03	288.94	289.0	70865.0
2020-04-29 06:55:00	SPY	ETF	289.0	289.35	289.0	289.35	30604.0
2020-04-29 07:00:00	SPY	ETF	289.32	289.53	289.16	289.45	71154.0
2020-04-29 07:05:00	SPY	ETF	289.52	289.52	289.2	289.25	30810.0
2020-04-29 07:10:00	SPY	ETF	289.25	289.45	289.25	289.35	40820.0
2020-04-29 07:15:00	SPY	ETF	289.32	289.35	288.85	289.01	65997.0
2020-04-29 07:20:00	SPY	ETF	289.01	289.01	288.53	288.71	483748.0
2020-04-29 07:25:00	SPY	ETF	288.7	288.73	288.59	288.61	66540.0
2020-04-29 07:30:00	SPY	ETF	288.6	288.92	288.55	288.7	63678.0
2020-04-29 07:35:00	SPY	ETF	288.75	288.82	288.67	288.82	18652.0
2020-04-29 07:40:00	SPY	ETF	288.77	288.81	288.62	288.7	47982.0
2020-04-29 07:45:00	SPY	ETF	288.7	288.7	288.21	288.22	75724.0
2020-04-29 07:50:00	SPY	ETF	288.25	288.37	288.21	288.28	47342.0
2020-04-29 07:55:00	SPY	ETF	288.27	288.46	288.21	288.46	11334.0
2020-04-29 08:00:00	SPY	ETF	289.13	290.63	288.2	288.54	70890.0
2020-04-29 08:05:00	SPY	ETF	288.54	288.64	288.5	288.58	19976.0
2020-04-29 08:10:00	SPY	ETF	288.65	289.0	288.63	288.88	67988.0

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

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