PREVIEW / etf_5min / 2019-08-28

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-08-28.parquet
  size:    1.4 MB
  rows:    61,485

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-08-28 04:00:00	SPY	ETF	287.02	287.02	286.9	286.9	1333.0
2019-08-28 04:05:00	SPY	ETF	287.09	287.62	287.09	287.62	3417.0
2019-08-28 04:10:00	SPY	ETF	287.49	287.49	287.45	287.45	269.0
2019-08-28 04:20:00	SPY	ETF	287.52	287.52	287.52	287.52	100.0
2019-08-28 04:25:00	SPY	ETF	287.55	287.55	287.5	287.5	1000.0
2019-08-28 04:30:00	SPY	ETF	287.67	287.67	287.56	287.56	1000.0
2019-08-28 04:35:00	SPY	ETF	287.54	287.54	286.66	286.66	2680.0
2019-08-28 04:40:00	SPY	ETF	286.5	286.73	286.5	286.5	1942.0
2019-08-28 04:45:00	SPY	ETF	286.71	286.72	286.71	286.72	204.0
2019-08-28 04:50:00	SPY	ETF	286.78	287.05	286.78	287.0	3108.0
2019-08-28 04:55:00	SPY	ETF	287.07	287.07	287.02	287.02	901.0
2019-08-28 05:05:00	SPY	ETF	287.12	287.27	287.12	287.27	300.0
2019-08-28 05:10:00	SPY	ETF	287.25	287.32	287.16	287.16	804.0
2019-08-28 05:15:00	SPY	ETF	287.25	287.27	287.25	287.27	700.0
2019-08-28 05:20:00	SPY	ETF	287.4	287.4	287.4	287.4	470.0
2019-08-28 05:25:00	SPY	ETF	287.19	287.19	287.19	287.19	119.0
2019-08-28 05:30:00	SPY	ETF	287.05	287.05	287.05	287.05	134.0
2019-08-28 05:35:00	SPY	ETF	287.02	287.02	286.96	286.96	500.0
2019-08-28 05:40:00	SPY	ETF	286.92	286.95	286.92	286.95	504.0
2019-08-28 05:45:00	SPY	ETF	287.07	287.07	286.92	286.92	1900.0
2019-08-28 05:55:00	SPY	ETF	286.99	286.99	286.9	286.9	700.0
2019-08-28 06:00:00	SPY	ETF	287.12	287.47	287.12	287.47	5104.0
2019-08-28 06:05:00	SPY	ETF	287.3	287.32	287.29	287.29	900.0
2019-08-28 06:10:00	SPY	ETF	287.3	287.33	287.19	287.19	1015.0
2019-08-28 06:15:00	SPY	ETF	287.15	287.15	286.99	287.01	3336.0
2019-08-28 06:20:00	SPY	ETF	287.02	287.02	286.62	286.87	11917.0
2019-08-28 06:25:00	SPY	ETF	286.87	286.89	286.87	286.89	404.0
2019-08-28 06:30:00	SPY	ETF	287.01	287.06	287.01	287.03	900.0
2019-08-28 06:35:00	SPY	ETF	287.07	287.1	287.07	287.1	503.0
2019-08-28 06:40:00	SPY	ETF	286.85	286.87	286.85	286.87	700.0
2019-08-28 06:45:00	SPY	ETF	286.85	286.85	286.85	286.85	100.0
2019-08-28 06:50:00	SPY	ETF	286.88	287.02	286.88	287.02	400.0
2019-08-28 06:55:00	SPY	ETF	286.85	286.94	286.8	286.88	5831.0
2019-08-28 07:00:00	SPY	ETF	286.88	286.95	286.8	286.85	2354.0
2019-08-28 07:05:00	SPY	ETF	286.8	286.8	286.68	286.71	4087.0
2019-08-28 07:10:00	SPY	ETF	286.74	286.74	286.65	286.65	6309.0
2019-08-28 07:15:00	SPY	ETF	286.73	286.77	286.4	286.45	55320.0
2019-08-28 07:20:00	SPY	ETF	286.5	286.5	286.4	286.47	16334.0
2019-08-28 07:25:00	SPY	ETF	286.47	286.59	286.28	286.28	25980.0
2019-08-28 07:30:00	SPY	ETF	286.22	286.22	285.86	286.06	71069.0
2019-08-28 07:35:00	SPY	ETF	286.11	286.15	286.0	286.13	17596.0
2019-08-28 07:40:00	SPY	ETF	286.18	286.3	286.18	286.29	1279.0
2019-08-28 07:45:00	SPY	ETF	286.25	286.38	286.22	286.35	12408.0
2019-08-28 07:50:00	SPY	ETF	286.3	286.3	286.15	286.24	4834.0
2019-08-28 07:55:00	SPY	ETF	286.25	286.25	286.01	286.09	32377.0
2019-08-28 08:00:00	SPY	ETF	286.25	287.52	285.59	285.7	47775.0
2019-08-28 08:05:00	SPY	ETF	285.71	285.8	285.46	285.56	60071.0
2019-08-28 08:10:00	SPY	ETF	285.56	285.88	285.56	285.85	25759.0
2019-08-28 08:15:00	SPY	ETF	285.86	285.89	285.75	285.79	40616.0
2019-08-28 08:20:00	SPY	ETF	285.83	285.99	285.76	285.87	34243.0

> showing 50 of 61,485 rows — these rows as CSV

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