PREVIEW / etf_5min / 2017-06-08

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-06-08.parquet
  size:    1.2 MB
  rows:    52,679

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-06-08 04:05:00	SPY	ETF	243.7	243.73	243.7	243.73	2000.0
2017-06-08 04:10:00	SPY	ETF	243.73	243.73	243.68	243.68	1825.0
2017-06-08 04:15:00	SPY	ETF	243.69	243.69	243.69	243.69	2000.0
2017-06-08 04:20:00	SPY	ETF	243.71	243.71	243.71	243.71	370.0
2017-06-08 04:25:00	SPY	ETF	243.73	243.76	243.71	243.76	4400.0
2017-06-08 04:40:00	SPY	ETF	243.78	243.81	243.78	243.81	1300.0
2017-06-08 04:50:00	SPY	ETF	243.76	243.76	243.76	243.76	500.0
2017-06-08 05:05:00	SPY	ETF	243.81	243.81	243.81	243.81	4000.0
2017-06-08 05:15:00	SPY	ETF	243.86	243.86	243.86	243.86	1900.0
2017-06-08 05:20:00	SPY	ETF	243.88	243.92	243.86	243.86	1400.0
2017-06-08 05:40:00	SPY	ETF	243.86	243.86	243.86	243.86	700.0
2017-06-08 05:45:00	SPY	ETF	243.85	243.88	243.83	243.83	3700.0
2017-06-08 06:00:00	SPY	ETF	243.87	243.87	243.86	243.86	500.0
2017-06-08 06:05:00	SPY	ETF	243.86	243.86	243.86	243.86	300.0
2017-06-08 06:15:00	SPY	ETF	243.83	243.91	243.83	243.91	3880.0
2017-06-08 06:20:00	SPY	ETF	243.93	243.94	243.93	243.94	1300.0
2017-06-08 06:25:00	SPY	ETF	243.93	243.95	243.93	243.94	4000.0
2017-06-08 06:30:00	SPY	ETF	243.96	243.97	243.96	243.97	5100.0
2017-06-08 06:35:00	SPY	ETF	243.97	243.98	243.97	243.98	30000.0
2017-06-08 06:45:00	SPY	ETF	243.97	244.0	243.97	244.0	45550.0
2017-06-08 06:50:00	SPY	ETF	243.98	244.08	243.98	244.0	23220.0
2017-06-08 06:55:00	SPY	ETF	244.0	244.03	244.0	244.03	1400.0
2017-06-08 07:00:00	SPY	ETF	244.03	244.07	244.03	244.07	38343.0
2017-06-08 07:05:00	SPY	ETF	244.07	244.07	244.05	244.06	32600.0
2017-06-08 07:10:00	SPY	ETF	244.04	244.06	244.03	244.06	42398.0
2017-06-08 07:15:00	SPY	ETF	244.05	244.05	244.0	244.01	71619.0
2017-06-08 07:20:00	SPY	ETF	244.0	244.01	243.97	243.97	16718.0
2017-06-08 07:25:00	SPY	ETF	243.97	243.97	243.92	243.95	8473.0
2017-06-08 07:30:00	SPY	ETF	243.96	243.96	243.95	243.95	1023.0
2017-06-08 07:35:00	SPY	ETF	243.93	243.95	243.92	243.92	2003.0
2017-06-08 07:40:00	SPY	ETF	243.93	243.98	243.93	243.98	20750.0
2017-06-08 07:45:00	SPY	ETF	243.98	244.0	243.9	243.9	30165.0
2017-06-08 07:50:00	SPY	ETF	243.9	243.9	243.87	243.88	7023.0
2017-06-08 07:55:00	SPY	ETF	243.85	243.89	243.85	243.87	30140.0
2017-06-08 08:00:00	SPY	ETF	243.95	244.07	243.84	243.84	22781.0
2017-06-08 08:05:00	SPY	ETF	243.84	243.84	243.8	243.82	10086.0
2017-06-08 08:10:00	SPY	ETF	243.83	243.86	243.8	243.85	39379.0
2017-06-08 08:15:00	SPY	ETF	243.85	243.89	243.84	243.87	5545.0
2017-06-08 08:20:00	SPY	ETF	243.86	243.89	243.81	243.81	15562.0
2017-06-08 08:25:00	SPY	ETF	243.81	243.87	243.8	243.87	6572.0
2017-06-08 08:30:00	SPY	ETF	243.86	243.86	243.74	243.82	52420.0
2017-06-08 08:35:00	SPY	ETF	243.81	243.83	243.74	243.75	26224.0
2017-06-08 08:40:00	SPY	ETF	243.76	243.88	243.76	243.82	37602.0
2017-06-08 08:45:00	SPY	ETF	243.83	243.83	243.75	243.76	29409.0
2017-06-08 08:50:00	SPY	ETF	243.75	243.79	243.75	243.78	17232.0
2017-06-08 08:55:00	SPY	ETF	243.78	243.78	243.75	243.76	15489.0
2017-06-08 09:00:00	SPY	ETF	243.79	243.82	243.75	243.82	7208.0
2017-06-08 09:05:00	SPY	ETF	243.82	243.87	243.81	243.82	33567.0
2017-06-08 09:10:00	SPY	ETF	243.82	243.82	243.81	243.81	15836.0
2017-06-08 09:15:00	SPY	ETF	243.82	243.85	243.81	243.82	16057.0

> showing 50 of 52,679 rows — these rows as CSV

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