PREVIEW / etf_5min / 2019-12-19

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-12-19.parquet
  size:    1.5 MB
  rows:    63,511

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-12-19 04:00:00	SPY	ETF	319.92	319.95	319.9	319.9	983.0
2019-12-19 04:10:00	SPY	ETF	319.91	319.91	319.91	319.91	400.0
2019-12-19 04:20:00	SPY	ETF	319.85	319.86	319.85	319.86	266.0
2019-12-19 04:25:00	SPY	ETF	319.86	319.88	319.86	319.88	500.0
2019-12-19 04:30:00	SPY	ETF	319.86	319.93	319.86	319.93	717.0
2019-12-19 04:40:00	SPY	ETF	319.93	320.03	319.93	319.99	1523.0
2019-12-19 04:45:00	SPY	ETF	319.99	320.0	319.99	320.0	2503.0
2019-12-19 04:50:00	SPY	ETF	320.05	320.06	320.05	320.06	208.0
2019-12-19 04:55:00	SPY	ETF	320.08	320.08	320.08	320.08	100.0
2019-12-19 05:05:00	SPY	ETF	320.08	320.08	320.06	320.06	403.0
2019-12-19 05:10:00	SPY	ETF	319.99	319.99	319.99	319.99	1000.0
2019-12-19 05:15:00	SPY	ETF	320.02	320.02	320.02	320.02	100.0
2019-12-19 05:20:00	SPY	ETF	320.0	320.0	320.0	320.0	300.0
2019-12-19 05:25:00	SPY	ETF	319.95	319.95	319.95	319.95	103.0
2019-12-19 05:40:00	SPY	ETF	320.09	320.09	320.09	320.09	1653.0
2019-12-19 05:45:00	SPY	ETF	320.11	320.11	320.08	320.08	1404.0
2019-12-19 05:50:00	SPY	ETF	320.06	320.06	320.06	320.06	300.0
2019-12-19 05:55:00	SPY	ETF	320.04	320.04	320.04	320.04	1000.0
2019-12-19 06:05:00	SPY	ETF	320.02	320.02	320.01	320.01	500.0
2019-12-19 06:15:00	SPY	ETF	320.05	320.05	320.01	320.01	703.0
2019-12-19 06:20:00	SPY	ETF	320.0	320.0	319.9	319.93	723.0
2019-12-19 06:25:00	SPY	ETF	319.88	319.89	319.88	319.89	218.0
2019-12-19 06:35:00	SPY	ETF	319.91	319.91	319.88	319.88	300.0
2019-12-19 06:40:00	SPY	ETF	319.86	319.89	319.86	319.86	997.0
2019-12-19 06:45:00	SPY	ETF	319.86	319.86	319.86	319.86	500.0
2019-12-19 06:50:00	SPY	ETF	319.86	319.86	319.86	319.86	285.0
2019-12-19 06:55:00	SPY	ETF	319.93	319.97	319.93	319.95	600.0
2019-12-19 07:00:00	SPY	ETF	319.91	320.0	319.91	320.0	4464.0
2019-12-19 07:05:00	SPY	ETF	319.95	319.97	319.93	319.97	3800.0
2019-12-19 07:10:00	SPY	ETF	319.97	319.98	319.88	319.88	8233.0
2019-12-19 07:15:00	SPY	ETF	319.91	319.94	319.91	319.91	2430.0
2019-12-19 07:20:00	SPY	ETF	319.95	319.95	319.95	319.95	1298.0
2019-12-19 07:25:00	SPY	ETF	319.93	319.93	319.93	319.93	300.0
2019-12-19 07:30:00	SPY	ETF	319.95	319.95	319.92	319.92	1816.0
2019-12-19 07:35:00	SPY	ETF	319.9	319.9	319.73	319.74	3795.0
2019-12-19 07:40:00	SPY	ETF	319.78	319.8	319.78	319.8	2450.0
2019-12-19 07:45:00	SPY	ETF	319.76	319.76	319.73	319.74	4827.0
2019-12-19 07:50:00	SPY	ETF	319.76	319.78	319.76	319.77	1772.0
2019-12-19 07:55:00	SPY	ETF	319.7	319.71	319.59	319.71	33963.0
2019-12-19 08:00:00	SPY	ETF	319.9099	319.97	319.61	319.62	13590.0
2019-12-19 08:05:00	SPY	ETF	319.64	319.69	319.6	319.67	33989.0
2019-12-19 08:10:00	SPY	ETF	319.68	319.7	319.61	319.65	42719.0
2019-12-19 08:15:00	SPY	ETF	319.64	319.65	319.58	319.6199	55927.0
2019-12-19 08:20:00	SPY	ETF	319.62	319.68	319.62	319.67	4578.0
2019-12-19 08:25:00	SPY	ETF	319.67	319.6898	319.66	319.6898	2633.0
2019-12-19 08:30:00	SPY	ETF	319.65	319.65	319.52	319.58	53211.0
2019-12-19 08:35:00	SPY	ETF	319.56	319.56	319.43	319.4899	41642.0
2019-12-19 08:40:00	SPY	ETF	319.51	319.59	319.51	319.57	70641.0
2019-12-19 08:45:00	SPY	ETF	319.59	319.6	319.54	319.6	8724.0
2019-12-19 08:50:00	SPY	ETF	319.62	319.63	319.55	319.57	14059.0

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

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