PREVIEW / etf_5min / 2019-12-27

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-12-27.parquet
  size:    1.4 MB
  rows:    63,321

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-27 04:00:00	SPY	ETF	323.61	323.64	323.61	323.62	782.0
2019-12-27 04:05:00	SPY	ETF	323.6	323.6	323.55	323.55	1200.0
2019-12-27 04:10:00	SPY	ETF	323.55	323.6	323.54	323.55	700.0
2019-12-27 04:15:00	SPY	ETF	323.59	323.59	323.59	323.59	360.0
2019-12-27 04:20:00	SPY	ETF	323.67	323.67	323.67	323.67	100.0
2019-12-27 04:25:00	SPY	ETF	323.55	323.57	323.55	323.57	1240.0
2019-12-27 04:30:00	SPY	ETF	323.62	323.62	323.62	323.62	174.0
2019-12-27 04:35:00	SPY	ETF	323.57	323.57	323.53	323.53	500.0
2019-12-27 04:40:00	SPY	ETF	323.58	323.58	323.58	323.58	200.0
2019-12-27 05:10:00	SPY	ETF	323.72	323.77	323.72	323.77	794.0
2019-12-27 05:15:00	SPY	ETF	323.84	323.84	323.84	323.84	170.0
2019-12-27 05:20:00	SPY	ETF	323.82	323.89	323.81	323.81	2596.0
2019-12-27 05:30:00	SPY	ETF	323.95	324.03	323.95	324.03	446.0
2019-12-27 05:40:00	SPY	ETF	323.91	323.91	323.91	323.91	300.0
2019-12-27 05:50:00	SPY	ETF	323.96	323.96	323.89	323.96	2500.0
2019-12-27 05:55:00	SPY	ETF	323.95	323.95	323.95	323.95	400.0
2019-12-27 06:00:00	SPY	ETF	323.94	324.03	323.94	324.03	1948.0
2019-12-27 06:05:00	SPY	ETF	324.03	324.03	323.94	323.94	811.0
2019-12-27 06:10:00	SPY	ETF	323.84	323.92	323.84	323.92	1680.0
2019-12-27 06:20:00	SPY	ETF	323.89	323.94	323.89	323.94	400.0
2019-12-27 06:25:00	SPY	ETF	323.84	323.87	323.84	323.87	1223.0
2019-12-27 06:35:00	SPY	ETF	323.9	323.94	323.9	323.94	500.0
2019-12-27 06:40:00	SPY	ETF	323.95	324.02	323.94	324.0	2300.0
2019-12-27 06:50:00	SPY	ETF	323.97	323.98	323.95	323.95	1470.0
2019-12-27 06:55:00	SPY	ETF	323.95	323.95	323.95	323.95	1900.0
2019-12-27 07:00:00	SPY	ETF	323.95	323.99	323.89	323.99	6860.0
2019-12-27 07:05:00	SPY	ETF	323.99	323.99	323.94	323.94	301.0
2019-12-27 07:10:00	SPY	ETF	323.95	323.95	323.92	323.92	798.0
2019-12-27 07:15:00	SPY	ETF	323.91	323.91	323.91	323.91	300.0
2019-12-27 07:20:00	SPY	ETF	323.91	323.94	323.89	323.93	15257.0
2019-12-27 07:30:00	SPY	ETF	323.99	324.0	323.99	323.99	608.0
2019-12-27 07:35:00	SPY	ETF	323.96	323.96	323.88	323.88	6824.0
2019-12-27 07:40:00	SPY	ETF	323.95	323.95	323.91	323.95	2361.0
2019-12-27 07:45:00	SPY	ETF	323.9	323.9	323.9	323.9	151.0
2019-12-27 07:50:00	SPY	ETF	323.9	323.92	323.9	323.9	695.0
2019-12-27 07:55:00	SPY	ETF	323.86	323.86	323.86	323.86	307.0
2019-12-27 08:00:00	SPY	ETF	323.88	323.96	323.5	323.88	17502.0
2019-12-27 08:05:00	SPY	ETF	323.91	323.95	323.91	323.95	7675.0
2019-12-27 08:10:00	SPY	ETF	323.91	324.02	323.91	323.98	3860.0
2019-12-27 08:15:00	SPY	ETF	323.96	324.05	323.94	324.05	18239.0
2019-12-27 08:20:00	SPY	ETF	324.04	324.04	323.93	323.93	12238.0
2019-12-27 08:25:00	SPY	ETF	323.94	323.97	323.92	323.95	20605.0
2019-12-27 08:30:00	SPY	ETF	323.97	324.06	323.95	324.04	22903.0
2019-12-27 08:35:00	SPY	ETF	324.02	324.02	323.95	323.95	3810.0
2019-12-27 08:40:00	SPY	ETF	323.96	323.96	323.93	323.94	11995.0
2019-12-27 08:45:00	SPY	ETF	323.91	323.91	322.94	322.94	117750.0
2019-12-27 08:50:00	SPY	ETF	323.9	323.93	323.86	323.88	12054.0
2019-12-27 08:55:00	SPY	ETF	323.83	323.83	323.73	323.74	13774.0
2019-12-27 09:00:00	SPY	ETF	323.75	323.8	323.74	323.77	14112.0
2019-12-27 09:05:00	SPY	ETF	323.8	323.84	323.74	323.74	14101.0

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

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