PREVIEW / etf_30min / 2012-09-07

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-07.parquet
  size:    292 KB
  rows:    10,078

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-09-07 04:00:00	SPY	ETF	144.01	144.15	144.01	144.15	1775.0
2012-09-07 04:30:00	SPY	ETF	144.15	144.21	144.12	144.15	37000.0
2012-09-07 05:00:00	SPY	ETF	144.12	144.14	144.12	144.14	19558.0
2012-09-07 05:30:00	SPY	ETF	144.21	144.24	144.15	144.15	7965.0
2012-09-07 06:00:00	SPY	ETF	144.24	144.3	144.21	144.27	66050.0
2012-09-07 06:30:00	SPY	ETF	144.26	144.34	144.23	144.3	47750.0
2012-09-07 07:00:00	SPY	ETF	144.24	144.25	144.18	144.22	16555.0
2012-09-07 07:30:00	SPY	ETF	144.25	144.39	144.25	144.35	315560.0
2012-09-07 08:00:00	SPY	ETF	144.36	144.38	144.15	144.31	1137563.0
2012-09-07 08:30:00	SPY	ETF	144.25	144.43	143.43	144.02	5539956.0
2012-09-07 09:00:00	SPY	ETF	144.02	144.15	143.95	144.01	1235815.0
2012-09-07 09:30:00	SPY	ETF	144.01	144.33	143.88	144.06	18203182.0
2012-09-07 10:00:00	SPY	ETF	144.07	144.27	143.92	144.16	9016724.0
2012-09-07 10:30:00	SPY	ETF	144.17	144.29	144.01	144.19	7405246.0
2012-09-07 11:00:00	SPY	ETF	144.19	144.19	144.01	144.17	6334210.0
2012-09-07 11:30:00	SPY	ETF	144.17	144.23	144.04	144.15	4738006.0
2012-09-07 12:00:00	SPY	ETF	144.15	144.21	144.08	144.08	2954346.0
2012-09-07 12:30:00	SPY	ETF	144.09	144.25	144.06	144.22	2858000.0
2012-09-07 13:00:00	SPY	ETF	144.22	144.26	144.11	144.2125	3274652.0
2012-09-07 13:30:00	SPY	ETF	144.21	144.212	144.09	144.09	2695568.0
2012-09-07 14:00:00	SPY	ETF	144.09	144.22	144.07	144.2	3127950.0
2012-09-07 14:30:00	SPY	ETF	144.2	144.29	144.19	144.2	3659894.0
2012-09-07 15:00:00	SPY	ETF	144.19	144.23	144.11	144.15	5190037.0
2012-09-07 15:30:00	SPY	ETF	144.15	144.35	144.13	144.33	13188269.0
2012-09-07 16:00:00	SPY	ETF	144.34	144.49	144.15	144.47	10855051.0
2012-09-07 16:30:00	SPY	ETF	144.47	144.5221	144.43	144.43	1584183.0
2012-09-07 17:00:00	SPY	ETF	144.42	144.47	144.4	144.4	124717.0
2012-09-07 17:30:00	SPY	ETF	144.4	144.46	144.33	144.33	70102.0
2012-09-07 18:00:00	SPY	ETF	144.34	144.35	144.33	144.35	14672.0
2012-09-07 18:30:00	SPY	ETF	144.35	144.37	144.34	144.37	11230.0
2012-09-07 19:00:00	SPY	ETF	144.36	144.45	144.36	144.4	9428.0
2012-09-07 19:30:00	SPY	ETF	144.4	144.43	144.37	144.41	18646.0
2012-09-07 06:30:00	QQQ	ETF	69.7	69.7	69.7	69.7	495.0
2012-09-07 07:00:00	QQQ	ETF	69.63	69.66	69.63	69.66	5695.0
2012-09-07 07:30:00	QQQ	ETF	69.68	69.69	69.66	69.67	8200.0
2012-09-07 08:00:00	QQQ	ETF	69.68	69.68	69.3	69.55	854408.0
2012-09-07 08:30:00	QQQ	ETF	69.51	69.6	69.25	69.44	1638187.0
2012-09-07 09:00:00	QQQ	ETF	69.44	69.45	69.35	69.37	303721.0
2012-09-07 09:30:00	QQQ	ETF	69.37	69.5	69.23	69.35	7473249.0
2012-09-07 10:00:00	QQQ	ETF	69.34	69.55	69.3	69.4	2193872.0
2012-09-07 10:30:00	QQQ	ETF	69.3918	69.48	69.32	69.42	3150048.0
2012-09-07 11:00:00	QQQ	ETF	69.42	69.43	69.32	69.41	2206617.0
2012-09-07 11:30:00	QQQ	ETF	69.41	69.43	69.34	69.36	1334634.0
2012-09-07 12:00:00	QQQ	ETF	69.37	69.41	69.31	69.31	832213.0
2012-09-07 12:30:00	QQQ	ETF	69.32	69.43	69.3	69.4	965890.0
2012-09-07 13:00:00	QQQ	ETF	69.41	69.45	69.35	69.41	1389154.0
2012-09-07 13:30:00	QQQ	ETF	69.4	69.41	69.31	69.32	1214588.0
2012-09-07 14:00:00	QQQ	ETF	69.32	69.41	69.3135	69.3999	1466873.0
2012-09-07 14:30:00	QQQ	ETF	69.4	69.45	69.37	69.38	633020.0
2012-09-07 15:00:00	QQQ	ETF	69.39	69.39	69.32	69.35	1363818.0

> showing 50 of 10,078 rows — these rows as CSV

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