PREVIEW / etf_5min / 2017-07-06

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-07-06.parquet
  size:    1.2 MB
  rows:    54,266

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
2017-07-06 04:00:00	SPY	ETF	242.31	242.31	242.3	242.3	355.0
2017-07-06 04:20:00	SPY	ETF	242.38	242.38	242.32	242.32	404.0
2017-07-06 04:40:00	SPY	ETF	242.34	242.34	242.3	242.3	700.0
2017-07-06 05:10:00	SPY	ETF	242.18	242.2	242.14	242.2	921.0
2017-07-06 05:15:00	SPY	ETF	242.17	242.17	242.17	242.17	100.0
2017-07-06 05:20:00	SPY	ETF	242.1	242.1	242.01	242.01	2726.0
2017-07-06 05:25:00	SPY	ETF	242.01	242.02	241.9	241.9	8020.0
2017-07-06 05:40:00	SPY	ETF	241.91	241.91	241.85	241.91	687.0
2017-07-06 05:50:00	SPY	ETF	241.89	241.89	241.81	241.81	204.0
2017-07-06 05:55:00	SPY	ETF	241.84	241.84	241.78	241.81	4415.0
2017-07-06 06:00:00	SPY	ETF	241.81	241.81	241.81	241.81	102.0
2017-07-06 06:05:00	SPY	ETF	241.79	241.79	241.64	241.64	6499.0
2017-07-06 06:10:00	SPY	ETF	241.66	241.67	241.66	241.67	352.0
2017-07-06 06:15:00	SPY	ETF	241.6	241.6	241.51	241.51	1136.0
2017-07-06 06:20:00	SPY	ETF	241.46	241.54	241.44	241.5	1474.0
2017-07-06 06:30:00	SPY	ETF	241.57	241.57	241.51	241.57	38721.0
2017-07-06 06:35:00	SPY	ETF	241.55	241.58	241.54	241.55	20583.0
2017-07-06 06:40:00	SPY	ETF	241.58	241.58	241.58	241.58	6220.0
2017-07-06 06:45:00	SPY	ETF	241.68	241.73	241.65	241.73	12513.0
2017-07-06 06:50:00	SPY	ETF	241.73	241.75	241.73	241.75	340.0
2017-07-06 06:55:00	SPY	ETF	241.77	241.77	241.77	241.77	740.0
2017-07-06 07:00:00	SPY	ETF	241.8	241.8	241.75	241.76	21963.0
2017-07-06 07:05:00	SPY	ETF	241.75	241.75	241.7	241.7	38033.0
2017-07-06 07:10:00	SPY	ETF	241.71	241.71	241.63	241.63	30481.0
2017-07-06 07:15:00	SPY	ETF	241.62	241.67	241.61	241.64	61255.0
2017-07-06 07:20:00	SPY	ETF	241.69	241.75	241.68	241.7	10353.0
2017-07-06 07:25:00	SPY	ETF	241.74	241.74	241.74	241.74	1800.0
2017-07-06 07:30:00	SPY	ETF	241.79	241.8	241.69	241.69	24428.0
2017-07-06 07:35:00	SPY	ETF	241.7	241.7	241.64	241.68	16519.0
2017-07-06 07:40:00	SPY	ETF	241.63	241.66	241.55	241.55	33434.0
2017-07-06 07:45:00	SPY	ETF	241.56	241.58	241.46	241.47	117502.0
2017-07-06 07:50:00	SPY	ETF	241.46	241.51	241.44	241.49	30931.0
2017-07-06 07:55:00	SPY	ETF	241.46	241.54	241.46	241.52	19043.0
2017-07-06 08:00:00	SPY	ETF	241.56	241.8	241.5	241.66	82734.0
2017-07-06 08:05:00	SPY	ETF	241.66	241.75	241.64	241.75	114042.0
2017-07-06 08:10:00	SPY	ETF	241.72	241.73	241.65	241.65	6277.0
2017-07-06 08:15:00	SPY	ETF	241.64	241.69	241.63	241.64	12168.0
2017-07-06 08:20:00	SPY	ETF	241.61	241.83	241.58	241.71	30006.0
2017-07-06 08:25:00	SPY	ETF	241.74	241.77	241.72	241.77	18640.0
2017-07-06 08:30:00	SPY	ETF	241.77	241.79	241.74	241.78	25543.0
2017-07-06 08:35:00	SPY	ETF	241.78	241.83	241.78	241.8	15882.0
2017-07-06 08:40:00	SPY	ETF	241.8	241.82	241.68	241.68	32916.0
2017-07-06 08:45:00	SPY	ETF	241.69	241.78	241.67	241.78	40358.0
2017-07-06 08:50:00	SPY	ETF	241.79	241.87	241.75	241.86	88923.0
2017-07-06 08:55:00	SPY	ETF	241.89	241.89	241.82	241.85	50627.0
2017-07-06 09:00:00	SPY	ETF	241.86	242.0	241.86	241.98	53089.0
2017-07-06 09:05:00	SPY	ETF	241.99	242.0	241.93	241.96	200413.0
2017-07-06 09:10:00	SPY	ETF	241.96	241.96	241.85	241.86	101316.0
2017-07-06 09:15:00	SPY	ETF	241.87	241.92	241.84	241.89	74347.0
2017-07-06 09:20:00	SPY	ETF	241.86	241.94	241.86	241.9	127928.0

> showing 50 of 54,266 rows — these rows as CSV

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