PREVIEW / etf_30min / 2012-09-24

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-24.parquet
  size:    289 KB
  rows:    9,831

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-09-24 04:00:00	SPY	ETF	145.66	145.66	145.31	145.31	10686.0
2012-09-24 04:30:00	SPY	ETF	145.39	145.39	145.32	145.32	5565.0
2012-09-24 05:00:00	SPY	ETF	145.3	145.31	145.3	145.31	650.0
2012-09-24 05:30:00	SPY	ETF	145.28	145.28	145.07	145.1	33500.0
2012-09-24 06:00:00	SPY	ETF	145.07	145.14	145.07	145.14	8950.0
2012-09-24 06:30:00	SPY	ETF	145.13	145.19	145.12	145.17	15840.0
2012-09-24 07:00:00	SPY	ETF	145.17	145.23	145.14	145.16	14680.0
2012-09-24 07:30:00	SPY	ETF	145.18	145.35	145.18	145.27	89555.0
2012-09-24 08:00:00	SPY	ETF	145.28	145.95	145.16	145.2	197527.0
2012-09-24 08:30:00	SPY	ETF	145.21	145.21	145.05	145.12	861424.0
2012-09-24 09:00:00	SPY	ETF	145.13	145.27	145.12	145.15	637887.0
2012-09-24 09:30:00	SPY	ETF	145.15	145.415	145.04	145.3598	14887432.0
2012-09-24 10:00:00	SPY	ETF	145.35	145.47	145.18	145.36	9466975.0
2012-09-24 10:30:00	SPY	ETF	145.36	145.8925	145.36	145.66	7824760.0
2012-09-24 11:00:00	SPY	ETF	145.66	145.74	145.48	145.53	5253927.0
2012-09-24 11:30:00	SPY	ETF	145.53	145.57	145.39	145.5	3477742.0
2012-09-24 12:00:00	SPY	ETF	145.49	145.53	145.39	145.4	4540264.0
2012-09-24 12:30:00	SPY	ETF	145.4	145.43	145.27	145.42	4149677.0
2012-09-24 13:00:00	SPY	ETF	145.425	145.47	145.38	145.41	1913980.0
2012-09-24 13:30:00	SPY	ETF	145.41	145.41	145.27	145.34	3441889.0
2012-09-24 14:00:00	SPY	ETF	145.34	145.65	145.33	145.65	4755511.0
2012-09-24 14:30:00	SPY	ETF	145.64	145.98	145.62	145.861	5823598.0
2012-09-24 15:00:00	SPY	ETF	145.87	145.91	145.695	145.86	4940361.0
2012-09-24 15:30:00	SPY	ETF	145.85	145.851	145.52	145.6199	11502212.0
2012-09-24 16:00:00	SPY	ETF	145.61	145.8925	145.2739	145.72	5322749.0
2012-09-24 16:30:00	SPY	ETF	145.72	145.75	145.5226	145.74	3344914.0
2012-09-24 17:00:00	SPY	ETF	145.75	145.83	145.74	145.83	36444.0
2012-09-24 17:30:00	SPY	ETF	145.8	145.82	145.78	145.82	52266.0
2012-09-24 18:00:00	SPY	ETF	145.81	145.84	145.72	145.72	27244.0
2012-09-24 18:30:00	SPY	ETF	145.71	145.81	145.71	145.79	6556.0
2012-09-24 19:00:00	SPY	ETF	145.76	145.76	145.75	145.75	700.0
2012-09-24 19:30:00	SPY	ETF	145.75	145.83	145.75	145.78	24769.0
2012-09-24 06:30:00	QQQ	ETF	69.86	69.86	69.85	69.85	350.0
2012-09-24 07:00:00	QQQ	ETF	69.85	69.86	69.83	69.85	4110.0
2012-09-24 07:30:00	QQQ	ETF	69.86	69.93	69.86	69.87	62900.0
2012-09-24 08:00:00	QQQ	ETF	69.86	69.88	69.84	69.85	47835.0
2012-09-24 08:30:00	QQQ	ETF	69.83	69.83	69.57	69.57	789577.0
2012-09-24 09:00:00	QQQ	ETF	69.58	69.66	69.54	69.55	322346.0
2012-09-24 09:30:00	QQQ	ETF	69.56	69.77	69.42	69.74	3726585.0
2012-09-24 10:00:00	QQQ	ETF	69.73	69.79	69.49	69.58	2562376.0
2012-09-24 10:30:00	QQQ	ETF	69.58	69.75	69.58	69.74	1446644.0
2012-09-24 11:00:00	QQQ	ETF	69.74	69.78	69.61	69.638	1126429.0
2012-09-24 11:30:00	QQQ	ETF	69.64	69.65	69.53	69.62	1033291.0
2012-09-24 12:00:00	QQQ	ETF	69.62	69.64	69.555	69.58	885128.0
2012-09-24 12:30:00	QQQ	ETF	69.58	69.63	69.5	69.6	1050538.0
2012-09-24 13:00:00	QQQ	ETF	69.61	69.62	69.54	69.565	611289.0
2012-09-24 13:30:00	QQQ	ETF	69.56	69.56	69.45	69.49	937520.0
2012-09-24 14:00:00	QQQ	ETF	69.4899	69.71	69.48	69.7	1047483.0
2012-09-24 14:30:00	QQQ	ETF	69.71	69.8499	69.68	69.8	2121590.0
2012-09-24 15:00:00	QQQ	ETF	69.8	69.86	69.7301	69.81	1446257.0

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

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