PREVIEW / etf_5min / 2013-07-08

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-07-08.parquet
  size:    977 KB
  rows:    42,640

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
2013-07-08 04:00:00	SPY	ETF	163.66	163.7	163.66	163.7	1723.0
2013-07-08 04:05:00	SPY	ETF	163.67	163.71	163.67	163.7	13800.0
2013-07-08 04:10:00	SPY	ETF	163.7	163.7	163.66	163.66	300.0
2013-07-08 04:15:00	SPY	ETF	163.64	163.67	163.58	163.58	1210.0
2013-07-08 04:20:00	SPY	ETF	163.54	163.62	163.54	163.62	700.0
2013-07-08 04:25:00	SPY	ETF	163.63	163.63	163.58	163.62	600.0
2013-07-08 04:30:00	SPY	ETF	163.61	163.67	163.61	163.67	1016.0
2013-07-08 04:40:00	SPY	ETF	163.7	163.71	163.7	163.71	400.0
2013-07-08 04:45:00	SPY	ETF	163.71	163.71	163.58	163.62	5200.0
2013-07-08 04:50:00	SPY	ETF	163.66	163.74	163.66	163.74	800.0
2013-07-08 04:55:00	SPY	ETF	163.78	163.78	163.74	163.74	19489.0
2013-07-08 05:00:00	SPY	ETF	163.76	163.76	163.76	163.76	200.0
2013-07-08 05:05:00	SPY	ETF	163.78	163.84	163.78	163.84	800.0
2013-07-08 05:10:00	SPY	ETF	163.84	163.9	163.84	163.9	600.0
2013-07-08 05:15:00	SPY	ETF	163.91	163.91	163.91	163.91	2000.0
2013-07-08 05:20:00	SPY	ETF	163.94	164.06	163.94	164.04	8074.0
2013-07-08 05:25:00	SPY	ETF	164.06	164.14	164.06	164.14	600.0
2013-07-08 05:30:00	SPY	ETF	164.13	164.18	164.13	164.16	4830.0
2013-07-08 05:35:00	SPY	ETF	164.16	164.21	164.13	164.21	6800.0
2013-07-08 05:40:00	SPY	ETF	164.22	164.23	164.18	164.18	1700.0
2013-07-08 05:45:00	SPY	ETF	164.14	164.14	164.1	164.1	4370.0
2013-07-08 05:50:00	SPY	ETF	164.1	164.1	164.1	164.1	100.0
2013-07-08 05:55:00	SPY	ETF	164.09	164.14	164.07	164.14	18100.0
2013-07-08 06:05:00	SPY	ETF	164.14	164.25	164.14	164.16	16800.0
2013-07-08 06:10:00	SPY	ETF	164.14	164.18	164.14	164.18	6100.0
2013-07-08 06:15:00	SPY	ETF	164.15	164.15	164.1	164.12	3600.0
2013-07-08 06:20:00	SPY	ETF	164.06	164.1	164.05	164.1	1300.0
2013-07-08 06:25:00	SPY	ETF	164.14	164.14	164.1	164.1	3200.0
2013-07-08 06:40:00	SPY	ETF	164.12	164.16	164.1	164.1	2500.0
2013-07-08 06:45:00	SPY	ETF	164.12	164.13	164.09	164.11	25074.0
2013-07-08 06:50:00	SPY	ETF	164.09	164.09	164.02	164.04	14282.0
2013-07-08 06:55:00	SPY	ETF	164.06	164.07	164.04	164.04	15600.0
2013-07-08 07:00:00	SPY	ETF	164.04	164.07	164.02	164.07	16000.0
2013-07-08 07:05:00	SPY	ETF	164.1	164.14	164.07	164.14	8430.0
2013-07-08 07:10:00	SPY	ETF	164.08	164.08	164.06	164.06	3150.0
2013-07-08 07:15:00	SPY	ETF	164.03	164.06	164.01	164.02	37048.0
2013-07-08 07:20:00	SPY	ETF	164.02	164.05	163.99	164.02	9600.0
2013-07-08 07:25:00	SPY	ETF	164.01	164.06	164.01	164.02	39686.0
2013-07-08 07:30:00	SPY	ETF	164.04	164.05	163.94	164.02	20844.0
2013-07-08 07:35:00	SPY	ETF	164.0	164.02	163.97	163.99	6598.0
2013-07-08 07:40:00	SPY	ETF	164.02	164.02	163.94	163.98	16815.0
2013-07-08 07:45:00	SPY	ETF	163.97	163.99	163.93	163.93	73794.0
2013-07-08 07:50:00	SPY	ETF	163.94	164.0	163.94	163.99	177296.0
2013-07-08 07:55:00	SPY	ETF	164.0	164.1	163.99	164.1	85915.0
2013-07-08 08:00:00	SPY	ETF	163.59	164.12	163.59	164.04	101027.0
2013-07-08 08:05:00	SPY	ETF	164.04	164.0638	163.99	164.01	65390.0
2013-07-08 08:10:00	SPY	ETF	164.02	164.07	164.0	164.05	26807.0
2013-07-08 08:15:00	SPY	ETF	164.07	164.09	163.99	164.0	115734.0
2013-07-08 08:20:00	SPY	ETF	163.99	164.1	163.96	164.04	32895.0
2013-07-08 08:25:00	SPY	ETF	164.03	164.1	164.02	164.06	32315.0

> showing 50 of 42,640 rows — these rows as CSV

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