PREVIEW / etf_30min / 2012-04-19

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-19.parquet
  size:    278 KB
  rows:    9,474

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-19 04:00:00	SPY	ETF	139.17	139.17	138.92	139.16	4530.0
2012-04-19 04:30:00	SPY	ETF	139.16	139.38	138.78	138.95	23900.0
2012-04-19 05:00:00	SPY	ETF	138.85	139.07	138.85	139.01	6700.0
2012-04-19 05:30:00	SPY	ETF	139.14	139.23	139.14	139.23	12000.0
2012-04-19 06:00:00	SPY	ETF	139.19	139.19	139.08	139.08	57300.0
2012-04-19 06:30:00	SPY	ETF	139.05	139.11	138.93	139.02	80900.0
2012-04-19 07:00:00	SPY	ETF	139.0	139.19	138.5	138.56	1468548.0
2012-04-19 07:30:00	SPY	ETF	138.57	138.72	138.37	138.64	769749.0
2012-04-19 08:00:00	SPY	ETF	139.06	139.06	138.45	138.87	1534308.0
2012-04-19 08:30:00	SPY	ETF	138.81	139.29	138.22	138.38	2202867.0
2012-04-19 09:00:00	SPY	ETF	138.38	138.63	138.32	138.63	834036.0
2012-04-19 09:30:00	SPY	ETF	138.63	138.918	138.26	138.79	17014346.0
2012-04-19 10:00:00	SPY	ETF	138.78	138.79	137.97	138.371	24279639.0
2012-04-19 10:30:00	SPY	ETF	138.38	139.15	138.37	138.91	16640854.0
2012-04-19 11:00:00	SPY	ETF	138.91	139.1	138.62	138.62	11379891.0
2012-04-19 11:30:00	SPY	ETF	138.63	138.82	138.39	138.67	8304006.0
2012-04-19 12:00:00	SPY	ETF	138.66	138.69	138.08	138.13	11782911.0
2012-04-19 12:30:00	SPY	ETF	138.12	138.29	138.02	138.13	6675509.0
2012-04-19 13:00:00	SPY	ETF	138.14	138.29	137.83	138.03	10459846.0
2012-04-19 13:30:00	SPY	ETF	138.02	138.5823	137.73	137.76	7066510.0
2012-04-19 14:00:00	SPY	ETF	137.75	137.9	137.46	137.48	11447423.0
2012-04-19 14:30:00	SPY	ETF	137.48	137.53	137.07	137.425	15777082.0
2012-04-19 15:00:00	SPY	ETF	137.425	138.5823	137.27	137.642	18578462.0
2012-04-19 15:30:00	SPY	ETF	137.64	137.94	137.55	137.745	23263359.0
2012-04-19 16:00:00	SPY	ETF	137.76	138.39	137.55	137.84	5743378.0
2012-04-19 16:30:00	SPY	ETF	137.85	137.95	137.75	137.94	269965.0
2012-04-19 17:00:00	SPY	ETF	137.92	137.96	137.81	137.87	146396.0
2012-04-19 17:30:00	SPY	ETF	137.83	137.83	137.78	137.8	339901.0
2012-04-19 18:00:00	SPY	ETF	137.81	137.86	137.8	137.81	87580.0
2012-04-19 18:30:00	SPY	ETF	137.82	137.86	137.82	137.85	5286.0
2012-04-19 19:00:00	SPY	ETF	137.85	137.95	137.85	137.95	34765.0
2012-04-19 19:30:00	SPY	ETF	137.91	138.03	137.91	138.0	35100.0
2012-04-19 04:00:00	QQQ	ETF	66.8	66.8	66.6	66.6	1351.0
2012-04-19 05:00:00	QQQ	ETF	66.58	66.58	66.58	66.58	100.0
2012-04-19 05:30:00	QQQ	ETF	66.64	66.67	66.64	66.67	300.0
2012-04-19 06:00:00	QQQ	ETF	66.75	66.75	66.65	66.68	1729.0
2012-04-19 06:30:00	QQQ	ETF	66.63	66.68	66.63	66.68	12700.0
2012-04-19 07:00:00	QQQ	ETF	66.66	66.76	66.37	66.44	148017.0
2012-04-19 07:30:00	QQQ	ETF	66.44	66.47	66.33	66.46	106550.0
2012-04-19 08:00:00	QQQ	ETF	66.4	66.65	66.35	66.6	1476590.0
2012-04-19 08:30:00	QQQ	ETF	66.6	66.97	66.2	66.21	541695.0
2012-04-19 09:00:00	QQQ	ETF	66.2	66.41	66.2	66.37	286172.0
2012-04-19 09:30:00	QQQ	ETF	66.38	66.89	66.33	66.79	9385824.0
2012-04-19 10:00:00	QQQ	ETF	66.78	66.8	66.41	66.74	11185846.0
2012-04-19 10:30:00	QQQ	ETF	66.75	67.17	66.75	66.9614	6062908.0
2012-04-19 11:00:00	QQQ	ETF	66.97	67.03	66.73	66.77	3208387.0
2012-04-19 11:30:00	QQQ	ETF	66.77	66.88	66.58	66.7	2788189.0
2012-04-19 12:00:00	QQQ	ETF	66.7	66.71	66.33	66.355	4760291.0
2012-04-19 12:30:00	QQQ	ETF	66.35	66.45	66.25	66.25	3305953.0
2012-04-19 13:00:00	QQQ	ETF	66.255	66.37	66.1	66.2381	4777649.0

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

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