PREVIEW / etf_30min / 2012-04-10

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-10.parquet
  size:    306 KB
  rows:    10,175

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-04-10 04:00:00	SPY	ETF	138.24	138.39	138.24	138.39	1800.0
2012-04-10 04:30:00	SPY	ETF	138.5	138.5	138.39	138.42	1800.0
2012-04-10 05:00:00	SPY	ETF	138.37	138.4	138.29	138.29	2404.0
2012-04-10 05:30:00	SPY	ETF	138.42	138.42	138.42	138.42	2500.0
2012-04-10 06:00:00	SPY	ETF	138.37	138.37	138.19	138.35	7600.0
2012-04-10 06:30:00	SPY	ETF	138.27	138.4	138.22	138.26	21900.0
2012-04-10 07:00:00	SPY	ETF	138.16	138.23	138.1	138.13	52680.0
2012-04-10 07:30:00	SPY	ETF	138.12	138.2	137.94	138.2	205379.0
2012-04-10 08:00:00	SPY	ETF	138.23	138.26	138.01	138.15	570267.0
2012-04-10 08:30:00	SPY	ETF	138.15	138.22	138.02	138.06	497254.0
2012-04-10 09:00:00	SPY	ETF	138.06	138.09	137.8346	137.95	1339310.0
2012-04-10 09:30:00	SPY	ETF	137.95	138.34	137.83	138.15	13435320.0
2012-04-10 10:00:00	SPY	ETF	138.15	138.23	137.57	137.81	17993812.0
2012-04-10 10:30:00	SPY	ETF	137.8	137.86	137.45	137.53	10417711.0
2012-04-10 11:00:00	SPY	ETF	137.53	137.66	137.3	137.4372	14860175.0
2012-04-10 11:30:00	SPY	ETF	137.43	137.4677	136.58	136.81	22455285.0
2012-04-10 12:00:00	SPY	ETF	136.81	136.82	136.2	136.505	23627734.0
2012-04-10 12:30:00	SPY	ETF	136.505	136.6	136.23	136.409	12652384.0
2012-04-10 13:00:00	SPY	ETF	136.409	136.48	135.95	136.17	15919440.0
2012-04-10 13:30:00	SPY	ETF	136.18	136.42	136.04	136.26	10483948.0
2012-04-10 14:00:00	SPY	ETF	136.27	136.36	135.98	136.199	10432095.0
2012-04-10 14:30:00	SPY	ETF	136.19	136.25	135.76	136.08	15704348.0
2012-04-10 15:00:00	SPY	ETF	136.08	136.11	135.81	135.96	17794357.0
2012-04-10 15:30:00	SPY	ETF	135.965	136.3	135.85	135.86	32735786.0
2012-04-10 16:00:00	SPY	ETF	135.86	136.36	135.84	136.26	6817577.0
2012-04-10 16:30:00	SPY	ETF	136.27	138.1112	135.84	136.43	4528068.0
2012-04-10 17:00:00	SPY	ETF	136.4	136.54	136.38	136.5	658109.0
2012-04-10 17:30:00	SPY	ETF	136.49	136.52	136.45	136.48	86860.0
2012-04-10 18:00:00	SPY	ETF	136.48	136.49	136.42	136.44	21678.0
2012-04-10 18:30:00	SPY	ETF	136.46	136.46	136.35	136.37	38245.0
2012-04-10 19:00:00	SPY	ETF	136.41	136.56	136.39	136.49	107029.0
2012-04-10 19:30:00	SPY	ETF	136.51	136.53	136.44	136.5	68024.0
2012-04-10 04:00:00	QQQ	ETF	67.26	67.26	67.26	67.26	200.0
2012-04-10 06:00:00	QQQ	ETF	67.19	67.19	67.19	67.19	200.0
2012-04-10 07:00:00	QQQ	ETF	67.2	67.2	67.18	67.18	7800.0
2012-04-10 07:30:00	QQQ	ETF	67.18	67.22	67.13	67.22	49000.0
2012-04-10 08:00:00	QQQ	ETF	67.23	67.26	67.18	67.22	146653.0
2012-04-10 08:30:00	QQQ	ETF	67.24	67.26	67.17	67.19	348595.0
2012-04-10 09:00:00	QQQ	ETF	67.19	67.24	67.1	67.21	455899.0
2012-04-10 09:30:00	QQQ	ETF	67.2	67.43	67.1399	67.37	4515934.0
2012-04-10 10:00:00	QQQ	ETF	67.361	67.44	67.0	67.15	4775021.0
2012-04-10 10:30:00	QQQ	ETF	67.15	67.23	67.05	67.1	2201623.0
2012-04-10 11:00:00	QQQ	ETF	67.1	67.17	66.89	67.035	3963125.0
2012-04-10 11:30:00	QQQ	ETF	67.035	67.035	66.47	66.6027	7278027.0
2012-04-10 12:00:00	QQQ	ETF	66.61	66.62	66.14	66.4319	7511357.0
2012-04-10 12:30:00	QQQ	ETF	66.43	66.47	66.23	66.36	3182091.0
2012-04-10 13:00:00	QQQ	ETF	66.36	66.39	66.09	66.26	4468184.0
2012-04-10 13:30:00	QQQ	ETF	66.27	66.33	66.14	66.27	2476934.0
2012-04-10 14:00:00	QQQ	ETF	66.25	66.345	66.1	66.209	3116489.0
2012-04-10 14:30:00	QQQ	ETF	66.2	66.24	65.92	66.18	4665804.0

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

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