PREVIEW / etf_5min / 2019-11-20

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-11-20.parquet
  size:    1.5 MB
  rows:    63,293

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-11-20 04:00:00	SPY	ETF	310.64	310.64	310.5	310.5	4025.0
2019-11-20 04:05:00	SPY	ETF	310.54	310.54	310.54	310.54	400.0
2019-11-20 04:10:00	SPY	ETF	310.5	310.5	310.49	310.49	200.0
2019-11-20 04:15:00	SPY	ETF	310.49	310.6	310.49	310.6	1025.0
2019-11-20 04:20:00	SPY	ETF	310.65	310.74	310.65	310.74	1400.0
2019-11-20 04:25:00	SPY	ETF	310.73	310.78	310.73	310.78	500.0
2019-11-20 04:35:00	SPY	ETF	310.94	310.94	310.88	310.88	1152.0
2019-11-20 04:45:00	SPY	ETF	310.99	310.99	310.85	310.85	600.0
2019-11-20 04:50:00	SPY	ETF	310.94	310.94	310.88	310.88	600.0
2019-11-20 04:55:00	SPY	ETF	310.84	310.89	310.84	310.89	1200.0
2019-11-20 05:00:00	SPY	ETF	310.83	310.83	310.83	310.83	100.0
2019-11-20 05:05:00	SPY	ETF	310.8	310.8	310.75	310.75	215.0
2019-11-20 05:10:00	SPY	ETF	310.72	310.72	310.62	310.64	1785.0
2019-11-20 05:15:00	SPY	ETF	310.64	310.64	310.64	310.64	1000.0
2019-11-20 05:20:00	SPY	ETF	310.67	310.77	310.65	310.74	2600.0
2019-11-20 05:25:00	SPY	ETF	310.72	310.72	310.6	310.63	500.0
2019-11-20 05:40:00	SPY	ETF	310.58	310.64	310.58	310.62	6050.0
2019-11-20 05:45:00	SPY	ETF	310.67	310.7	310.67	310.7	1200.0
2019-11-20 05:50:00	SPY	ETF	310.68	310.7	310.67	310.68	32110.0
2019-11-20 05:55:00	SPY	ETF	310.7	310.7	310.65	310.68	20300.0
2019-11-20 06:00:00	SPY	ETF	310.77	310.77	310.7	310.7	535.0
2019-11-20 06:05:00	SPY	ETF	310.7	310.73	310.4	310.4	8100.0
2019-11-20 06:10:00	SPY	ETF	310.5	310.6	310.5	310.6	1199.0
2019-11-20 06:15:00	SPY	ETF	310.63	310.63	310.6	310.6	1405.0
2019-11-20 06:20:00	SPY	ETF	310.58	310.58	310.39	310.39	21285.0
2019-11-20 06:25:00	SPY	ETF	310.39	310.5	310.39	310.5	6285.0
2019-11-20 06:30:00	SPY	ETF	310.52	310.55	310.52	310.55	1300.0
2019-11-20 06:35:00	SPY	ETF	310.65	310.71	310.65	310.68	2515.0
2019-11-20 06:40:00	SPY	ETF	310.69	310.73	310.69	310.73	1450.0
2019-11-20 06:45:00	SPY	ETF	310.7	310.75	310.7	310.71	1000.0
2019-11-20 06:50:00	SPY	ETF	310.71	310.95	310.71	310.95	41904.0
2019-11-20 06:55:00	SPY	ETF	310.95	311.08	310.9	311.08	44904.0
2019-11-20 07:00:00	SPY	ETF	311.04	311.09	310.95	310.98	45564.0
2019-11-20 07:05:00	SPY	ETF	310.98	311.04	310.93	311.04	5976.0
2019-11-20 07:10:00	SPY	ETF	311.1	311.2	311.09	311.09	2557.0
2019-11-20 07:15:00	SPY	ETF	311.16	311.16	311.09	311.12	6222.0
2019-11-20 07:20:00	SPY	ETF	311.1	311.12	311.06	311.1	8677.0
2019-11-20 07:25:00	SPY	ETF	311.09	311.12	311.05	311.09	4963.0
2019-11-20 07:30:00	SPY	ETF	311.09	311.16	311.05	311.16	5292.0
2019-11-20 07:35:00	SPY	ETF	311.11	311.16	311.07	311.08	10851.0
2019-11-20 07:40:00	SPY	ETF	311.1	311.16	310.97	311.02	7651.0
2019-11-20 07:45:00	SPY	ETF	310.99	311.11	310.99	311.11	2350.0
2019-11-20 07:50:00	SPY	ETF	311.11	311.11	310.96	310.99	7283.0
2019-11-20 07:55:00	SPY	ETF	310.96	310.96	310.88	310.93	12152.0
2019-11-20 08:00:00	SPY	ETF	311.04	311.46	310.66	310.9	17123.0
2019-11-20 08:05:00	SPY	ETF	310.89	311.16	310.89	311.01	19562.0
2019-11-20 08:10:00	SPY	ETF	311.0	311.0	310.94	310.94	3593.0
2019-11-20 08:15:00	SPY	ETF	310.96	311.07	310.96	311.07	12905.0
2019-11-20 08:20:00	SPY	ETF	311.08	311.21	311.08	311.13	8693.0
2019-11-20 08:25:00	SPY	ETF	311.14	311.15	311.1	311.11	10302.0

> showing 50 of 63,293 rows — these rows as CSV

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