PREVIEW / etf_5min / 2019-01-07

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-01-07.parquet
  size:    1.6 MB
  rows:    67,250

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-07 04:00:00	SPY	ETF	252.6	252.72	252.45	252.63	4119.0
2019-01-07 04:05:00	SPY	ETF	252.64	252.64	252.56	252.56	1586.0
2019-01-07 04:10:00	SPY	ETF	252.55	252.55	252.51	252.51	628.0
2019-01-07 04:15:00	SPY	ETF	252.46	252.49	252.46	252.49	1495.0
2019-01-07 04:20:00	SPY	ETF	252.3	252.4	252.3	252.39	1809.0
2019-01-07 04:25:00	SPY	ETF	252.31	252.31	252.25	252.3	2050.0
2019-01-07 04:30:00	SPY	ETF	252.11	252.11	251.94	251.94	2498.0
2019-01-07 04:35:00	SPY	ETF	252.19	252.24	252.07	252.07	1006.0
2019-01-07 04:45:00	SPY	ETF	251.95	252.02	251.94	252.02	2204.0
2019-01-07 04:50:00	SPY	ETF	252.17	252.22	251.87	251.94	3894.0
2019-01-07 04:55:00	SPY	ETF	251.99	251.99	251.98	251.98	400.0
2019-01-07 05:00:00	SPY	ETF	251.95	251.95	251.87	251.87	604.0
2019-01-07 05:05:00	SPY	ETF	252.11	252.26	252.11	252.26	1939.0
2019-01-07 05:20:00	SPY	ETF	252.21	252.21	252.21	252.21	500.0
2019-01-07 05:25:00	SPY	ETF	252.24	252.3	252.24	252.3	1130.0
2019-01-07 05:30:00	SPY	ETF	252.27	252.27	252.06	252.06	3026.0
2019-01-07 05:35:00	SPY	ETF	252.02	252.02	251.93	251.98	3979.0
2019-01-07 05:40:00	SPY	ETF	252.02	252.26	252.02	252.18	1529.0
2019-01-07 05:45:00	SPY	ETF	252.2	252.32	252.2	252.3	2050.0
2019-01-07 05:50:00	SPY	ETF	252.32	252.34	252.25	252.34	2161.0
2019-01-07 05:55:00	SPY	ETF	252.34	252.34	252.18	252.21	2763.0
2019-01-07 06:00:00	SPY	ETF	252.22	252.25	251.98	252.01	4587.0
2019-01-07 06:05:00	SPY	ETF	252.09	252.15	252.02	252.02	1604.0
2019-01-07 06:10:00	SPY	ETF	252.0	252.0	251.9	251.95	3272.0
2019-01-07 06:15:00	SPY	ETF	251.94	251.94	251.8	251.89	1406.0
2019-01-07 06:20:00	SPY	ETF	251.84	251.88	251.7	251.79	6016.0
2019-01-07 06:25:00	SPY	ETF	251.88	251.9	251.88	251.9	1308.0
2019-01-07 06:30:00	SPY	ETF	251.9	251.9	251.71	251.71	15228.0
2019-01-07 06:35:00	SPY	ETF	251.7	251.75	251.59	251.75	13554.0
2019-01-07 06:40:00	SPY	ETF	251.73	251.8	251.73	251.8	2600.0
2019-01-07 06:45:00	SPY	ETF	251.82	252.15	251.82	251.91	7611.0
2019-01-07 06:50:00	SPY	ETF	251.96	252.04	251.95	252.03	8320.0
2019-01-07 06:55:00	SPY	ETF	251.96	252.12	251.92	252.1	9604.0
2019-01-07 07:00:00	SPY	ETF	252.08	252.14	251.91	252.1	21071.0
2019-01-07 07:05:00	SPY	ETF	252.12	252.15	252.05	252.05	14326.0
2019-01-07 07:10:00	SPY	ETF	252.05	252.12	251.95	252.1	21415.0
2019-01-07 07:15:00	SPY	ETF	252.1	252.42	252.1	252.4	31144.0
2019-01-07 07:20:00	SPY	ETF	252.4	252.45	252.32	252.34	39369.0
2019-01-07 07:25:00	SPY	ETF	252.37	252.39	252.2	252.25	41750.0
2019-01-07 07:30:00	SPY	ETF	252.32	252.47	252.26	252.28	4213.0
2019-01-07 07:35:00	SPY	ETF	252.34	252.45	252.16	252.19	14974.0
2019-01-07 07:40:00	SPY	ETF	252.16	252.25	252.14	252.2	11593.0
2019-01-07 07:45:00	SPY	ETF	252.27	252.29	252.16	252.22	27827.0
2019-01-07 07:50:00	SPY	ETF	252.21	252.37	252.21	252.35	25086.0
2019-01-07 07:55:00	SPY	ETF	252.44	252.58	252.44	252.46	11887.0
2019-01-07 08:00:00	SPY	ETF	252.1301	253.3	252.0	252.48	48364.0
2019-01-07 08:05:00	SPY	ETF	253.18	253.18	252.4	252.63	386840.0
2019-01-07 08:10:00	SPY	ETF	252.65	252.65	252.39	252.46	12302.0
2019-01-07 08:15:00	SPY	ETF	252.46	252.54	252.33	252.49	21035.0
2019-01-07 08:20:00	SPY	ETF	252.47	252.54	252.31	252.41	69582.0

> showing 50 of 67,250 rows — these rows as CSV

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