PREVIEW / etf_30min / 2011-06-22

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-22.parquet
  size:    281 KB
  rows:    9,398

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-22 04:00:00	SPY	ETF	129.25	129.25	128.91	129.09	1700.0
2011-06-22 04:30:00	SPY	ETF	129.02	129.02	129.0	129.0	500.0
2011-06-22 05:00:00	SPY	ETF	129.01	129.01	128.88	128.88	1100.0
2011-06-22 05:30:00	SPY	ETF	128.87	128.87	128.69	128.77	30400.0
2011-06-22 06:00:00	SPY	ETF	128.79	128.84	128.68	128.82	5700.0
2011-06-22 06:30:00	SPY	ETF	128.82	128.92	128.73	128.78	30600.0
2011-06-22 07:00:00	SPY	ETF	128.78	128.94	128.75	128.88	285660.0
2011-06-22 07:30:00	SPY	ETF	128.89	129.16	128.79	129.16	931476.0
2011-06-22 08:00:00	SPY	ETF	129.16	129.22	128.74	129.01	877631.0
2011-06-22 08:30:00	SPY	ETF	129.0	129.03	128.77	128.89	1252832.0
2011-06-22 09:00:00	SPY	ETF	128.9	129.45	128.9	129.04	1279515.0
2011-06-22 09:30:00	SPY	ETF	129.05	129.55	128.92	129.49	18299980.0
2011-06-22 10:00:00	SPY	ETF	129.49	129.59	129.15	129.38	13766748.0
2011-06-22 10:30:00	SPY	ETF	129.38	129.81	129.36	129.74	12942222.0
2011-06-22 11:00:00	SPY	ETF	129.73	129.75	129.56	129.65	7632275.0
2011-06-22 11:30:00	SPY	ETF	129.65	129.69	129.48	129.48	7672290.0
2011-06-22 12:00:00	SPY	ETF	129.48	129.61	129.34	129.5271	6735829.0
2011-06-22 12:30:00	SPY	ETF	129.52	129.715	129.21	129.66	9917244.0
2011-06-22 13:00:00	SPY	ETF	129.66	129.67	129.5	129.5885	3388227.0
2011-06-22 13:30:00	SPY	ETF	129.59	129.7	129.55	129.7	4157616.0
2011-06-22 14:00:00	SPY	ETF	129.69	129.77	129.43	129.53	12373341.0
2011-06-22 14:30:00	SPY	ETF	129.53	129.55	129.11	129.16	15409725.0
2011-06-22 15:00:00	SPY	ETF	129.165	129.37	129.11	129.17	11767668.0
2011-06-22 15:30:00	SPY	ETF	129.18	129.19	128.59	128.67	33430313.0
2011-06-22 16:00:00	SPY	ETF	128.68	129.4738	128.41	128.47	8625066.0
2011-06-22 16:30:00	SPY	ETF	128.45	129.4738	128.35	128.42	3011649.0
2011-06-22 17:00:00	SPY	ETF	128.41	128.46	128.29	128.31	195406.0
2011-06-22 17:30:00	SPY	ETF	128.34	128.4	128.34	128.38	19630.0
2011-06-22 18:00:00	SPY	ETF	128.39	128.7	128.07	128.11	305534.0
2011-06-22 18:30:00	SPY	ETF	128.08	128.16	128.0	128.05	270082.0
2011-06-22 19:00:00	SPY	ETF	128.06	128.06	127.93	128.0	110935.0
2011-06-22 19:30:00	SPY	ETF	128.0	128.09	127.99	128.05	78452.0
2011-06-22 04:00:00	QQQ	ETF	55.0	55.0	55.0	55.0	261.0
2011-06-22 04:30:00	QQQ	ETF	55.02	55.05	55.02	55.05	200.0
2011-06-22 05:00:00	QQQ	ETF	55.05	55.05	54.96	55.0	1600.0
2011-06-22 05:30:00	QQQ	ETF	54.95	54.95	54.93	54.93	400.0
2011-06-22 06:00:00	QQQ	ETF	54.94	54.97	54.94	54.97	2650.0
2011-06-22 07:00:00	QQQ	ETF	54.91	54.99	54.91	54.97	39200.0
2011-06-22 07:30:00	QQQ	ETF	54.98	55.07	54.96	55.07	5200.0
2011-06-22 08:00:00	QQQ	ETF	55.07	55.1	55.01	55.02	140962.0
2011-06-22 08:30:00	QQQ	ETF	55.02	55.05	54.94	55.02	280065.0
2011-06-22 09:00:00	QQQ	ETF	55.03	55.1	54.97	54.99	224942.0
2011-06-22 09:30:00	QQQ	ETF	54.99	55.22	54.97	55.1862	4807336.0
2011-06-22 10:00:00	QQQ	ETF	55.18	55.19	55.06	55.158	2813131.0
2011-06-22 10:30:00	QQQ	ETF	55.16	55.29	55.12	55.23	2137636.0
2011-06-22 11:00:00	QQQ	ETF	55.23	55.26	55.19	55.21	1603231.0
2011-06-22 11:30:00	QQQ	ETF	55.21	55.23	55.14	55.15	1308282.0
2011-06-22 12:00:00	QQQ	ETF	55.15	55.22	55.11	55.18	1821026.0
2011-06-22 12:30:00	QQQ	ETF	55.181	55.28	55.08	55.25	2083841.0
2011-06-22 13:00:00	QQQ	ETF	55.25	55.25	55.18	55.2262	661072.0

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

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