PREVIEW / etf_30min / 2011-11-22

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-11-22.parquet
  size:    282 KB
  rows:    9,504

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-11-22 04:00:00	SPY	ETF	120.07	120.12	119.74	119.74	609.0
2011-11-22 04:30:00	SPY	ETF	119.78	119.78	119.7	119.7	2075.0
2011-11-22 05:00:00	SPY	ETF	119.99	119.99	119.99	119.99	100.0
2011-11-22 05:30:00	SPY	ETF	120.14	120.15	120.14	120.15	10000.0
2011-11-22 06:00:00	SPY	ETF	120.15	120.42	120.15	120.3	31670.0
2011-11-22 06:30:00	SPY	ETF	120.3	120.47	120.27	120.3	58474.0
2011-11-22 07:00:00	SPY	ETF	120.29	120.4	120.09	120.09	148585.0
2011-11-22 07:30:00	SPY	ETF	120.15	120.16	119.7	119.93	273537.0
2011-11-22 08:00:00	SPY	ETF	119.9	120.44	119.36	119.59	944528.0
2011-11-22 08:30:00	SPY	ETF	119.53	119.85	118.99	119.3	2308424.0
2011-11-22 09:00:00	SPY	ETF	119.3	119.5	119.21	119.38	1753468.0
2011-11-22 09:30:00	SPY	ETF	119.4	120.03	119.165	119.75	22156067.0
2011-11-22 10:00:00	SPY	ETF	119.76	119.9	119.3	119.78	17937827.0
2011-11-22 10:30:00	SPY	ETF	119.77	119.81	118.75	118.92	17736209.0
2011-11-22 11:00:00	SPY	ETF	118.92	119.12	118.66	118.83	17292464.0
2011-11-22 11:30:00	SPY	ETF	118.83	118.97	118.52	118.89	15963560.0
2011-11-22 12:00:00	SPY	ETF	118.9	119.83	118.89	119.27	26728963.0
2011-11-22 12:30:00	SPY	ETF	119.2694	119.73	119.19	119.725	9408340.0
2011-11-22 13:00:00	SPY	ETF	119.73	120.1	119.51	119.79	13386514.0
2011-11-22 13:30:00	SPY	ETF	119.8	119.99	119.46	119.53	7787332.0
2011-11-22 14:00:00	SPY	ETF	119.52	119.68	119.28	119.43	7397643.0
2011-11-22 14:30:00	SPY	ETF	119.43	119.5	119.01	119.16	10358894.0
2011-11-22 15:00:00	SPY	ETF	119.16	119.42	118.99	119.28	12139967.0
2011-11-22 15:30:00	SPY	ETF	119.29	119.47	119.07	119.17	20537555.0
2011-11-22 16:00:00	SPY	ETF	119.18	119.6802	118.59	118.83	10545250.0
2011-11-22 16:30:00	SPY	ETF	118.84	119.1846	118.1846	118.86	595668.0
2011-11-22 17:00:00	SPY	ETF	118.86	118.9	118.83	118.9	50618.0
2011-11-22 17:30:00	SPY	ETF	118.88	118.91	118.85	118.9	41951.0
2011-11-22 18:00:00	SPY	ETF	118.91	118.93	118.71	118.87	94311.0
2011-11-22 18:30:00	SPY	ETF	118.9	119.06	118.85	119.01	97903.0
2011-11-22 19:00:00	SPY	ETF	119.02	119.19	118.81	118.82	165026.0
2011-11-22 19:30:00	SPY	ETF	118.84	118.87	118.7	118.79	163588.0
2011-11-22 04:00:00	QQQ	ETF	54.39	54.39	54.24	54.27	2177.0
2011-11-22 04:30:00	QQQ	ETF	54.19	54.19	54.19	54.19	500.0
2011-11-22 06:00:00	QQQ	ETF	54.45	54.53	54.45	54.53	2700.0
2011-11-22 06:30:00	QQQ	ETF	54.48	54.5	54.48	54.5	27900.0
2011-11-22 07:00:00	QQQ	ETF	54.49	54.5	54.41	54.41	26550.0
2011-11-22 07:30:00	QQQ	ETF	54.42	54.43	54.26	54.35	103744.0
2011-11-22 08:00:00	QQQ	ETF	54.35	54.37	54.13	54.2	338585.0
2011-11-22 08:30:00	QQQ	ETF	54.11	54.19	54.0	54.14	646071.0
2011-11-22 09:00:00	QQQ	ETF	54.14	54.28	54.1	54.19	167357.0
2011-11-22 09:30:00	QQQ	ETF	54.19	54.59	54.145	54.47	5172011.0
2011-11-22 10:00:00	QQQ	ETF	54.47	54.54	54.27	54.5	3867280.0
2011-11-22 10:30:00	QQQ	ETF	54.49	54.51	53.95	54.03	5601869.0
2011-11-22 11:00:00	QQQ	ETF	54.03	54.17	53.975	54.08	3567226.0
2011-11-22 11:30:00	QQQ	ETF	54.08	54.1786	53.87	54.16	3397225.0
2011-11-22 12:00:00	QQQ	ETF	54.17	54.5	54.16	54.252	5759804.0
2011-11-22 12:30:00	QQQ	ETF	54.26	54.51	54.234	54.51	2203523.0
2011-11-22 13:00:00	QQQ	ETF	54.51	54.68	54.41	54.56	2249873.0
2011-11-22 13:30:00	QQQ	ETF	54.56	54.6591	54.47	54.519	1242426.0

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

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