PREVIEW / etf_5min / 2019-01-23

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-01-23.parquet
  size:    1.4 MB
  rows:    62,936

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-23 04:05:00	SPY	ETF	262.72	262.79	262.72	262.79	1666.0
2019-01-23 04:10:00	SPY	ETF	262.79	262.84	262.79	262.84	950.0
2019-01-23 04:15:00	SPY	ETF	262.98	263.0	262.98	263.0	1500.0
2019-01-23 04:30:00	SPY	ETF	263.0	263.0	263.0	263.0	100.0
2019-01-23 04:35:00	SPY	ETF	262.95	262.99	262.95	262.99	400.0
2019-01-23 04:40:00	SPY	ETF	263.09	263.09	263.09	263.09	100.0
2019-01-23 04:45:00	SPY	ETF	263.11	263.19	263.09	263.19	2084.0
2019-01-23 04:50:00	SPY	ETF	263.21	263.21	263.21	263.21	500.0
2019-01-23 04:55:00	SPY	ETF	263.18	263.32	263.18	263.32	1360.0
2019-01-23 05:00:00	SPY	ETF	263.23	263.23	263.23	263.23	300.0
2019-01-23 05:05:00	SPY	ETF	263.23	263.23	263.23	263.23	100.0
2019-01-23 05:10:00	SPY	ETF	263.31	263.31	263.26	263.26	600.0
2019-01-23 05:15:00	SPY	ETF	263.25	263.25	263.23	263.23	292.0
2019-01-23 05:20:00	SPY	ETF	263.33	263.36	263.33	263.36	500.0
2019-01-23 05:30:00	SPY	ETF	263.35	263.35	263.35	263.35	500.0
2019-01-23 05:35:00	SPY	ETF	263.33	263.33	263.3	263.3	1750.0
2019-01-23 05:40:00	SPY	ETF	263.28	263.29	263.28	263.29	900.0
2019-01-23 05:45:00	SPY	ETF	263.35	263.47	263.35	263.47	2885.0
2019-01-23 05:50:00	SPY	ETF	263.46	263.57	263.36	263.36	6347.0
2019-01-23 05:55:00	SPY	ETF	263.32	263.33	263.3	263.3	26110.0
2019-01-23 06:00:00	SPY	ETF	263.33	263.4	263.33	263.38	4500.0
2019-01-23 06:05:00	SPY	ETF	263.3	263.32	263.27	263.27	700.0
2019-01-23 06:10:00	SPY	ETF	263.25	263.3	263.11	263.11	14100.0
2019-01-23 06:15:00	SPY	ETF	263.2	263.2	263.19	263.2	1319.0
2019-01-23 06:20:00	SPY	ETF	263.1	263.22	263.1	263.22	3107.0
2019-01-23 06:25:00	SPY	ETF	263.24	263.24	263.07	263.12	3452.0
2019-01-23 06:30:00	SPY	ETF	263.2	263.27	263.19	263.19	3688.0
2019-01-23 06:35:00	SPY	ETF	263.22	263.36	263.22	263.36	5666.0
2019-01-23 06:40:00	SPY	ETF	263.32	263.32	263.32	263.32	2000.0
2019-01-23 06:45:00	SPY	ETF	263.35	263.4	263.29	263.3	12725.0
2019-01-23 06:50:00	SPY	ETF	263.25	263.42	263.25	263.4	11825.0
2019-01-23 06:55:00	SPY	ETF	263.42	263.58	263.42	263.54	21300.0
2019-01-23 07:00:00	SPY	ETF	263.47	263.59	263.43	263.5	39023.0
2019-01-23 07:05:00	SPY	ETF	263.52	263.65	263.5	263.65	26115.0
2019-01-23 07:10:00	SPY	ETF	263.66	263.78	263.64	263.72	57855.0
2019-01-23 07:15:00	SPY	ETF	263.74	263.88	263.74	263.86	24211.0
2019-01-23 07:20:00	SPY	ETF	263.88	264.08	263.79	264.08	18798.0
2019-01-23 07:25:00	SPY	ETF	264.07	264.17	263.99	264.14	66539.0
2019-01-23 07:30:00	SPY	ETF	264.09	264.09	263.93	263.93	14777.0
2019-01-23 07:35:00	SPY	ETF	264.0	264.2	264.0	264.1	25431.0
2019-01-23 07:40:00	SPY	ETF	264.12	264.19	264.1	264.1	22238.0
2019-01-23 07:45:00	SPY	ETF	264.05	264.07	264.0	264.0	6922.0
2019-01-23 07:50:00	SPY	ETF	263.97	263.97	263.87	263.9	29397.0
2019-01-23 07:55:00	SPY	ETF	263.89	263.99	263.89	263.9	12232.0
2019-01-23 08:00:00	SPY	ETF	263.92	264.2	262.31	263.99	353435.0
2019-01-23 08:05:00	SPY	ETF	264.01	264.14	263.99	264.06	21132.0
2019-01-23 08:10:00	SPY	ETF	264.03	264.07	263.94	263.96	14501.0
2019-01-23 08:15:00	SPY	ETF	263.93	263.96	263.83	263.86	35209.0
2019-01-23 08:20:00	SPY	ETF	263.89	263.91	263.7	263.72	34731.0
2019-01-23 08:25:00	SPY	ETF	263.78	263.78	263.71	263.71	9971.0

> showing 50 of 62,936 rows — these rows as CSV

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