PREVIEW / etf_5min / 2020-10-22

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-10-22.parquet
  size:    1.6 MB
  rows:    70,879

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-10-22 04:00:00	SPY	ETF	341.94	341.94	341.84	341.89	6723.0
2020-10-22 04:05:00	SPY	ETF	341.9	341.9	341.76	341.86	822.0
2020-10-22 04:10:00	SPY	ETF	341.76	341.83	341.69	341.74	3300.0
2020-10-22 04:15:00	SPY	ETF	341.74	341.91	341.74	341.91	5352.0
2020-10-22 04:20:00	SPY	ETF	341.99	342.12	341.99	342.11	2715.0
2020-10-22 04:25:00	SPY	ETF	342.15	342.67	342.15	342.67	6055.0
2020-10-22 04:30:00	SPY	ETF	342.7	342.72	342.58	342.58	841.0
2020-10-22 04:35:00	SPY	ETF	342.53	342.53	342.4	342.4	2300.0
2020-10-22 04:40:00	SPY	ETF	342.34	342.34	342.27	342.27	3690.0
2020-10-22 04:45:00	SPY	ETF	342.16	342.19	342.16	342.19	758.0
2020-10-22 04:50:00	SPY	ETF	342.29	342.32	342.24	342.3	9260.0
2020-10-22 05:00:00	SPY	ETF	342.33	342.33	342.33	342.33	301.0
2020-10-22 05:10:00	SPY	ETF	342.18	342.21	342.16	342.2	12700.0
2020-10-22 05:15:00	SPY	ETF	342.04	342.12	342.04	342.12	1200.0
2020-10-22 05:20:00	SPY	ETF	342.15	342.15	342.15	342.15	100.0
2020-10-22 05:25:00	SPY	ETF	342.13	342.13	342.13	342.13	1000.0
2020-10-22 05:30:00	SPY	ETF	342.17	342.17	342.1	342.1	1075.0
2020-10-22 05:35:00	SPY	ETF	342.04	342.26	342.04	342.26	609.0
2020-10-22 05:40:00	SPY	ETF	342.24	342.3	342.24	342.3	400.0
2020-10-22 05:45:00	SPY	ETF	342.3	342.3	342.13	342.13	757.0
2020-10-22 05:55:00	SPY	ETF	342.38	342.38	342.19	342.19	550.0
2020-10-22 06:00:00	SPY	ETF	342.02	342.02	341.85	342.0	1130.0
2020-10-22 06:05:00	SPY	ETF	341.95	341.96	341.82	341.92	3622.0
2020-10-22 06:10:00	SPY	ETF	341.95	341.96	341.93	341.96	3177.0
2020-10-22 06:15:00	SPY	ETF	341.99	342.41	341.98	342.41	4567.0
2020-10-22 06:20:00	SPY	ETF	342.53	342.75	342.53	342.7	7067.0
2020-10-22 06:25:00	SPY	ETF	342.77	342.77	342.77	342.77	100.0
2020-10-22 06:30:00	SPY	ETF	342.7	342.71	342.6	342.64	3347.0
2020-10-22 06:35:00	SPY	ETF	342.69	342.78	342.4	342.4	2991.0
2020-10-22 06:40:00	SPY	ETF	342.36	342.46	342.33	342.43	3680.0
2020-10-22 06:45:00	SPY	ETF	342.53	342.84	342.5	342.58	11252.0
2020-10-22 06:50:00	SPY	ETF	342.56	342.71	342.55	342.63	18060.0
2020-10-22 06:55:00	SPY	ETF	342.65	342.71	342.57	342.58	5501.0
2020-10-22 07:00:00	SPY	ETF	342.56	342.66	342.47	342.47	36960.0
2020-10-22 07:05:00	SPY	ETF	342.48	342.73	342.44	342.55	10449.0
2020-10-22 07:10:00	SPY	ETF	342.6	342.61	342.5	342.58	5750.0
2020-10-22 07:15:00	SPY	ETF	342.55	342.7	342.51	342.69	15956.0
2020-10-22 07:20:00	SPY	ETF	342.67	342.85	342.67	342.76	28063.0
2020-10-22 07:25:00	SPY	ETF	342.7	342.7	342.58	342.64	7092.0
2020-10-22 07:30:00	SPY	ETF	342.64	342.73	342.57	342.57	13516.0
2020-10-22 07:35:00	SPY	ETF	342.52	342.53	342.3	342.53	34985.0
2020-10-22 07:40:00	SPY	ETF	342.54	342.61	342.54	342.57	27117.0
2020-10-22 07:45:00	SPY	ETF	342.59	342.84	342.58	342.84	13848.0
2020-10-22 07:50:00	SPY	ETF	342.82	342.82	342.72	342.74	7482.0
2020-10-22 07:55:00	SPY	ETF	342.73	342.75	342.56	342.75	6087.0
2020-10-22 08:00:00	SPY	ETF	342.7899	343.07	340.51	343.03	40988.0
2020-10-22 08:05:00	SPY	ETF	343.05	343.05	342.65	342.77	49305.0
2020-10-22 08:10:00	SPY	ETF	342.79	342.87	342.6	342.63	10046.0
2020-10-22 08:15:00	SPY	ETF	342.64	342.65	342.48	342.55	39441.0
2020-10-22 08:20:00	SPY	ETF	342.61	342.61	342.43	342.47	31128.0

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

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