PREVIEW / etf_5min / 2017-07-18

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-07-18.parquet
  size:    1.2 MB
  rows:    53,236

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-18 04:00:00	SPY	ETF	245.45	245.45	245.45	245.45	340.0
2017-07-18 04:05:00	SPY	ETF	245.47	245.47	245.47	245.47	310.0
2017-07-18 04:10:00	SPY	ETF	245.49	245.58	245.49	245.58	1800.0
2017-07-18 04:15:00	SPY	ETF	245.57	245.57	245.57	245.57	100.0
2017-07-18 04:20:00	SPY	ETF	245.65	245.67	245.65	245.67	700.0
2017-07-18 04:25:00	SPY	ETF	245.65	245.68	245.65	245.67	30200.0
2017-07-18 04:30:00	SPY	ETF	245.7	245.73	245.69	245.73	14900.0
2017-07-18 04:35:00	SPY	ETF	245.73	245.9	245.73	245.88	15707.0
2017-07-18 04:40:00	SPY	ETF	245.84	245.85	245.84	245.85	520.0
2017-07-18 04:45:00	SPY	ETF	245.87	245.88	245.87	245.88	18000.0
2017-07-18 04:50:00	SPY	ETF	245.88	245.88	245.88	245.88	9500.0
2017-07-18 05:00:00	SPY	ETF	245.83	245.88	245.83	245.83	13400.0
2017-07-18 05:25:00	SPY	ETF	245.76	245.76	245.73	245.73	5000.0
2017-07-18 05:45:00	SPY	ETF	245.73	245.73	245.73	245.73	200.0
2017-07-18 06:05:00	SPY	ETF	245.85	245.85	245.85	245.85	100.0
2017-07-18 06:25:00	SPY	ETF	245.73	245.73	245.73	245.73	7500.0
2017-07-18 06:30:00	SPY	ETF	245.76	245.76	245.73	245.73	800.0
2017-07-18 06:40:00	SPY	ETF	245.68	245.68	245.62	245.62	760.0
2017-07-18 06:45:00	SPY	ETF	245.62	245.63	245.62	245.63	3700.0
2017-07-18 07:00:00	SPY	ETF	245.67	245.67	245.65	245.65	15850.0
2017-07-18 07:05:00	SPY	ETF	245.67	245.71	245.67	245.71	2300.0
2017-07-18 07:10:00	SPY	ETF	245.65	245.67	245.65	245.67	3300.0
2017-07-18 07:15:00	SPY	ETF	245.71	245.71	245.71	245.71	100.0
2017-07-18 07:20:00	SPY	ETF	245.66	245.66	245.6	245.6	9897.0
2017-07-18 07:25:00	SPY	ETF	245.6	245.6	245.6	245.6	3700.0
2017-07-18 07:30:00	SPY	ETF	245.63	245.63	245.52	245.55	11838.0
2017-07-18 07:35:00	SPY	ETF	245.58	245.6	245.5	245.54	12652.0
2017-07-18 07:40:00	SPY	ETF	245.58	245.58	245.55	245.58	10969.0
2017-07-18 07:45:00	SPY	ETF	245.58	245.58	245.5	245.5	6488.0
2017-07-18 07:50:00	SPY	ETF	245.54	245.56	245.52	245.52	3038.0
2017-07-18 07:55:00	SPY	ETF	245.52	245.55	245.51	245.55	9370.0
2017-07-18 08:00:00	SPY	ETF	245.56	245.67	245.55	245.62	16272.0
2017-07-18 08:05:00	SPY	ETF	245.63	245.63	245.58	245.61	5025.0
2017-07-18 08:10:00	SPY	ETF	245.58	245.6	245.53	245.55	13478.0
2017-07-18 08:15:00	SPY	ETF	245.53	245.53	245.45	245.48	11844.0
2017-07-18 08:20:00	SPY	ETF	245.48	245.49	245.44	245.44	6764.0
2017-07-18 08:25:00	SPY	ETF	245.48	245.49	245.45	245.45	5535.0
2017-07-18 08:30:00	SPY	ETF	245.47	245.52	245.45	245.45	29427.0
2017-07-18 08:35:00	SPY	ETF	245.46	245.46	245.32	245.35	40722.0
2017-07-18 08:40:00	SPY	ETF	245.33	245.35	245.16	245.18	71034.0
2017-07-18 08:45:00	SPY	ETF	245.17	245.2	245.13	245.19	441409.0
2017-07-18 08:50:00	SPY	ETF	245.18	245.25	245.18	245.23	25796.0
2017-07-18 08:55:00	SPY	ETF	245.21	245.24	245.1	245.11	40935.0
2017-07-18 09:00:00	SPY	ETF	245.11	245.2	245.1	245.18	16819.0
2017-07-18 09:05:00	SPY	ETF	245.21	245.26	245.2	245.24	33965.0
2017-07-18 09:10:00	SPY	ETF	245.23	245.24	245.22	245.22	20397.0
2017-07-18 09:15:00	SPY	ETF	245.22	245.22	245.09	245.11	40115.0
2017-07-18 09:20:00	SPY	ETF	245.1	245.15	245.09	245.11	47350.0
2017-07-18 09:25:00	SPY	ETF	245.11	245.12	245.04	245.07	104397.0
2017-07-18 09:30:00	SPY	ETF	245.06	245.11	244.89	244.8911	2316185.0

> showing 50 of 53,236 rows — these rows as CSV

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