PREVIEW / etf_30min / 2012-09-21

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-21.parquet
  size:    288 KB
  rows:    9,772

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-21 04:00:00	SPY	ETF	146.74	146.74	146.27	146.28	7373.0
2012-09-21 04:30:00	SPY	ETF	146.3	146.5	146.3	146.5	1635.0
2012-09-21 05:00:00	SPY	ETF	146.5	146.5	146.36	146.36	750.0
2012-09-21 06:00:00	SPY	ETF	146.33	146.33	146.15	146.15	3900.0
2012-09-21 06:30:00	SPY	ETF	146.13	146.3	146.1	146.12	5150.0
2012-09-21 07:00:00	SPY	ETF	146.12	146.52	146.11	146.28	147280.0
2012-09-21 07:30:00	SPY	ETF	146.27	146.38	146.25	146.29	47609.0
2012-09-21 08:00:00	SPY	ETF	146.31	146.4	146.29	146.35	264898.0
2012-09-21 08:30:00	SPY	ETF	146.36	146.5	146.33	146.49	596927.0
2012-09-21 09:00:00	SPY	ETF	146.49	146.76	146.44	146.66	1525449.0
2012-09-21 09:30:00	SPY	ETF	146.64	146.67	146.35	146.5099	14659887.0
2012-09-21 10:00:00	SPY	ETF	146.51	146.54	146.35	146.5129	6553888.0
2012-09-21 10:30:00	SPY	ETF	146.52	146.57	146.25	146.2728	8387493.0
2012-09-21 11:00:00	SPY	ETF	146.2701	146.415	146.2	146.28	5878048.0
2012-09-21 11:30:00	SPY	ETF	146.29	146.43	146.27	146.36	7318407.0
2012-09-21 12:00:00	SPY	ETF	146.355	146.42	146.17	146.25	4372533.0
2012-09-21 12:30:00	SPY	ETF	146.25	146.36	146.23	146.2799	3122527.0
2012-09-21 13:00:00	SPY	ETF	146.2799	146.33	146.24	146.25	4659977.0
2012-09-21 13:30:00	SPY	ETF	146.26	146.37	146.23	146.3	4687754.0
2012-09-21 14:00:00	SPY	ETF	146.3	146.31	146.03	146.12	5686616.0
2012-09-21 14:30:00	SPY	ETF	146.1195	146.23	146.04	146.1	4703759.0
2012-09-21 15:00:00	SPY	ETF	146.1	146.2	146.05	146.06	6709703.0
2012-09-21 15:30:00	SPY	ETF	146.06	146.12	145.81	145.88	15361501.0
2012-09-21 16:00:00	SPY	ETF	145.89	146.6161	145.2206	145.9	10439871.0
2012-09-21 16:30:00	SPY	ETF	145.89	146.2597	145.82	145.86	1054869.0
2012-09-21 17:00:00	SPY	ETF	145.86	145.98	145.81	145.97	135778.0
2012-09-21 17:30:00	SPY	ETF	145.96	146.01	145.84	145.84	139583.0
2012-09-21 18:00:00	SPY	ETF	145.83	145.99	145.83	145.95	71890.0
2012-09-21 18:30:00	SPY	ETF	145.97	145.98	145.91	145.97	25077.0
2012-09-21 19:00:00	SPY	ETF	145.95	145.99	145.95	145.98	35723.0
2012-09-21 19:30:00	SPY	ETF	145.98	146.0	145.95	145.99	19233.0
2012-09-21 05:00:00	QQQ	ETF	70.33	70.33	70.33	70.33	300.0
2012-09-21 06:30:00	QQQ	ETF	70.37	70.37	70.37	70.37	300.0
2012-09-21 07:00:00	QQQ	ETF	70.39	70.39	70.23	70.27	59390.0
2012-09-21 07:30:00	QQQ	ETF	70.27	70.31	70.27	70.29	15875.0
2012-09-21 08:00:00	QQQ	ETF	70.29	70.55	70.27	70.35	143149.0
2012-09-21 08:30:00	QQQ	ETF	70.36	70.41	70.35	70.41	183964.0
2012-09-21 09:00:00	QQQ	ETF	70.42	70.52	70.42	70.47	181796.0
2012-09-21 09:30:00	QQQ	ETF	70.47	70.54	70.41	70.49	3841890.0
2012-09-21 10:00:00	QQQ	ETF	70.48	70.5	70.38	70.48	2359903.0
2012-09-21 10:30:00	QQQ	ETF	70.47	70.5	70.37	70.38	2475502.0
2012-09-21 11:00:00	QQQ	ETF	70.39	70.42	70.33	70.35	1330977.0
2012-09-21 11:30:00	QQQ	ETF	70.36	70.41	70.34	70.4	671879.0
2012-09-21 12:00:00	QQQ	ETF	70.4	70.43	70.32	70.3516	671805.0
2012-09-21 12:30:00	QQQ	ETF	70.35	70.44	70.35	70.42	587560.0
2012-09-21 13:00:00	QQQ	ETF	70.42	70.44	70.35	70.36	415423.0
2012-09-21 13:30:00	QQQ	ETF	70.36	70.4	70.32	70.345	787276.0
2012-09-21 14:00:00	QQQ	ETF	70.3401	70.35	70.1499	70.21	1467432.0
2012-09-21 14:30:00	QQQ	ETF	70.21	70.26	70.16	70.21	1162966.0
2012-09-21 15:00:00	QQQ	ETF	70.21	70.29	70.18	70.2	2049524.0

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

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