PREVIEW / etf_5min / 2020-06-19

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-06-19.parquet
  size:    1.6 MB
  rows:    75,153

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-06-19 04:00:00	SPY	ETF	312.12	312.12	311.93	311.95	11430.0
2020-06-19 04:05:00	SPY	ETF	311.9	311.9	311.43	311.43	6228.0
2020-06-19 04:10:00	SPY	ETF	311.44	311.48	311.27	311.27	3334.0
2020-06-19 04:15:00	SPY	ETF	311.41	311.49	311.41	311.49	1732.0
2020-06-19 04:20:00	SPY	ETF	311.45	311.53	311.45	311.53	1309.0
2020-06-19 04:25:00	SPY	ETF	311.59	311.65	311.57	311.57	860.0
2020-06-19 04:30:00	SPY	ETF	311.69	311.77	311.62	311.77	2361.0
2020-06-19 04:35:00	SPY	ETF	311.67	311.68	311.33	311.42	5064.0
2020-06-19 04:40:00	SPY	ETF	311.49	311.82	311.4	311.78	2283.0
2020-06-19 04:45:00	SPY	ETF	311.77	311.98	311.77	311.97	3010.0
2020-06-19 04:50:00	SPY	ETF	311.99	312.0	311.94	311.99	1279.0
2020-06-19 04:55:00	SPY	ETF	311.94	311.99	311.9	311.92	8200.0
2020-06-19 05:00:00	SPY	ETF	312.05	312.14	312.04	312.14	671.0
2020-06-19 05:05:00	SPY	ETF	312.1	312.1	311.9	311.92	4471.0
2020-06-19 05:10:00	SPY	ETF	311.82	312.34	311.8	312.34	6781.0
2020-06-19 05:15:00	SPY	ETF	312.49	312.64	312.44	312.44	14710.0
2020-06-19 05:20:00	SPY	ETF	312.3	312.3	312.3	312.3	500.0
2020-06-19 05:30:00	SPY	ETF	312.44	312.5	312.44	312.45	6700.0
2020-06-19 05:35:00	SPY	ETF	312.66	312.67	312.64	312.65	5909.0
2020-06-19 05:40:00	SPY	ETF	312.67	312.88	312.6	312.6	5590.0
2020-06-19 05:45:00	SPY	ETF	312.56	312.56	312.39	312.4	3931.0
2020-06-19 05:50:00	SPY	ETF	312.47	313.09	312.47	312.67	10837.0
2020-06-19 05:55:00	SPY	ETF	312.65	312.66	312.5	312.64	3494.0
2020-06-19 06:00:00	SPY	ETF	312.59	312.74	312.36	312.74	7639.0
2020-06-19 06:05:00	SPY	ETF	312.81	313.18	312.81	313.05	8459.0
2020-06-19 06:10:00	SPY	ETF	313.01	313.01	312.86	312.86	1011.0
2020-06-19 06:15:00	SPY	ETF	312.8	312.89	312.65	312.69	2029.0
2020-06-19 06:20:00	SPY	ETF	312.74	312.74	312.49	312.49	5736.0
2020-06-19 06:25:00	SPY	ETF	312.59	312.59	312.37	312.39	9661.0
2020-06-19 06:30:00	SPY	ETF	312.29	312.41	312.22	312.24	11649.0
2020-06-19 06:35:00	SPY	ETF	312.26	312.26	312.17	312.2	5863.0
2020-06-19 06:40:00	SPY	ETF	312.17	312.26	312.17	312.26	805.0
2020-06-19 06:45:00	SPY	ETF	312.26	312.34	312.19	312.3	4657.0
2020-06-19 06:50:00	SPY	ETF	312.39	312.42	312.08	312.12	3156.0
2020-06-19 06:55:00	SPY	ETF	312.16	312.48	312.16	312.48	19008.0
2020-06-19 07:00:00	SPY	ETF	312.47	312.67	312.31	312.64	20378.0
2020-06-19 07:05:00	SPY	ETF	312.63	312.7	312.59	312.63	14712.0
2020-06-19 07:10:00	SPY	ETF	312.6	312.6	312.44	312.47	4210.0
2020-06-19 07:15:00	SPY	ETF	312.42	312.42	312.28	312.42	10434.0
2020-06-19 07:20:00	SPY	ETF	312.4	312.4	312.2	312.3	19897.0
2020-06-19 07:25:00	SPY	ETF	312.31	312.6	312.31	312.59	13685.0
2020-06-19 07:30:00	SPY	ETF	312.55	312.7	312.52	312.7	26848.0
2020-06-19 07:35:00	SPY	ETF	312.7	312.81	312.63	312.8	13391.0
2020-06-19 07:40:00	SPY	ETF	312.71	312.72	312.59	312.69	32198.0
2020-06-19 07:45:00	SPY	ETF	312.71	312.83	312.69	312.74	6690.0
2020-06-19 07:50:00	SPY	ETF	312.78	312.87	312.72	312.78	13596.0
2020-06-19 07:55:00	SPY	ETF	312.8	313.13	312.8	313.11	37546.0
2020-06-19 08:00:00	SPY	ETF	313.09	313.47	311.5	313.32	116352.0
2020-06-19 08:05:00	SPY	ETF	313.36	313.77	313.25	313.67	46623.0
2020-06-19 08:10:00	SPY	ETF	313.62	313.74	313.47	313.65	164054.0

> showing 50 of 75,153 rows — these rows as CSV

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