PREVIEW / etf_5min / 2012-08-08

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-08-08.parquet
  size:    827 KB
  rows:    35,183

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
2012-08-08 04:00:00	SPY	ETF	140.0	140.01	140.0	140.01	349.0
2012-08-08 04:10:00	SPY	ETF	140.09	140.09	140.09	140.09	105.0
2012-08-08 04:15:00	SPY	ETF	140.1	140.1	140.1	140.1	300.0
2012-08-08 04:20:00	SPY	ETF	140.08	140.08	140.02	140.02	900.0
2012-08-08 04:30:00	SPY	ETF	139.98	139.98	139.98	139.98	100.0
2012-08-08 04:35:00	SPY	ETF	139.94	139.94	139.94	139.94	274.0
2012-08-08 04:40:00	SPY	ETF	139.98	139.98	139.98	139.98	100.0
2012-08-08 05:00:00	SPY	ETF	139.96	139.96	139.96	139.96	200.0
2012-08-08 05:05:00	SPY	ETF	139.96	139.96	139.93	139.93	300.0
2012-08-08 05:10:00	SPY	ETF	139.9	139.92	139.89	139.92	700.0
2012-08-08 05:15:00	SPY	ETF	139.93	139.93	139.93	139.93	100.0
2012-08-08 05:20:00	SPY	ETF	139.93	139.93	139.92	139.92	200.0
2012-08-08 05:35:00	SPY	ETF	139.97	139.97	139.97	139.97	100.0
2012-08-08 05:40:00	SPY	ETF	139.85	139.85	139.84	139.84	200.0
2012-08-08 05:45:00	SPY	ETF	139.83	139.83	139.83	139.83	200.0
2012-08-08 05:50:00	SPY	ETF	139.83	139.83	139.83	139.83	200.0
2012-08-08 06:10:00	SPY	ETF	139.87	139.88	139.84	139.88	700.0
2012-08-08 06:15:00	SPY	ETF	139.85	139.85	139.85	139.85	200.0
2012-08-08 06:25:00	SPY	ETF	140.01	140.01	140.0	140.0	262.0
2012-08-08 06:30:00	SPY	ETF	140.0	140.1	139.96	140.1	3038.0
2012-08-08 06:35:00	SPY	ETF	140.06	140.06	140.06	140.06	5000.0
2012-08-08 06:50:00	SPY	ETF	139.97	139.97	139.97	139.97	2000.0
2012-08-08 06:55:00	SPY	ETF	139.97	139.97	139.9	139.9	1600.0
2012-08-08 07:00:00	SPY	ETF	139.92	139.93	139.9	139.93	52900.0
2012-08-08 07:05:00	SPY	ETF	139.91	139.94	139.9	139.94	8433.0
2012-08-08 07:10:00	SPY	ETF	139.96	139.99	139.96	139.99	1475.0
2012-08-08 07:15:00	SPY	ETF	139.99	139.99	139.95	139.96	19800.0
2012-08-08 07:20:00	SPY	ETF	139.98	139.98	139.95	139.95	20955.0
2012-08-08 07:25:00	SPY	ETF	139.98	139.99	139.95	139.99	16700.0
2012-08-08 07:30:00	SPY	ETF	139.96	140.02	139.96	140.0	4950.0
2012-08-08 07:35:00	SPY	ETF	139.98	140.01	139.98	140.01	10500.0
2012-08-08 07:40:00	SPY	ETF	139.98	139.98	139.95	139.95	7933.0
2012-08-08 07:45:00	SPY	ETF	139.95	139.97	139.94	139.94	5705.0
2012-08-08 07:50:00	SPY	ETF	139.94	139.95	139.94	139.95	1200.0
2012-08-08 07:55:00	SPY	ETF	139.95	139.96	139.87	139.87	13750.0
2012-08-08 08:00:00	SPY	ETF	139.89	139.92	139.79	139.84	490025.0
2012-08-08 08:05:00	SPY	ETF	139.84	139.84	139.73	139.83	117427.0
2012-08-08 08:10:00	SPY	ETF	139.82	139.83	139.72	139.75	24950.0
2012-08-08 08:15:00	SPY	ETF	139.75	139.81	139.71	139.8	36955.0
2012-08-08 08:20:00	SPY	ETF	139.79	139.8	139.72	139.73	24705.0
2012-08-08 08:25:00	SPY	ETF	139.73	139.79	139.71	139.76	74880.0
2012-08-08 08:30:00	SPY	ETF	139.77	139.84	139.71	139.82	112761.0
2012-08-08 08:35:00	SPY	ETF	139.82	139.88	139.82	139.84	63284.0
2012-08-08 08:40:00	SPY	ETF	139.84	139.84	139.78	139.79	78184.0
2012-08-08 08:45:00	SPY	ETF	139.79	139.79	139.73	139.75	132734.0
2012-08-08 08:50:00	SPY	ETF	139.75	139.75	139.67	139.74	213000.0
2012-08-08 08:55:00	SPY	ETF	139.74	139.75	139.7	139.71	403421.0
2012-08-08 09:00:00	SPY	ETF	139.71	139.76	139.7	139.72	62475.0
2012-08-08 09:05:00	SPY	ETF	139.73	139.81	139.7	139.8	56605.0
2012-08-08 09:10:00	SPY	ETF	139.8	139.84	139.78	139.84	54300.0

> showing 50 of 35,183 rows — these rows as CSV

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