PREVIEW / etf_5min / 2012-08-13

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-08-13.parquet
  size:    797 KB
  rows:    33,283

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-13 04:05:00	SPY	ETF	140.56	140.56	140.56	140.56	900.0
2012-08-13 04:20:00	SPY	ETF	140.56	140.56	140.43	140.43	500.0
2012-08-13 04:25:00	SPY	ETF	140.45	140.45	140.45	140.45	300.0
2012-08-13 04:35:00	SPY	ETF	140.5	140.53	140.5	140.53	400.0
2012-08-13 04:50:00	SPY	ETF	140.5	140.5	140.5	140.5	100.0
2012-08-13 05:05:00	SPY	ETF	140.7	140.7	140.7	140.7	200.0
2012-08-13 05:15:00	SPY	ETF	140.73	140.73	140.73	140.73	100.0
2012-08-13 05:30:00	SPY	ETF	140.74	140.74	140.73	140.73	300.0
2012-08-13 05:40:00	SPY	ETF	140.68	140.68	140.68	140.68	1000.0
2012-08-13 05:50:00	SPY	ETF	140.72	140.72	140.68	140.68	300.0
2012-08-13 05:55:00	SPY	ETF	140.65	140.65	140.65	140.65	300.0
2012-08-13 06:00:00	SPY	ETF	140.66	140.66	140.66	140.66	100.0
2012-08-13 06:20:00	SPY	ETF	140.74	140.74	140.74	140.74	100.0
2012-08-13 06:30:00	SPY	ETF	140.8	140.8	140.78	140.78	10100.0
2012-08-13 06:35:00	SPY	ETF	140.78	140.78	140.78	140.78	6000.0
2012-08-13 06:40:00	SPY	ETF	140.75	140.75	140.74	140.74	4950.0
2012-08-13 06:50:00	SPY	ETF	140.83	140.83	140.83	140.83	2999.0
2012-08-13 06:55:00	SPY	ETF	140.84	140.84	140.84	140.84	450.0
2012-08-13 07:00:00	SPY	ETF	140.83	140.92	140.83	140.9	13250.0
2012-08-13 07:05:00	SPY	ETF	140.91	140.94	140.9	140.94	14200.0
2012-08-13 07:10:00	SPY	ETF	140.97	141.0	140.95	140.96	8859.0
2012-08-13 07:15:00	SPY	ETF	140.99	141.0	140.9	140.9	47900.0
2012-08-13 07:20:00	SPY	ETF	140.91	140.92	140.86	140.88	8650.0
2012-08-13 07:25:00	SPY	ETF	140.89	140.9	140.89	140.9	25100.0
2012-08-13 07:30:00	SPY	ETF	140.9	140.93	140.9	140.9	1500.0
2012-08-13 07:35:00	SPY	ETF	140.89	140.93	140.86	140.88	13322.0
2012-08-13 07:40:00	SPY	ETF	140.89	140.91	140.89	140.9	5700.0
2012-08-13 07:45:00	SPY	ETF	140.91	140.91	140.88	140.91	11400.0
2012-08-13 07:50:00	SPY	ETF	140.89	140.89	140.85	140.85	12330.0
2012-08-13 07:55:00	SPY	ETF	140.87	140.87	140.8	140.81	13700.0
2012-08-13 08:00:00	SPY	ETF	140.84	140.86	140.79	140.8	52160.0
2012-08-13 08:05:00	SPY	ETF	140.9	140.9	140.75	140.75	16299.0
2012-08-13 08:10:00	SPY	ETF	140.75	140.75	140.7	140.7	63499.0
2012-08-13 08:15:00	SPY	ETF	140.7	140.74	140.69	140.73	21467.0
2012-08-13 08:20:00	SPY	ETF	140.73	140.75	140.68	140.74	36966.0
2012-08-13 08:25:00	SPY	ETF	140.75	140.75	140.72	140.75	30300.0
2012-08-13 08:30:00	SPY	ETF	140.75	140.8	140.74	140.8	6400.0
2012-08-13 08:35:00	SPY	ETF	140.8	140.81	140.75	140.78	29083.0
2012-08-13 08:40:00	SPY	ETF	140.78	140.78	140.74	140.76	40209.0
2012-08-13 08:45:00	SPY	ETF	140.76	140.78	140.73	140.75	38300.0
2012-08-13 08:50:00	SPY	ETF	140.72	140.74	140.67	140.69	60000.0
2012-08-13 08:55:00	SPY	ETF	140.69	140.73	140.69	140.71	55167.0
2012-08-13 09:00:00	SPY	ETF	140.71	140.72	140.68	140.7	18860.0
2012-08-13 09:05:00	SPY	ETF	140.7	140.74	140.66	140.66	121682.0
2012-08-13 09:10:00	SPY	ETF	140.65	140.68	140.55	140.56	220270.0
2012-08-13 09:15:00	SPY	ETF	140.57	140.61	140.55	140.57	149533.0
2012-08-13 09:20:00	SPY	ETF	140.57	140.59	140.55	140.58	176890.0
2012-08-13 09:25:00	SPY	ETF	140.58	140.62	140.53	140.59	205384.0
2012-08-13 09:30:00	SPY	ETF	140.6	140.7	140.47	140.585	2527383.0
2012-08-13 09:35:00	SPY	ETF	140.59	140.72	140.52	140.689	2287651.0

> showing 50 of 33,283 rows — these rows as CSV

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