PREVIEW / etf_5min / 2019-12-06

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-12-06.parquet
  size:    1.4 MB
  rows:    61,908

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-06 04:00:00	SPY	ETF	312.65	312.72	312.65	312.72	1780.0
2019-12-06 04:10:00	SPY	ETF	312.77	312.8	312.77	312.79	597.0
2019-12-06 04:15:00	SPY	ETF	312.72	312.72	312.72	312.72	120.0
2019-12-06 04:20:00	SPY	ETF	312.77	312.77	312.77	312.77	100.0
2019-12-06 04:25:00	SPY	ETF	312.71	312.71	312.71	312.71	320.0
2019-12-06 04:35:00	SPY	ETF	312.73	312.73	312.73	312.73	100.0
2019-12-06 04:40:00	SPY	ETF	312.74	312.74	312.71	312.71	420.0
2019-12-06 04:45:00	SPY	ETF	312.74	312.74	312.74	312.74	100.0
2019-12-06 04:50:00	SPY	ETF	312.76	312.76	312.76	312.76	100.0
2019-12-06 05:00:00	SPY	ETF	312.81	312.81	312.81	312.81	1000.0
2019-12-06 05:10:00	SPY	ETF	312.69	312.72	312.69	312.72	920.0
2019-12-06 05:25:00	SPY	ETF	312.67	312.67	312.67	312.67	100.0
2019-12-06 05:40:00	SPY	ETF	312.72	312.74	312.71	312.74	1113.0
2019-12-06 05:45:00	SPY	ETF	312.76	312.76	312.74	312.74	520.0
2019-12-06 05:50:00	SPY	ETF	312.76	312.76	312.72	312.72	400.0
2019-12-06 05:55:00	SPY	ETF	312.71	312.71	312.7	312.7	800.0
2019-12-06 06:00:00	SPY	ETF	312.64	312.64	312.64	312.64	100.0
2019-12-06 06:05:00	SPY	ETF	312.74	312.74	312.74	312.74	300.0
2019-12-06 06:10:00	SPY	ETF	312.71	312.71	312.71	312.71	300.0
2019-12-06 06:15:00	SPY	ETF	312.72	312.72	312.72	312.72	900.0
2019-12-06 06:25:00	SPY	ETF	312.78	312.83	312.78	312.82	1310.0
2019-12-06 06:30:00	SPY	ETF	312.78	312.8	312.76	312.76	612.0
2019-12-06 06:35:00	SPY	ETF	312.86	312.86	312.86	312.86	105.0
2019-12-06 06:40:00	SPY	ETF	312.88	312.89	312.8	312.8	2805.0
2019-12-06 06:45:00	SPY	ETF	312.78	312.78	312.78	312.78	100.0
2019-12-06 06:50:00	SPY	ETF	312.8	312.8	312.78	312.78	27040.0
2019-12-06 06:55:00	SPY	ETF	312.85	312.88	312.83	312.83	2908.0
2019-12-06 07:00:00	SPY	ETF	312.83	312.85	312.75	312.75	5450.0
2019-12-06 07:05:00	SPY	ETF	312.75	312.78	312.75	312.78	1093.0
2019-12-06 07:10:00	SPY	ETF	312.73	312.76	312.71	312.76	7355.0
2019-12-06 07:15:00	SPY	ETF	312.73	312.73	312.68	312.68	1495.0
2019-12-06 07:20:00	SPY	ETF	312.68	312.75	312.68	312.69	12364.0
2019-12-06 07:25:00	SPY	ETF	312.68	312.68	312.58	312.58	5334.0
2019-12-06 07:30:00	SPY	ETF	312.57	312.6	312.53	312.58	5750.0
2019-12-06 07:35:00	SPY	ETF	312.58	312.58	312.58	312.58	519.0
2019-12-06 07:40:00	SPY	ETF	312.58	312.58	312.56	312.56	1151.0
2019-12-06 07:45:00	SPY	ETF	312.55	312.55	312.55	312.55	300.0
2019-12-06 07:50:00	SPY	ETF	312.58	312.6	312.58	312.6	1142.0
2019-12-06 07:55:00	SPY	ETF	312.63	312.64	312.62	312.62	3285.0
2019-12-06 08:00:00	SPY	ETF	312.75	312.9	312.53	312.57	12106.0
2019-12-06 08:05:00	SPY	ETF	312.6	312.6001	312.58	312.6001	18383.0
2019-12-06 08:10:00	SPY	ETF	312.63	312.63	312.52	312.55	5801.0
2019-12-06 08:15:00	SPY	ETF	312.5101	312.63	312.5101	312.63	4200.0
2019-12-06 08:20:00	SPY	ETF	312.62	312.64	312.61	312.64	3170.0
2019-12-06 08:25:00	SPY	ETF	312.64	312.74	312.54	312.55	24166.0
2019-12-06 08:30:00	SPY	ETF	312.51	313.73	312.37	313.6	594283.0
2019-12-06 08:35:00	SPY	ETF	313.61	313.65	313.37	313.64	539101.0
2019-12-06 08:40:00	SPY	ETF	313.63	313.95	313.63	313.75	251579.0
2019-12-06 08:45:00	SPY	ETF	313.78	313.98	313.75	313.98	133886.0
2019-12-06 08:50:00	SPY	ETF	314.0	314.14	313.88	314.09	131601.0

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

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