PREVIEW / etf_30min / 2011-06-13

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-13.parquet
  size:    285 KB
  rows:    9,408

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
2011-06-13 04:00:00	SPY	ETF	127.6	127.83	127.6	127.83	600.0
2011-06-13 04:30:00	SPY	ETF	127.64	127.64	127.64	127.64	325.0
2011-06-13 05:00:00	SPY	ETF	127.58	127.58	127.58	127.58	100.0
2011-06-13 05:30:00	SPY	ETF	127.48	127.6	127.48	127.6	1000.0
2011-06-13 06:00:00	SPY	ETF	127.68	127.68	127.57	127.68	15058.0
2011-06-13 06:30:00	SPY	ETF	127.71	127.82	127.55	127.78	149600.0
2011-06-13 07:00:00	SPY	ETF	127.78	127.96	127.78	127.92	295137.0
2011-06-13 07:30:00	SPY	ETF	127.9	127.93	127.73	127.78	530195.0
2011-06-13 08:00:00	SPY	ETF	127.76	127.95	127.38	127.91	1425591.0
2011-06-13 08:30:00	SPY	ETF	127.92	128.08	127.89	128.04	1401544.0
2011-06-13 09:00:00	SPY	ETF	128.05	128.08	127.86	127.88	863105.0
2011-06-13 09:30:00	SPY	ETF	127.89	128.22	127.81	128.13	15117800.0
2011-06-13 10:00:00	SPY	ETF	128.12	128.21	127.84	128.14	14045790.0
2011-06-13 10:30:00	SPY	ETF	128.14	128.15	127.77	127.87	9930470.0
2011-06-13 11:00:00	SPY	ETF	127.86	127.99	127.65	127.93	14241635.0
2011-06-13 11:30:00	SPY	ETF	127.92	127.96	127.59	127.64	9656625.0
2011-06-13 12:00:00	SPY	ETF	127.645	127.76	127.42	127.48	10813693.0
2011-06-13 12:30:00	SPY	ETF	127.4881	127.68	127.37	127.42	6259441.0
2011-06-13 13:00:00	SPY	ETF	127.42	127.58	127.05	127.54	15998368.0
2011-06-13 13:30:00	SPY	ETF	127.54	128.03	127.46	128.02	10140229.0
2011-06-13 14:00:00	SPY	ETF	128.01	128.24	127.93	128.02	15991300.0
2011-06-13 14:30:00	SPY	ETF	128.02	128.22	127.79	127.9	12144535.0
2011-06-13 15:00:00	SPY	ETF	127.905	128.11	127.71	127.95	10324600.0
2011-06-13 15:30:00	SPY	ETF	127.95	127.95	127.56	127.69	21013364.0
2011-06-13 16:00:00	SPY	ETF	127.7	128.137	127.59	127.81	5916549.0
2011-06-13 16:30:00	SPY	ETF	127.82	128.0892	127.76	127.8	428711.0
2011-06-13 17:00:00	SPY	ETF	127.8	127.87	127.8	127.83	590621.0
2011-06-13 17:30:00	SPY	ETF	127.86	127.89	127.81	127.87	94917.0
2011-06-13 18:00:00	SPY	ETF	127.86	127.87	127.67	127.83	75030.0
2011-06-13 18:30:00	SPY	ETF	127.84	127.87	127.67	127.84	23014350.0
2011-06-13 19:00:00	SPY	ETF	127.85	127.87	127.82	127.85	9196.0
2011-06-13 19:30:00	SPY	ETF	127.85	127.9	127.84	127.88	21572.0
2011-06-13 04:00:00	QQQ	ETF	55.29	55.29	55.29	55.29	100.0
2011-06-13 06:30:00	QQQ	ETF	54.71	54.71	54.71	54.71	200.0
2011-06-13 07:00:00	QQQ	ETF	54.68	54.77	54.67	54.74	21300.0
2011-06-13 07:30:00	QQQ	ETF	54.74	54.74	54.69	54.7	21100.0
2011-06-13 08:00:00	QQQ	ETF	54.7	54.77	54.63	54.75	99529.0
2011-06-13 08:30:00	QQQ	ETF	54.75	54.82	54.73	54.81	177828.0
2011-06-13 09:00:00	QQQ	ETF	54.81	54.81	54.7	54.71	211489.0
2011-06-13 09:30:00	QQQ	ETF	54.71	54.89	54.63	54.85	4770790.0
2011-06-13 10:00:00	QQQ	ETF	54.84	54.93	54.78	54.92	3013050.0
2011-06-13 10:30:00	QQQ	ETF	54.92	54.92	54.68	54.71	2123847.0
2011-06-13 11:00:00	QQQ	ETF	54.71	54.79	54.63	54.7499	1800152.0
2011-06-13 11:30:00	QQQ	ETF	54.74	54.772	54.59	54.62	1193982.0
2011-06-13 12:00:00	QQQ	ETF	54.63	54.68	54.55	54.57	2247914.0
2011-06-13 12:30:00	QQQ	ETF	54.57	54.65	54.56	54.59	1297648.0
2011-06-13 13:00:00	QQQ	ETF	54.595	54.65	54.45	54.615	3022191.0
2011-06-13 13:30:00	QQQ	ETF	54.62	54.84	54.6	54.83	2099155.0
2011-06-13 14:00:00	QQQ	ETF	54.83	54.9	54.79	54.83	2071527.0
2011-06-13 14:30:00	QQQ	ETF	54.8218	54.895	54.72	54.77	1963851.0

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

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