PREVIEW / etf_5min / 2020-10-26

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-10-26.parquet
  size:    1.7 MB
  rows:    76,763

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-26 04:00:00	SPY	ETF	341.55	341.63	341.3	341.4	26268.0
2020-10-26 04:05:00	SPY	ETF	341.58	341.78	341.46	341.74	9749.0
2020-10-26 04:10:00	SPY	ETF	341.68	341.81	341.63	341.81	5629.0
2020-10-26 04:15:00	SPY	ETF	341.92	341.93	341.73	341.86	1714.0
2020-10-26 04:20:00	SPY	ETF	341.76	341.76	341.55	341.6	2633.0
2020-10-26 04:25:00	SPY	ETF	341.61	341.76	341.58	341.61	3727.0
2020-10-26 04:30:00	SPY	ETF	341.52	341.63	341.46	341.46	3457.0
2020-10-26 04:35:00	SPY	ETF	341.58	341.81	341.47	341.81	7019.0
2020-10-26 04:40:00	SPY	ETF	341.74	341.83	341.64	341.83	920.0
2020-10-26 04:45:00	SPY	ETF	341.93	342.15	341.91	341.91	5591.0
2020-10-26 04:50:00	SPY	ETF	341.92	341.96	341.83	341.96	4030.0
2020-10-26 04:55:00	SPY	ETF	341.92	341.92	341.91	341.91	1000.0
2020-10-26 05:00:00	SPY	ETF	342.04	342.04	341.84	341.94	1186.0
2020-10-26 05:05:00	SPY	ETF	342.03	342.09	342.03	342.09	550.0
2020-10-26 05:10:00	SPY	ETF	342.04	342.08	342.04	342.06	1556.0
2020-10-26 05:20:00	SPY	ETF	342.16	342.16	342.05	342.05	850.0
2020-10-26 05:25:00	SPY	ETF	342.01	342.09	341.97	342.09	3070.0
2020-10-26 05:30:00	SPY	ETF	342.17	342.17	342.05	342.07	3337.0
2020-10-26 05:35:00	SPY	ETF	342.1	342.16	341.96	341.96	17055.0
2020-10-26 05:40:00	SPY	ETF	341.96	341.96	341.96	341.96	255.0
2020-10-26 05:45:00	SPY	ETF	341.79	341.84	341.7	341.7	2134.0
2020-10-26 05:50:00	SPY	ETF	341.64	341.69	341.6	341.69	3202.0
2020-10-26 05:55:00	SPY	ETF	341.72	341.88	341.72	341.86	790.0
2020-10-26 06:05:00	SPY	ETF	341.54	341.67	341.51	341.67	11602.0
2020-10-26 06:10:00	SPY	ETF	341.64	341.87	341.64	341.87	2560.0
2020-10-26 06:15:00	SPY	ETF	341.87	341.93	341.81	341.9	2720.0
2020-10-26 06:20:00	SPY	ETF	341.89	342.0	341.89	342.0	2218.0
2020-10-26 06:25:00	SPY	ETF	341.95	342.0	341.95	342.0	1045.0
2020-10-26 06:30:00	SPY	ETF	341.98	341.99	341.9	341.9	4424.0
2020-10-26 06:35:00	SPY	ETF	342.01	342.03	341.99	341.99	926.0
2020-10-26 06:40:00	SPY	ETF	341.96	341.96	341.8	341.8	2086.0
2020-10-26 06:45:00	SPY	ETF	341.75	341.85	341.75	341.85	1950.0
2020-10-26 06:50:00	SPY	ETF	341.9	341.95	341.9	341.95	2886.0
2020-10-26 06:55:00	SPY	ETF	341.95	342.02	341.95	342.02	450.0
2020-10-26 07:00:00	SPY	ETF	342.06	342.36	342.05	342.35	12829.0
2020-10-26 07:05:00	SPY	ETF	342.35	342.43	342.3	342.31	31344.0
2020-10-26 07:10:00	SPY	ETF	342.31	342.36	342.27	342.36	7945.0
2020-10-26 07:15:00	SPY	ETF	342.41	342.41	342.26	342.3	9200.0
2020-10-26 07:20:00	SPY	ETF	342.33	342.33	342.07	342.16	15823.0
2020-10-26 07:25:00	SPY	ETF	342.18	342.19	342.15	342.17	2855.0
2020-10-26 07:30:00	SPY	ETF	342.15	342.17	342.06	342.11	11882.0
2020-10-26 07:35:00	SPY	ETF	342.12	342.24	342.07	342.24	5495.0
2020-10-26 07:40:00	SPY	ETF	342.21	342.24	342.05	342.1	25162.0
2020-10-26 07:45:00	SPY	ETF	342.1	342.11	342.02	342.04	27875.0
2020-10-26 07:50:00	SPY	ETF	342.03	342.03	341.75	341.78	57455.0
2020-10-26 07:55:00	SPY	ETF	341.77	341.87	341.7	341.76	21926.0
2020-10-26 08:00:00	SPY	ETF	341.78	343.71	341.67	341.67	70957.0
2020-10-26 08:05:00	SPY	ETF	341.68	341.74	341.59	341.7	61944.0
2020-10-26 08:10:00	SPY	ETF	341.64	341.64	341.43	341.5	38076.0
2020-10-26 08:15:00	SPY	ETF	341.41	341.65	341.4	341.65	38685.0

> showing 50 of 76,763 rows — these rows as CSV

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