PREVIEW / etf_5min / 2012-08-01

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-08-01.parquet
  size:    823 KB
  rows:    34,727

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-01 04:00:00	SPY	ETF	138.17	138.4	138.17	138.4	540.0
2012-08-01 04:05:00	SPY	ETF	138.29	138.44	138.29	138.44	2000.0
2012-08-01 04:20:00	SPY	ETF	138.48	138.48	138.46	138.46	2700.0
2012-08-01 04:25:00	SPY	ETF	138.41	138.41	138.41	138.41	5000.0
2012-08-01 04:30:00	SPY	ETF	138.36	138.36	138.28	138.28	500.0
2012-08-01 04:35:00	SPY	ETF	138.18	138.18	138.1	138.13	5600.0
2012-08-01 05:10:00	SPY	ETF	138.42	138.42	138.42	138.42	2000.0
2012-08-01 05:15:00	SPY	ETF	138.39	138.48	138.39	138.48	7075.0
2012-08-01 05:30:00	SPY	ETF	138.42	138.43	138.42	138.43	20000.0
2012-08-01 05:35:00	SPY	ETF	138.42	138.42	138.42	138.42	1000.0
2012-08-01 05:40:00	SPY	ETF	138.42	138.42	138.39	138.4	1300.0
2012-08-01 05:45:00	SPY	ETF	138.42	138.44	138.41	138.41	2700.0
2012-08-01 05:50:00	SPY	ETF	138.45	138.45	138.45	138.45	990.0
2012-08-01 05:55:00	SPY	ETF	138.5	138.53	138.5	138.53	2050.0
2012-08-01 06:05:00	SPY	ETF	138.52	138.52	138.52	138.52	904.0
2012-08-01 06:10:00	SPY	ETF	138.53	138.53	138.53	138.53	300.0
2012-08-01 06:15:00	SPY	ETF	138.5	138.5	138.5	138.5	2886.0
2012-08-01 06:20:00	SPY	ETF	138.56	138.56	138.56	138.56	400.0
2012-08-01 06:25:00	SPY	ETF	138.57	138.59	138.57	138.59	3100.0
2012-08-01 06:30:00	SPY	ETF	138.59	138.6	138.58	138.6	26500.0
2012-08-01 06:35:00	SPY	ETF	138.57	138.57	138.57	138.57	10000.0
2012-08-01 06:40:00	SPY	ETF	138.57	138.57	138.49	138.49	1500.0
2012-08-01 06:55:00	SPY	ETF	138.42	138.48	138.42	138.42	17000.0
2012-08-01 07:00:00	SPY	ETF	138.43	138.43	138.35	138.38	10508.0
2012-08-01 07:05:00	SPY	ETF	138.36	138.37	138.33	138.37	5700.0
2012-08-01 07:10:00	SPY	ETF	138.37	138.42	138.37	138.42	16800.0
2012-08-01 07:15:00	SPY	ETF	138.42	138.5	138.42	138.46	12400.0
2012-08-01 07:20:00	SPY	ETF	138.44	138.46	138.39	138.39	1620.0
2012-08-01 07:25:00	SPY	ETF	138.4	138.4	138.34	138.36	22400.0
2012-08-01 07:30:00	SPY	ETF	138.33	138.36	138.32	138.36	2495.0
2012-08-01 07:35:00	SPY	ETF	138.36	138.37	138.36	138.37	500.0
2012-08-01 07:45:00	SPY	ETF	138.4	138.4	138.34	138.4	31735.0
2012-08-01 07:50:00	SPY	ETF	138.4	138.47	138.4	138.47	9630.0
2012-08-01 07:55:00	SPY	ETF	138.46	138.47	138.43	138.44	11900.0
2012-08-01 08:00:00	SPY	ETF	138.45	138.48	138.35	138.35	827257.0
2012-08-01 08:05:00	SPY	ETF	138.46	138.46	137.71	138.36	40445.0
2012-08-01 08:10:00	SPY	ETF	138.35	138.48	138.33	138.41	44900.0
2012-08-01 08:15:00	SPY	ETF	138.46	138.5	138.35	138.39	153601.0
2012-08-01 08:20:00	SPY	ETF	138.38	138.44	138.27	138.44	79867.0
2012-08-01 08:25:00	SPY	ETF	138.44	138.58	138.42	138.57	87103.0
2012-08-01 08:30:00	SPY	ETF	138.57	138.57	138.5	138.52	80250.0
2012-08-01 08:35:00	SPY	ETF	138.52	138.52	138.42	138.48	137329.0
2012-08-01 08:40:00	SPY	ETF	138.49	138.51	138.43	138.46	67600.0
2012-08-01 08:45:00	SPY	ETF	138.46	138.53	138.44	138.52	45440.0
2012-08-01 08:50:00	SPY	ETF	138.52	138.53	138.48	138.52	33499.0
2012-08-01 08:55:00	SPY	ETF	138.54	138.58	137.71	138.53	102041.0
2012-08-01 09:00:00	SPY	ETF	138.55	138.63	137.71	138.56	81932.0
2012-08-01 09:05:00	SPY	ETF	138.57	138.73	138.57	138.69	198943.0
2012-08-01 09:10:00	SPY	ETF	138.69	138.69	138.62	138.64	81320.0
2012-08-01 09:15:00	SPY	ETF	138.63	138.74	138.62	138.68	127854.0

> showing 50 of 34,727 rows — these rows as CSV

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