PREVIEW / etf_30min / 2013-01-10

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-10.parquet
  size:    307 KB
  rows:    10,445

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
2013-01-10 04:00:00	SPY	ETF	146.19	146.34	146.19	146.34	22490.0
2013-01-10 04:30:00	SPY	ETF	146.32	146.42	146.28	146.41	10800.0
2013-01-10 05:00:00	SPY	ETF	146.45	146.45	146.35	146.37	8600.0
2013-01-10 05:30:00	SPY	ETF	146.38	146.38	146.38	146.38	10000.0
2013-01-10 06:00:00	SPY	ETF	146.35	146.35	146.29	146.3	23500.0
2013-01-10 06:30:00	SPY	ETF	146.32	146.36	146.32	146.35	26188.0
2013-01-10 07:00:00	SPY	ETF	146.33	146.33	146.28	146.31	84235.0
2013-01-10 07:30:00	SPY	ETF	146.32	146.48	146.32	146.48	181039.0
2013-01-10 08:00:00	SPY	ETF	146.48	146.6	146.29	146.59	776393.0
2013-01-10 08:30:00	SPY	ETF	146.55	146.86	146.35	146.72	1048679.0
2013-01-10 09:00:00	SPY	ETF	146.71	146.78	145.9517	146.73	1206953.0
2013-01-10 09:30:00	SPY	ETF	146.73	146.83	146.43	146.65	14169035.0
2013-01-10 10:00:00	SPY	ETF	146.65	146.71	146.48	146.485	7682545.0
2013-01-10 10:30:00	SPY	ETF	146.49	146.51	146.14	146.16	11453552.0
2013-01-10 11:00:00	SPY	ETF	146.16	146.26	145.97	146.19	10210581.0
2013-01-10 11:30:00	SPY	ETF	146.2	146.32	146.16	146.31	4091815.0
2013-01-10 12:00:00	SPY	ETF	146.3	146.4	146.23	146.38	4189096.0
2013-01-10 12:30:00	SPY	ETF	146.37	146.59	146.35	146.58	3711503.0
2013-01-10 13:00:00	SPY	ETF	146.58	146.62	146.42	146.4701	4360265.0
2013-01-10 13:30:00	SPY	ETF	146.47	146.62	146.43	146.54	3938163.0
2013-01-10 14:00:00	SPY	ETF	146.55	146.6	146.41	146.4601	4920018.0
2013-01-10 14:30:00	SPY	ETF	146.462	146.89	146.44	146.81	7200276.0
2013-01-10 15:00:00	SPY	ETF	146.82	147.0	146.819	146.96	14861338.0
2013-01-10 15:30:00	SPY	ETF	146.96	147.09	146.93	147.07	14242620.0
2013-01-10 16:00:00	SPY	ETF	147.06	147.13	145.9518	147.04	14596385.0
2013-01-10 16:30:00	SPY	ETF	147.05	147.23	145.9518	147.22	3350942.0
2013-01-10 17:00:00	SPY	ETF	147.22	147.37	145.9518	147.22	1251503.0
2013-01-10 17:30:00	SPY	ETF	147.22	147.29	147.2	147.29	42653.0
2013-01-10 18:00:00	SPY	ETF	147.29	147.46	147.25	147.32	144878.0
2013-01-10 18:30:00	SPY	ETF	147.3	147.38	147.29	147.33	11388.0
2013-01-10 19:00:00	SPY	ETF	147.33	147.33	147.26	147.26	21007.0
2013-01-10 19:30:00	SPY	ETF	147.26	147.28	147.21	147.22	43375.0
2013-01-10 06:00:00	QQQ	ETF	66.92	66.92	66.92	66.92	300.0
2013-01-10 06:30:00	QQQ	ETF	66.91	66.92	66.91	66.92	1300.0
2013-01-10 07:00:00	QQQ	ETF	66.92	66.93	66.89	66.92	17200.0
2013-01-10 07:30:00	QQQ	ETF	66.92	67.03	66.92	67.03	7700.0
2013-01-10 08:00:00	QQQ	ETF	67.01	67.17	67.01	67.14	85551.0
2013-01-10 08:30:00	QQQ	ETF	67.14	67.29	67.13	67.23	169712.0
2013-01-10 09:00:00	QQQ	ETF	67.24	67.24	67.19	67.2	256383.0
2013-01-10 09:30:00	QQQ	ETF	67.21	67.27	67.07	67.165	5155281.0
2013-01-10 10:00:00	QQQ	ETF	67.17	67.19	66.9	66.91	4475014.0
2013-01-10 10:30:00	QQQ	ETF	66.91	66.92	66.74	66.76	3612465.0
2013-01-10 11:00:00	QQQ	ETF	66.765	66.81	66.55	66.71	3742449.0
2013-01-10 11:30:00	QQQ	ETF	66.71	66.77	66.69	66.75	1457270.0
2013-01-10 12:00:00	QQQ	ETF	66.75	66.82	66.68	66.8	1203107.0
2013-01-10 12:30:00	QQQ	ETF	66.81	66.82	66.72	66.79	1221839.0
2013-01-10 13:00:00	QQQ	ETF	66.79	66.86	66.74	66.82	1133864.0
2013-01-10 13:30:00	QQQ	ETF	66.82	66.87	66.78	66.83	728468.0
2013-01-10 14:00:00	QQQ	ETF	66.83	66.8475	66.73	66.76	1041214.0
2013-01-10 14:30:00	QQQ	ETF	66.769	67.09	66.75	67.02	2883011.0

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

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