PREVIEW / etf_5min / 2019-10-17

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-10-17.parquet
  size:    1.4 MB
  rows:    60,053

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
2019-10-17 04:00:00	SPY	ETF	298.75	298.75	298.67	298.7	2950.0
2019-10-17 04:10:00	SPY	ETF	298.95	298.95	298.95	298.95	190.0
2019-10-17 04:15:00	SPY	ETF	298.88	298.88	298.88	298.88	400.0
2019-10-17 04:20:00	SPY	ETF	298.85	298.85	298.85	298.85	270.0
2019-10-17 04:25:00	SPY	ETF	298.8	298.8	298.8	298.8	1200.0
2019-10-17 04:30:00	SPY	ETF	298.78	298.78	298.78	298.78	900.0
2019-10-17 04:35:00	SPY	ETF	298.8	299.22	298.8	299.22	4686.0
2019-10-17 05:20:00	SPY	ETF	298.84	298.84	298.84	298.84	300.0
2019-10-17 05:25:00	SPY	ETF	299.06	299.06	299.06	299.06	130.0
2019-10-17 05:30:00	SPY	ETF	299.19	299.7	299.19	299.7	10413.0
2019-10-17 05:35:00	SPY	ETF	299.8	300.05	299.8	299.85	8271.0
2019-10-17 05:40:00	SPY	ETF	299.8	299.82	299.58	299.74	7620.0
2019-10-17 05:45:00	SPY	ETF	299.9	299.9	299.74	299.75	2573.0
2019-10-17 05:50:00	SPY	ETF	299.82	299.96	299.76	299.96	4314.0
2019-10-17 05:55:00	SPY	ETF	299.9	299.95	299.82	299.82	2457.0
2019-10-17 06:00:00	SPY	ETF	299.85	299.95	299.81	299.81	4061.0
2019-10-17 06:05:00	SPY	ETF	299.94	300.01	299.94	300.0	11050.0
2019-10-17 06:10:00	SPY	ETF	299.98	300.1	299.83	299.93	4100.0
2019-10-17 06:15:00	SPY	ETF	299.98	299.98	299.9	299.9	1352.0
2019-10-17 06:20:00	SPY	ETF	299.89	299.93	299.89	299.93	502.0
2019-10-17 06:25:00	SPY	ETF	299.86	299.88	299.78	299.8	2505.0
2019-10-17 06:30:00	SPY	ETF	299.71	299.71	299.58	299.66	6110.0
2019-10-17 06:35:00	SPY	ETF	299.67	299.7	299.66	299.7	2105.0
2019-10-17 06:40:00	SPY	ETF	299.74	299.76	299.74	299.76	616.0
2019-10-17 06:45:00	SPY	ETF	299.79	299.83	299.79	299.83	2800.0
2019-10-17 06:50:00	SPY	ETF	299.66	299.66	299.63	299.63	466.0
2019-10-17 06:55:00	SPY	ETF	299.73	299.73	299.68	299.68	1842.0
2019-10-17 07:00:00	SPY	ETF	299.68	299.69	299.4	299.4	11202.0
2019-10-17 07:05:00	SPY	ETF	299.4	299.46	299.33	299.42	18989.0
2019-10-17 07:10:00	SPY	ETF	299.47	299.47	299.41	299.45	6388.0
2019-10-17 07:15:00	SPY	ETF	299.55	299.58	299.54	299.58	7185.0
2019-10-17 07:20:00	SPY	ETF	299.58	299.7	299.58	299.68	11623.0
2019-10-17 07:25:00	SPY	ETF	299.65	299.86	299.65	299.76	42434.0
2019-10-17 07:30:00	SPY	ETF	299.83	299.83	299.71	299.8	6832.0
2019-10-17 07:35:00	SPY	ETF	299.72	299.72	299.7	299.7	2850.0
2019-10-17 07:40:00	SPY	ETF	299.67	299.67	299.66	299.66	600.0
2019-10-17 07:45:00	SPY	ETF	299.65	299.75	299.63	299.75	28326.0
2019-10-17 07:50:00	SPY	ETF	299.77	299.85	299.77	299.85	16413.0
2019-10-17 07:55:00	SPY	ETF	299.81	299.81	299.5	299.5	17335.0
2019-10-17 08:00:00	SPY	ETF	299.53	299.8099	298.15	299.6	54308.0
2019-10-17 08:05:00	SPY	ETF	299.57	299.57	299.33	299.4	15233.0
2019-10-17 08:10:00	SPY	ETF	299.42	299.42	299.14	299.14	32010.0
2019-10-17 08:15:00	SPY	ETF	299.15	299.23	299.1	299.23	26402.0
2019-10-17 08:20:00	SPY	ETF	299.24	299.3	299.21	299.24	25459.0
2019-10-17 08:25:00	SPY	ETF	299.27	299.37	299.26	299.35	19473.0
2019-10-17 08:30:00	SPY	ETF	299.34	299.42	299.34	299.4	27699.0
2019-10-17 08:35:00	SPY	ETF	299.41	299.44	299.33	299.42	45173.0
2019-10-17 08:40:00	SPY	ETF	299.45	299.6	299.45	299.53	19887.0
2019-10-17 08:45:00	SPY	ETF	298.4	299.57	298.4	299.5	6558.0
2019-10-17 08:50:00	SPY	ETF	299.51	299.6499	299.48	299.59	25547.0

> showing 50 of 60,053 rows — these rows as CSV

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