PREVIEW / etf_30min / 2012-11-21

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-21.parquet
  size:    272 KB
  rows:    9,270

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-11-21 04:00:00	SPY	ETF	139.07	139.12	139.05	139.12	29795.0
2012-11-21 04:30:00	SPY	ETF	139.14	139.14	139.12	139.12	12000.0
2012-11-21 05:00:00	SPY	ETF	139.07	139.17	138.9	139.17	10250.0
2012-11-21 05:30:00	SPY	ETF	139.17	139.17	139.03	139.15	6200.0
2012-11-21 06:00:00	SPY	ETF	139.17	139.32	139.17	139.28	145600.0
2012-11-21 06:30:00	SPY	ETF	139.3	139.42	139.19	139.41	70250.0
2012-11-21 07:00:00	SPY	ETF	139.41	139.47	139.3	139.32	117856.0
2012-11-21 07:30:00	SPY	ETF	139.31	139.32	139.15	139.29	251370.0
2012-11-21 08:00:00	SPY	ETF	139.28	139.47	139.05	139.41	298022.0
2012-11-21 08:30:00	SPY	ETF	139.44	139.46	139.3	139.45	485423.0
2012-11-21 09:00:00	SPY	ETF	139.44	139.54	139.2002	139.31	808492.0
2012-11-21 09:30:00	SPY	ETF	139.31	139.52	139.13	139.45	11048592.0
2012-11-21 10:00:00	SPY	ETF	139.45	139.47	139.03	139.23	10326140.0
2012-11-21 10:30:00	SPY	ETF	139.23	139.33	139.07	139.201	6820660.0
2012-11-21 11:00:00	SPY	ETF	139.2	139.37	139.14	139.3	4829941.0
2012-11-21 11:30:00	SPY	ETF	139.3	139.34	139.12	139.189	3676835.0
2012-11-21 12:00:00	SPY	ETF	139.19	139.48	139.18	139.4403	2953549.0
2012-11-21 12:30:00	SPY	ETF	139.445	139.57	139.39	139.45	3452309.0
2012-11-21 13:00:00	SPY	ETF	139.46	139.49	139.37	139.42	2263913.0
2012-11-21 13:30:00	SPY	ETF	139.43	139.565	139.36	139.5	2932200.0
2012-11-21 14:00:00	SPY	ETF	139.495	139.55	139.31	139.42	2982338.0
2012-11-21 14:30:00	SPY	ETF	139.43	139.46	139.385	139.41	1873466.0
2012-11-21 15:00:00	SPY	ETF	139.41	139.55	139.32	139.37	4377391.0
2012-11-21 15:30:00	SPY	ETF	139.37	139.56	139.35	139.52	9290859.0
2012-11-21 16:00:00	SPY	ETF	139.5	139.65	139.3424	139.62	5975814.0
2012-11-21 16:30:00	SPY	ETF	139.62	139.63	139.56	139.58	458640.0
2012-11-21 17:00:00	SPY	ETF	139.58	139.6	139.55	139.56	24450.0
2012-11-21 17:30:00	SPY	ETF	139.59	139.59	139.57	139.58	13640.0
2012-11-21 18:00:00	SPY	ETF	139.58	139.87	139.56	139.74	72377.0
2012-11-21 18:30:00	SPY	ETF	139.74	139.78	139.7	139.73	19245.0
2012-11-21 19:00:00	SPY	ETF	139.72	139.81	139.72	139.81	33519.0
2012-11-21 19:30:00	SPY	ETF	139.77	139.87	139.74	139.85	42936.0
2012-11-21 05:00:00	QQQ	ETF	63.64	63.64	63.64	63.64	200.0
2012-11-21 06:00:00	QQQ	ETF	63.78	63.78	63.77	63.78	6300.0
2012-11-21 06:30:00	QQQ	ETF	63.75	63.85	63.75	63.85	456.0
2012-11-21 07:00:00	QQQ	ETF	63.83	63.83	63.81	63.81	800.0
2012-11-21 07:30:00	QQQ	ETF	63.81	63.85	63.78	63.83	30278.0
2012-11-21 08:00:00	QQQ	ETF	63.82	63.85	63.81	63.85	15255.0
2012-11-21 08:30:00	QQQ	ETF	63.84	63.9	63.81	63.88	103132.0
2012-11-21 09:00:00	QQQ	ETF	63.92	63.93	63.85	63.85	209512.0
2012-11-21 09:30:00	QQQ	ETF	63.84	64.02	63.77	63.96	3895834.0
2012-11-21 10:00:00	QQQ	ETF	63.959	63.97	63.6401	63.73	1830074.0
2012-11-21 10:30:00	QQQ	ETF	63.73	63.8	63.6	63.72	1245478.0
2012-11-21 11:00:00	QQQ	ETF	63.73	63.87	63.7099	63.86	1046627.0
2012-11-21 11:30:00	QQQ	ETF	63.86	63.87	63.75	63.7855	704669.0
2012-11-21 12:00:00	QQQ	ETF	63.79	63.94	63.77	63.9	838630.0
2012-11-21 12:30:00	QQQ	ETF	63.91	63.99	63.88	63.94	600392.0
2012-11-21 13:00:00	QQQ	ETF	63.95	63.96	63.85	63.905	457606.0
2012-11-21 13:30:00	QQQ	ETF	63.91	63.99	63.91	63.9599	476394.0
2012-11-21 14:00:00	QQQ	ETF	63.96	64.011	63.93	63.98	839435.0

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

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