PREVIEW / etf_30min / 2012-04-09

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-09.parquet
  size:    284 KB
  rows:    9,706

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-09 04:00:00	SPY	ETF	138.23	138.42	138.15	138.35	6486.0
2012-04-09 04:30:00	SPY	ETF	138.25	138.25	138.16	138.16	782.0
2012-04-09 05:00:00	SPY	ETF	138.2	138.35	138.2	138.35	300.0
2012-04-09 05:30:00	SPY	ETF	138.22	138.27	138.02	138.04	72288.0
2012-04-09 06:00:00	SPY	ETF	138.03	138.07	137.97	138.07	89334.0
2012-04-09 06:30:00	SPY	ETF	138.03	138.07	137.97	138.0	20570.0
2012-04-09 07:00:00	SPY	ETF	138.02	138.19	138.01	138.16	100750.0
2012-04-09 07:30:00	SPY	ETF	138.18	138.19	137.96	138.02	155738.0
2012-04-09 08:00:00	SPY	ETF	138.03	138.23	137.97	137.99	304526.0
2012-04-09 08:30:00	SPY	ETF	138.0	139.79	137.94	138.07	861946.0
2012-04-09 09:00:00	SPY	ETF	138.08	138.11	137.96	138.02	1202797.0
2012-04-09 09:30:00	SPY	ETF	138.03	138.27	137.84	137.95	17528306.0
2012-04-09 10:00:00	SPY	ETF	137.95	138.3701	137.94	138.271	10999424.0
2012-04-09 10:30:00	SPY	ETF	138.277	138.31	138.1	138.28	7271854.0
2012-04-09 11:00:00	SPY	ETF	138.28	139.8444	137.92	137.949	10277361.0
2012-04-09 11:30:00	SPY	ETF	137.95	138.15	137.93	138.149	6319872.0
2012-04-09 12:00:00	SPY	ETF	138.14	138.27	138.08	138.23	3823423.0
2012-04-09 12:30:00	SPY	ETF	138.23	138.5	138.23	138.44	4656500.0
2012-04-09 13:00:00	SPY	ETF	138.45	138.5	138.27	138.28	3717349.0
2012-04-09 13:30:00	SPY	ETF	138.29	138.63	138.28	138.62	4147637.0
2012-04-09 14:00:00	SPY	ETF	138.62	138.64	138.44	138.5999	3987245.0
2012-04-09 14:30:00	SPY	ETF	138.59	139.8444	138.55	138.68	7287878.0
2012-04-09 15:00:00	SPY	ETF	138.68	139.8444	138.482	138.5	6625448.0
2012-04-09 15:30:00	SPY	ETF	138.48	138.52	138.24	138.25	17258746.0
2012-04-09 16:00:00	SPY	ETF	138.24	138.3774	137.93	137.95	8290609.0
2012-04-09 16:30:00	SPY	ETF	137.95	138.04	137.94	138.03	6580678.0
2012-04-09 17:00:00	SPY	ETF	138.03	139.8444	138.0	138.05	641315.0
2012-04-09 17:30:00	SPY	ETF	138.04	138.06	137.99	138.05	117709.0
2012-04-09 18:00:00	SPY	ETF	138.06	138.14	138.06	138.13	29005.0
2012-04-09 18:30:00	SPY	ETF	138.12	138.13	138.09	138.11	14820.0
2012-04-09 19:00:00	SPY	ETF	138.11	138.13	138.04	138.13	41688.0
2012-04-09 19:30:00	SPY	ETF	138.13	138.14	138.07	138.08	31705.0
2012-04-09 05:00:00	QQQ	ETF	67.0	67.0	66.8	66.8	700.0
2012-04-09 05:30:00	QQQ	ETF	66.75	66.75	66.75	66.75	100.0
2012-04-09 06:30:00	QQQ	ETF	67.56	67.56	66.9	66.91	2000.0
2012-04-09 07:00:00	QQQ	ETF	66.9	66.95	66.89	66.95	12150.0
2012-04-09 07:30:00	QQQ	ETF	66.95	66.95	66.88	66.92	73300.0
2012-04-09 08:00:00	QQQ	ETF	66.92	66.94	66.85	66.93	110061.0
2012-04-09 08:30:00	QQQ	ETF	66.92	66.97	66.92	66.96	115418.0
2012-04-09 09:00:00	QQQ	ETF	66.95	66.96	66.86	66.87	76755.0
2012-04-09 09:30:00	QQQ	ETF	66.88	67.06	66.76	66.8187	4913460.0
2012-04-09 10:00:00	QQQ	ETF	66.81	67.22	66.81	67.2123	5103996.0
2012-04-09 10:30:00	QQQ	ETF	67.21	67.34	67.1	67.34	3582770.0
2012-04-09 11:00:00	QQQ	ETF	67.335	67.34	67.06	67.08	3471936.0
2012-04-09 11:30:00	QQQ	ETF	67.0805	67.238	67.08	67.23	1539025.0
2012-04-09 12:00:00	QQQ	ETF	67.22	67.28	67.1614	67.2201	862137.0
2012-04-09 12:30:00	QQQ	ETF	67.2209	67.41	67.22	67.38	2094843.0
2012-04-09 13:00:00	QQQ	ETF	67.38	67.4	67.25	67.26	1152709.0
2012-04-09 13:30:00	QQQ	ETF	67.261	67.41	67.26	67.4	1302727.0
2012-04-09 14:00:00	QQQ	ETF	67.3999	67.42	67.3	67.39	1359485.0

> showing 50 of 9,706 rows — these rows as CSV

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