PREVIEW / etf_30min / 2012-03-29

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-29.parquet
  size:    284 KB
  rows:    9,608

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-03-29 04:00:00	SPY	ETF	140.52	140.7	140.5	140.55	8300.0
2012-03-29 04:30:00	SPY	ETF	140.49	140.49	140.48	140.48	602.0
2012-03-29 05:00:00	SPY	ETF	140.36	140.36	140.12	140.12	97850.0
2012-03-29 05:30:00	SPY	ETF	140.16	140.16	140.08	140.09	10540.0
2012-03-29 06:00:00	SPY	ETF	140.0	140.05	139.95	140.05	81214.0
2012-03-29 06:30:00	SPY	ETF	140.03	140.03	139.98	140.0	34500.0
2012-03-29 07:00:00	SPY	ETF	140.0	140.14	139.93	140.11	52576.0
2012-03-29 07:30:00	SPY	ETF	140.14	140.18	140.04	140.14	168538.0
2012-03-29 08:00:00	SPY	ETF	140.15	140.2	140.05	140.13	411622.0
2012-03-29 08:30:00	SPY	ETF	140.07	140.35	139.82	140.03	1337733.0
2012-03-29 09:00:00	SPY	ETF	140.04	140.04	139.51	139.63	2112714.0
2012-03-29 09:30:00	SPY	ETF	139.64	139.88	139.35	139.56	18916505.0
2012-03-29 10:00:00	SPY	ETF	139.55	139.75	139.24	139.26	15303746.0
2012-03-29 10:30:00	SPY	ETF	139.27	139.49	139.1	139.475	13898446.0
2012-03-29 11:00:00	SPY	ETF	139.47	139.56	139.22	139.22	10610051.0
2012-03-29 11:30:00	SPY	ETF	139.22	139.39	139.09	139.22	9417009.0
2012-03-29 12:00:00	SPY	ETF	139.23	139.36	139.19	139.25	6022270.0
2012-03-29 12:30:00	SPY	ETF	139.24	139.56	139.13	139.525	10621124.0
2012-03-29 13:00:00	SPY	ETF	139.53	140.4934	139.31	139.42	9936427.0
2012-03-29 13:30:00	SPY	ETF	139.42	139.53	139.28	139.405	5491182.0
2012-03-29 14:00:00	SPY	ETF	139.39	139.83	139.38	139.78	8588543.0
2012-03-29 14:30:00	SPY	ETF	139.79	139.87	139.66	139.76	7509330.0
2012-03-29 15:00:00	SPY	ETF	139.75	140.16	139.67	140.01	13073084.0
2012-03-29 15:30:00	SPY	ETF	140.01	140.4934	140.005	140.22	18950394.0
2012-03-29 16:00:00	SPY	ETF	140.21	140.4934	139.65	140.23	8105770.0
2012-03-29 16:30:00	SPY	ETF	140.24	140.4934	140.1722	140.32	1285916.0
2012-03-29 17:00:00	SPY	ETF	140.33	140.37	140.22	140.26	114333.0
2012-03-29 17:30:00	SPY	ETF	140.24	140.27	140.19	140.26	45850.0
2012-03-29 18:00:00	SPY	ETF	140.26	140.27	140.19	140.23	17580.0
2012-03-29 18:30:00	SPY	ETF	140.21	140.23	140.21	140.21	8400.0
2012-03-29 19:00:00	SPY	ETF	140.23	140.24	140.15	140.18	24101.0
2012-03-29 19:30:00	SPY	ETF	140.17	140.24	140.15	140.2	28862.0
2012-03-29 04:00:00	QQQ	ETF	68.02	68.02	68.02	68.02	100.0
2012-03-29 05:30:00	QQQ	ETF	67.81	67.81	67.81	67.81	100.0
2012-03-29 06:00:00	QQQ	ETF	67.8	67.82	67.8	67.82	643.0
2012-03-29 06:30:00	QQQ	ETF	67.8	67.8	67.78	67.8	11500.0
2012-03-29 07:00:00	QQQ	ETF	67.75	67.83	67.74	67.83	7400.0
2012-03-29 07:30:00	QQQ	ETF	67.82	67.86	67.77	67.79	153870.0
2012-03-29 08:00:00	QQQ	ETF	67.83	67.85	67.77	67.81	417532.0
2012-03-29 08:30:00	QQQ	ETF	67.79	67.79	67.7	67.79	480022.0
2012-03-29 09:00:00	QQQ	ETF	67.79	67.8	67.54	67.61	709687.0
2012-03-29 09:30:00	QQQ	ETF	67.61	67.93	67.56	67.64	7932188.0
2012-03-29 10:00:00	QQQ	ETF	67.64	67.81	67.5205	67.54	4598460.0
2012-03-29 10:30:00	QQQ	ETF	67.55	67.63	67.46	67.62	2589370.0
2012-03-29 11:00:00	QQQ	ETF	67.61	67.65	67.365	67.37	2985595.0
2012-03-29 11:30:00	QQQ	ETF	67.36	67.44	67.21	67.29	3440170.0
2012-03-29 12:00:00	QQQ	ETF	67.2889	67.37	67.2301	67.32	2046449.0
2012-03-29 12:30:00	QQQ	ETF	67.32	67.47	67.2	67.4495	3842038.0
2012-03-29 13:00:00	QQQ	ETF	67.45	67.458	67.3	67.34	2951724.0
2012-03-29 13:30:00	QQQ	ETF	67.34	67.4	67.26	67.33	1448954.0

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

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