PREVIEW / etf_30min / 2012-08-03

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-03.parquet
  size:    280 KB
  rows:    9,593

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-08-03 04:00:00	SPY	ETF	137.35	137.73	137.35	137.64	6700.0
2012-08-03 04:30:00	SPY	ETF	137.65	137.69	137.48	137.65	11120.0
2012-08-03 05:00:00	SPY	ETF	137.68	137.94	137.6	137.92	18558.0
2012-08-03 05:30:00	SPY	ETF	137.92	137.96	137.75	137.77	7300.0
2012-08-03 06:00:00	SPY	ETF	137.71	137.8	137.67	137.72	35420.0
2012-08-03 06:30:00	SPY	ETF	137.87	138.11	137.84	138.11	69603.0
2012-08-03 07:00:00	SPY	ETF	138.02	138.24	138.02	138.05	240235.0
2012-08-03 07:30:00	SPY	ETF	138.05	138.08	137.94	137.95	225915.0
2012-08-03 08:00:00	SPY	ETF	137.94	138.22	137.6	138.07	1962833.0
2012-08-03 08:30:00	SPY	ETF	138.05	138.61	138.05	138.38	4153115.0
2012-08-03 09:00:00	SPY	ETF	138.39	138.74	136.64	138.57	2496960.0
2012-08-03 09:30:00	SPY	ETF	138.56	139.05	138.49	138.992	22321736.0
2012-08-03 10:00:00	SPY	ETF	139.0	139.42	138.995	139.39	16584174.0
2012-08-03 10:30:00	SPY	ETF	139.39	139.41	139.1	139.24	10481645.0
2012-08-03 11:00:00	SPY	ETF	139.24	139.48	139.17	139.36	7536685.0
2012-08-03 11:30:00	SPY	ETF	139.36	139.57	139.35	139.56	6710925.0
2012-08-03 12:00:00	SPY	ETF	139.55	139.64	139.45	139.58	5691068.0
2012-08-03 12:30:00	SPY	ETF	139.58	139.62	139.42	139.43	3806944.0
2012-08-03 13:00:00	SPY	ETF	139.42	139.54	139.41	139.44	3209987.0
2012-08-03 13:30:00	SPY	ETF	139.435	139.49	139.36	139.46	2958665.0
2012-08-03 14:00:00	SPY	ETF	139.46	139.56	139.445	139.51	5280001.0
2012-08-03 14:30:00	SPY	ETF	139.51	139.52	139.36	139.43	4810079.0
2012-08-03 15:00:00	SPY	ETF	139.43	139.54	139.32	139.33	10712536.0
2012-08-03 15:30:00	SPY	ETF	139.33	139.39	139.07	139.35	25652210.0
2012-08-03 16:00:00	SPY	ETF	139.33	139.6	136.6884	139.6	18329521.0
2012-08-03 16:30:00	SPY	ETF	139.59	139.63	139.296	139.59	861941.0
2012-08-03 17:00:00	SPY	ETF	139.57	139.6	139.5	139.51	257353.0
2012-08-03 17:30:00	SPY	ETF	139.54	139.54	139.47	139.49	37394.0
2012-08-03 18:00:00	SPY	ETF	139.48	139.6	139.48	139.5	58438.0
2012-08-03 18:30:00	SPY	ETF	139.52	139.57	139.47	139.51	25025.0
2012-08-03 19:00:00	SPY	ETF	139.5	139.5	139.47	139.5	9075.0
2012-08-03 19:30:00	SPY	ETF	139.48	139.59	139.46	139.57	22124.0
2012-08-03 04:00:00	QQQ	ETF	64.59	64.83	64.59	64.83	650.0
2012-08-03 05:00:00	QQQ	ETF	64.82	64.88	64.82	64.88	2300.0
2012-08-03 06:00:00	QQQ	ETF	64.86	64.86	64.86	64.86	100.0
2012-08-03 06:30:00	QQQ	ETF	64.96	64.96	64.96	64.96	300.0
2012-08-03 07:00:00	QQQ	ETF	64.99	65.04	64.96	65.01	209100.0
2012-08-03 07:30:00	QQQ	ETF	65.0	65.01	64.96	64.96	43400.0
2012-08-03 08:00:00	QQQ	ETF	64.94	65.11	64.9	65.02	1929771.0
2012-08-03 08:30:00	QQQ	ETF	65.08	65.24	65.05	65.24	602685.0
2012-08-03 09:00:00	QQQ	ETF	65.24	65.45	65.23	65.39	1233968.0
2012-08-03 09:30:00	QQQ	ETF	65.39	65.59	65.19	65.58	7289820.0
2012-08-03 10:00:00	QQQ	ETF	65.59	65.75	65.58	65.74	3975435.0
2012-08-03 10:30:00	QQQ	ETF	65.74	65.7501	65.6201	65.68	1386848.0
2012-08-03 11:00:00	QQQ	ETF	65.68	65.83	65.65	65.775	3328384.0
2012-08-03 11:30:00	QQQ	ETF	65.77	65.825	65.75	65.81	2635571.0
2012-08-03 12:00:00	QQQ	ETF	65.81	65.84	65.7	65.79	1462865.0
2012-08-03 12:30:00	QQQ	ETF	65.8	65.815	65.73	65.748	734582.0
2012-08-03 13:00:00	QQQ	ETF	65.7455	65.795	65.73	65.775	737649.0
2012-08-03 13:30:00	QQQ	ETF	65.78	65.8	65.73	65.771	725964.0

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

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