PREVIEW / etf_30min / 2012-12-20

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-20.parquet
  size:    302 KB
  rows:    10,148

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-12-20 04:00:00	SPY	ETF	144.27	144.37	144.27	144.33	18138.0
2012-12-20 04:30:00	SPY	ETF	144.3	144.3	144.3	144.3	100.0
2012-12-20 05:00:00	SPY	ETF	144.3	144.36	144.25	144.36	29000.0
2012-12-20 05:30:00	SPY	ETF	144.37	144.44	144.37	144.44	6640.0
2012-12-20 06:00:00	SPY	ETF	144.39	144.5	144.36	144.5	38810.0
2012-12-20 06:30:00	SPY	ETF	144.47	144.51	144.45	144.48	5931.0
2012-12-20 07:00:00	SPY	ETF	144.48	144.6	144.48	144.56	120243.0
2012-12-20 07:30:00	SPY	ETF	144.56	144.61	144.38	144.49	289700.0
2012-12-20 08:00:00	SPY	ETF	144.43	144.58	144.07	144.14	2276833.0
2012-12-20 08:30:00	SPY	ETF	144.35	144.48	144.21	144.43	1116025.0
2012-12-20 09:00:00	SPY	ETF	144.44	144.59	144.3	144.38	1790155.0
2012-12-20 09:30:00	SPY	ETF	144.38	144.51	143.98	144.03	13033519.0
2012-12-20 10:00:00	SPY	ETF	144.03	144.65	144.02	144.38	12615157.0
2012-12-20 10:30:00	SPY	ETF	144.37	144.649	144.3301	144.5	6623642.0
2012-12-20 11:00:00	SPY	ETF	144.51	144.61	144.23	144.26	7663413.0
2012-12-20 11:30:00	SPY	ETF	144.255	144.5	144.22	144.44	6056566.0
2012-12-20 12:00:00	SPY	ETF	144.435	144.51	144.33	144.385	4599290.0
2012-12-20 12:30:00	SPY	ETF	144.38	144.53	144.33	144.52	5320042.0
2012-12-20 13:00:00	SPY	ETF	144.51	144.62	144.3	144.585	7420570.0
2012-12-20 13:30:00	SPY	ETF	144.581	144.94	144.56	144.91	6905831.0
2012-12-20 14:00:00	SPY	ETF	144.92	145.0	144.75	144.86	6167079.0
2012-12-20 14:30:00	SPY	ETF	144.855	145.04	144.85	144.979	6135420.0
2012-12-20 15:00:00	SPY	ETF	144.97	144.98	144.68	144.735	7053142.0
2012-12-20 15:30:00	SPY	ETF	144.74	145.14	144.73	145.09	20864850.0
2012-12-20 16:00:00	SPY	ETF	145.09	145.34	144.3133	145.23	25744705.0
2012-12-20 16:30:00	SPY	ETF	145.23	145.28	144.523	145.21	12539023.0
2012-12-20 17:00:00	SPY	ETF	145.21	145.3	145.21	145.27	4112716.0
2012-12-20 17:30:00	SPY	ETF	145.26	145.3	145.26	145.3	190725.0
2012-12-20 18:00:00	SPY	ETF	145.28	145.3	145.21	145.26	328450.0
2012-12-20 18:30:00	SPY	ETF	145.24	145.24	145.15	145.18	23527.0
2012-12-20 19:00:00	SPY	ETF	145.17	145.19	145.1	145.1	58700.0
2012-12-20 19:30:00	SPY	ETF	145.11	145.11	144.81	144.92	169769.0
2012-12-20 04:00:00	QQQ	ETF	66.24	66.3	66.24	66.27	3968.0
2012-12-20 06:00:00	QQQ	ETF	66.33	66.38	66.33	66.38	5100.0
2012-12-20 06:30:00	QQQ	ETF	66.36	66.38	66.36	66.38	1800.0
2012-12-20 07:00:00	QQQ	ETF	66.38	66.42	66.38	66.42	7200.0
2012-12-20 07:30:00	QQQ	ETF	66.43	66.43	66.36	66.36	32700.0
2012-12-20 08:00:00	QQQ	ETF	66.36	66.38	66.23	66.23	1258854.0
2012-12-20 08:30:00	QQQ	ETF	66.29	66.41	66.25	66.41	145901.0
2012-12-20 09:00:00	QQQ	ETF	66.41	66.5	66.36	66.39	460922.0
2012-12-20 09:30:00	QQQ	ETF	66.38	66.4	65.93	65.96	4979210.0
2012-12-20 10:00:00	QQQ	ETF	65.97	66.289	65.96	66.07	2825088.0
2012-12-20 10:30:00	QQQ	ETF	66.06	66.19	66.02	66.1	1642222.0
2012-12-20 11:00:00	QQQ	ETF	66.09	66.19	65.97	66.0	1509606.0
2012-12-20 11:30:00	QQQ	ETF	65.99	66.15	65.97	66.09	1190597.0
2012-12-20 12:00:00	QQQ	ETF	66.09	66.15	66.04	66.06	1159231.0
2012-12-20 12:30:00	QQQ	ETF	66.06	66.13	66.02	66.11	1796377.0
2012-12-20 13:00:00	QQQ	ETF	66.11	66.14	65.98	66.139	1980239.0
2012-12-20 13:30:00	QQQ	ETF	66.13	66.3	66.115	66.279	1987643.0
2012-12-20 14:00:00	QQQ	ETF	66.2779	66.35	66.17	66.27	1869002.0

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

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