PREVIEW / etf_5min / 2019-01-08

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-01-08.parquet
  size:    1.5 MB
  rows:    66,314

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-01-08 04:00:00	SPY	ETF	255.4	255.81	255.4	255.81	3853.0
2019-01-08 04:05:00	SPY	ETF	255.85	255.87	255.81	255.87	2020.0
2019-01-08 04:10:00	SPY	ETF	255.84	255.84	255.77	255.77	1600.0
2019-01-08 04:15:00	SPY	ETF	255.87	255.95	255.81	255.94	4091.0
2019-01-08 04:20:00	SPY	ETF	255.97	256.15	255.64	255.7	2564.0
2019-01-08 04:25:00	SPY	ETF	255.82	255.82	255.77	255.77	746.0
2019-01-08 04:30:00	SPY	ETF	255.71	255.71	255.56	255.56	2700.0
2019-01-08 04:35:00	SPY	ETF	255.62	255.72	255.62	255.72	1238.0
2019-01-08 04:40:00	SPY	ETF	255.8	255.8	255.72	255.72	1238.0
2019-01-08 04:45:00	SPY	ETF	255.64	255.64	254.52	255.45	33632.0
2019-01-08 04:50:00	SPY	ETF	255.46	255.51	255.35	255.4	9804.0
2019-01-08 04:55:00	SPY	ETF	255.48	255.53	255.42	255.42	3003.0
2019-01-08 05:00:00	SPY	ETF	255.37	255.38	255.3	255.3	4646.0
2019-01-08 05:05:00	SPY	ETF	255.33	255.35	255.33	255.35	938.0
2019-01-08 05:10:00	SPY	ETF	255.28	255.4	255.28	255.4	2295.0
2019-01-08 05:15:00	SPY	ETF	255.35	255.49	255.35	255.49	3918.0
2019-01-08 05:20:00	SPY	ETF	255.46	255.5	255.45	255.45	3040.0
2019-01-08 05:25:00	SPY	ETF	255.45	255.5	255.41	255.5	3474.0
2019-01-08 05:30:00	SPY	ETF	255.37	255.54	255.37	255.5	1556.0
2019-01-08 05:35:00	SPY	ETF	255.55	255.72	255.55	255.72	6257.0
2019-01-08 05:40:00	SPY	ETF	255.65	255.7	255.62	255.7	6679.0
2019-01-08 05:45:00	SPY	ETF	255.7	255.72	255.58	255.65	2449.0
2019-01-08 05:50:00	SPY	ETF	255.7	255.84	255.7	255.73	3352.0
2019-01-08 05:55:00	SPY	ETF	255.83	255.92	255.83	255.87	3108.0
2019-01-08 06:00:00	SPY	ETF	255.83	255.83	255.77	255.8	1627.0
2019-01-08 06:05:00	SPY	ETF	255.82	255.84	255.82	255.84	600.0
2019-01-08 06:10:00	SPY	ETF	255.87	255.92	255.77	255.9	2560.0
2019-01-08 06:15:00	SPY	ETF	255.93	255.94	255.76	255.76	6470.0
2019-01-08 06:20:00	SPY	ETF	255.73	255.73	255.68	255.68	2000.0
2019-01-08 06:25:00	SPY	ETF	255.68	255.74	255.68	255.74	1335.0
2019-01-08 06:30:00	SPY	ETF	255.8	255.86	255.77	255.86	13515.0
2019-01-08 06:35:00	SPY	ETF	255.84	255.89	255.84	255.89	300.0
2019-01-08 06:40:00	SPY	ETF	255.91	256.11	255.91	256.09	17380.0
2019-01-08 06:45:00	SPY	ETF	256.04	256.08	256.0	256.07	54266.0
2019-01-08 06:50:00	SPY	ETF	256.07	256.43	256.07	256.32	87607.0
2019-01-08 06:55:00	SPY	ETF	256.32	256.38	256.21	256.21	9100.0
2019-01-08 07:00:00	SPY	ETF	256.25	256.39	256.24	256.35	30378.0
2019-01-08 07:05:00	SPY	ETF	256.3	256.3	256.18	256.18	19166.0
2019-01-08 07:10:00	SPY	ETF	256.21	256.21	256.09	256.1	23712.0
2019-01-08 07:15:00	SPY	ETF	256.11	256.12	256.03	256.1	52307.0
2019-01-08 07:20:00	SPY	ETF	256.11	256.12	255.94	256.0	46960.0
2019-01-08 07:25:00	SPY	ETF	256.01	256.02	255.89	255.95	48261.0
2019-01-08 07:30:00	SPY	ETF	255.91	255.96	255.9	255.9	74095.0
2019-01-08 07:35:00	SPY	ETF	255.9	256.0	255.9	255.93	24277.0
2019-01-08 07:40:00	SPY	ETF	255.93	255.93	255.81	255.81	20187.0
2019-01-08 07:45:00	SPY	ETF	255.82	255.88	255.7	255.7	27818.0
2019-01-08 07:50:00	SPY	ETF	255.7	255.96	255.66	255.91	28047.0
2019-01-08 07:55:00	SPY	ETF	255.94	256.08	255.57	255.92	50078.0
2019-01-08 08:00:00	SPY	ETF	255.9	256.35	254.565	256.12	109175.0
2019-01-08 08:05:00	SPY	ETF	256.09	256.12	256.0	256.0	36219.0

> showing 50 of 66,314 rows — these rows as CSV

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