PREVIEW / etf_30min / 2012-04-05

all etf 30-min files

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

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-05 04:00:00	SPY	ETF	140.14	140.15	140.1	140.1	1100.0
2012-04-05 04:30:00	SPY	ETF	139.5	139.56	139.5	139.56	20400.0
2012-04-05 05:00:00	SPY	ETF	139.68	139.7	139.45	139.45	1400.0
2012-04-05 05:30:00	SPY	ETF	139.37	139.37	139.03	139.08	69290.0
2012-04-05 06:00:00	SPY	ETF	139.02	139.11	138.92	139.06	93370.0
2012-04-05 06:30:00	SPY	ETF	139.13	139.35	139.1	139.35	74625.0
2012-04-05 07:00:00	SPY	ETF	139.32	139.38	139.23	139.37	211237.0
2012-04-05 07:30:00	SPY	ETF	139.33	139.38	139.16	139.38	152588.0
2012-04-05 08:00:00	SPY	ETF	139.36	139.95	138.95	139.08	920674.0
2012-04-05 08:30:00	SPY	ETF	139.08	139.45	139.08	139.31	2124284.0
2012-04-05 09:00:00	SPY	ETF	139.32	139.43	139.2417	139.38	993003.0
2012-04-05 09:30:00	SPY	ETF	139.38	139.82	139.26	139.665	14539788.0
2012-04-05 10:00:00	SPY	ETF	139.67	139.96	139.65	139.8	9285478.0
2012-04-05 10:30:00	SPY	ETF	139.8	140.13	139.66	140.13	8370788.0
2012-04-05 11:00:00	SPY	ETF	140.125	140.2	140.0	140.02	8372987.0
2012-04-05 11:30:00	SPY	ETF	140.03	140.06	139.83	140.0	7263779.0
2012-04-05 12:00:00	SPY	ETF	139.9993	140.04	139.85	139.92	5852432.0
2012-04-05 12:30:00	SPY	ETF	139.91	139.95	139.76	139.81	3595886.0
2012-04-05 13:00:00	SPY	ETF	139.81	139.91	139.78	139.83	4940406.0
2012-04-05 13:30:00	SPY	ETF	139.82	139.85	139.47	139.5887	7050345.0
2012-04-05 14:00:00	SPY	ETF	139.59	139.76	139.55	139.71	5657197.0
2012-04-05 14:30:00	SPY	ETF	139.71	139.83	139.62	139.78	5175904.0
2012-04-05 15:00:00	SPY	ETF	139.79	139.9278	139.66	139.82	7956870.0
2012-04-05 15:30:00	SPY	ETF	139.83	139.93	139.77	139.796	17009760.0
2012-04-05 16:00:00	SPY	ETF	139.79	140.0525	138.87	139.56	16824522.0
2012-04-05 16:30:00	SPY	ETF	139.56	139.78	139.46	139.66	906886.0
2012-04-05 17:00:00	SPY	ETF	139.62	139.65	139.56	139.62	112949.0
2012-04-05 17:30:00	SPY	ETF	139.61	139.8406	139.58	139.61	45882.0
2012-04-05 18:00:00	SPY	ETF	139.62	139.67	139.57	139.65	130225.0
2012-04-05 18:30:00	SPY	ETF	139.66	139.69	139.64	139.65	119502.0
2012-04-05 19:00:00	SPY	ETF	139.65	139.68	139.55	139.55	12352.0
2012-04-05 19:30:00	SPY	ETF	139.57	139.66	139.57	139.6	19355.0
2012-04-05 05:30:00	QQQ	ETF	66.98	66.98	66.98	66.98	4000.0
2012-04-05 06:00:00	QQQ	ETF	66.93	67.02	66.88	67.02	70500.0
2012-04-05 06:30:00	QQQ	ETF	67.02	67.02	67.0	67.01	15300.0
2012-04-05 07:00:00	QQQ	ETF	67.09	67.13	67.06	67.13	11100.0
2012-04-05 07:30:00	QQQ	ETF	67.11	67.14	67.02	67.14	43630.0
2012-04-05 08:00:00	QQQ	ETF	67.14	67.3	66.99	67.04	864579.0
2012-04-05 08:30:00	QQQ	ETF	67.04	67.25	67.03	67.16	284065.0
2012-04-05 09:00:00	QQQ	ETF	67.16	67.21	67.15	67.18	142955.0
2012-04-05 09:30:00	QQQ	ETF	67.19	67.38	67.13	67.28	2277198.0
2012-04-05 10:00:00	QQQ	ETF	67.28	67.38	67.26	67.34	2632107.0
2012-04-05 10:30:00	QQQ	ETF	67.34	67.57	67.28	67.57	2964493.0
2012-04-05 11:00:00	QQQ	ETF	67.57	67.665	67.53	67.605	2673278.0
2012-04-05 11:30:00	QQQ	ETF	67.6	67.7	67.56	67.7	1489028.0
2012-04-05 12:00:00	QQQ	ETF	67.7	67.76	67.67	67.732	2200561.0
2012-04-05 12:30:00	QQQ	ETF	67.7371	67.78	67.64	67.66	1486617.0
2012-04-05 13:00:00	QQQ	ETF	67.665	67.74	67.665	67.715	1410850.0
2012-04-05 13:30:00	QQQ	ETF	67.715	67.74	67.56	67.62	1644692.0
2012-04-05 14:00:00	QQQ	ETF	67.6299	67.68	67.58	67.64	1619939.0

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

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