PREVIEW / etf_5min / 2019-06-17

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-06-17.parquet
  size:    1.3 MB
  rows:    57,528

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-06-17 04:05:00	SPY	ETF	289.8	289.8	289.8	289.8	334.0
2019-06-17 04:15:00	SPY	ETF	289.91	289.91	289.91	289.91	100.0
2019-06-17 04:20:00	SPY	ETF	289.85	289.85	289.82	289.82	403.0
2019-06-17 04:25:00	SPY	ETF	289.73	289.73	289.73	289.73	411.0
2019-06-17 04:35:00	SPY	ETF	289.8	289.8	289.78	289.78	984.0
2019-06-17 04:45:00	SPY	ETF	289.81	289.81	289.78	289.78	1004.0
2019-06-17 05:05:00	SPY	ETF	289.94	289.94	289.94	289.94	996.0
2019-06-17 05:10:00	SPY	ETF	289.91	289.95	289.89	289.89	2329.0
2019-06-17 05:15:00	SPY	ETF	289.86	289.86	289.84	289.84	1301.0
2019-06-17 05:20:00	SPY	ETF	289.84	289.86	289.84	289.86	1204.0
2019-06-17 05:25:00	SPY	ETF	289.82	289.82	289.77	289.77	821.0
2019-06-17 05:35:00	SPY	ETF	289.87	289.87	289.86	289.86	2092.0
2019-06-17 05:40:00	SPY	ETF	289.88	289.88	289.82	289.82	2407.0
2019-06-17 05:45:00	SPY	ETF	289.78	289.78	289.75	289.75	1106.0
2019-06-17 05:55:00	SPY	ETF	289.78	289.78	289.78	289.78	1000.0
2019-06-17 06:00:00	SPY	ETF	289.8	289.8	289.77	289.77	504.0
2019-06-17 06:05:00	SPY	ETF	289.77	289.77	289.72	289.72	3006.0
2019-06-17 06:10:00	SPY	ETF	289.72	289.72	289.69	289.69	4602.0
2019-06-17 06:15:00	SPY	ETF	289.67	289.67	289.67	289.67	401.0
2019-06-17 06:20:00	SPY	ETF	289.67	289.67	289.64	289.64	1519.0
2019-06-17 06:25:00	SPY	ETF	289.69	289.69	289.69	289.69	100.0
2019-06-17 06:30:00	SPY	ETF	289.66	289.66	289.66	289.66	800.0
2019-06-17 06:40:00	SPY	ETF	289.66	289.73	289.66	289.73	751.0
2019-06-17 06:45:00	SPY	ETF	289.66	289.66	289.66	289.66	200.0
2019-06-17 06:50:00	SPY	ETF	289.66	289.66	289.56	289.56	5418.0
2019-06-17 06:55:00	SPY	ETF	289.51	289.51	289.49	289.49	7465.0
2019-06-17 07:00:00	SPY	ETF	289.54	289.59	289.53	289.53	1962.0
2019-06-17 07:05:00	SPY	ETF	289.54	289.54	289.47	289.48	10822.0
2019-06-17 07:10:00	SPY	ETF	289.56	289.59	289.55	289.55	1772.0
2019-06-17 07:15:00	SPY	ETF	289.54	289.59	289.54	289.59	5016.0
2019-06-17 07:20:00	SPY	ETF	289.65	289.74	289.65	289.74	6190.0
2019-06-17 07:25:00	SPY	ETF	289.71	289.74	289.69	289.7	10363.0
2019-06-17 07:30:00	SPY	ETF	289.72	289.72	289.69	289.72	2815.0
2019-06-17 07:35:00	SPY	ETF	289.75	289.75	289.67	289.67	4462.0
2019-06-17 07:40:00	SPY	ETF	289.73	289.78	289.73	289.76	10509.0
2019-06-17 07:45:00	SPY	ETF	289.76	289.8	289.75	289.75	37463.0
2019-06-17 07:50:00	SPY	ETF	289.74	289.77	289.7	289.75	8754.0
2019-06-17 07:55:00	SPY	ETF	289.82	289.94	289.82	289.92	12304.0
2019-06-17 08:00:00	SPY	ETF	289.91	290.25	289.5	289.81	34959.0
2019-06-17 08:05:00	SPY	ETF	289.88	289.93	289.88	289.91	7869.0
2019-06-17 08:10:00	SPY	ETF	289.93	289.93	289.74	289.74	9971.0
2019-06-17 08:15:00	SPY	ETF	289.77	289.8	289.7	289.8	12308.0
2019-06-17 08:20:00	SPY	ETF	289.79	289.85	289.79	289.85	6505.0
2019-06-17 08:25:00	SPY	ETF	289.83	289.84	289.79	289.82	6515.0
2019-06-17 08:30:00	SPY	ETF	289.81	289.86	289.66	289.66	108855.0
2019-06-17 08:35:00	SPY	ETF	289.72	289.72	289.63	289.64	30038.0
2019-06-17 08:40:00	SPY	ETF	289.64	289.68	289.6	289.68	25513.0
2019-06-17 08:45:00	SPY	ETF	289.72	289.73	289.65	289.66	21640.0
2019-06-17 08:50:00	SPY	ETF	289.64	289.68	289.6	289.61	29129.0
2019-06-17 08:55:00	SPY	ETF	289.6	289.6	289.34	289.39	80063.0

> showing 50 of 57,528 rows — these rows as CSV

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