PREVIEW / etf_30min / 2011-04-29

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-29.parquet
  size:    279 KB
  rows:    9,304

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-04-29 04:00:00	SPY	ETF	135.87	135.87	135.77	135.77	3107.0
2011-04-29 04:30:00	SPY	ETF	135.77	135.77	135.77	135.77	335.0
2011-04-29 05:00:00	SPY	ETF	135.84	135.97	135.84	135.97	6200.0
2011-04-29 05:30:00	SPY	ETF	135.96	135.96	135.88	135.89	4100.0
2011-04-29 06:00:00	SPY	ETF	135.95	135.99	135.95	135.99	1100.0
2011-04-29 06:30:00	SPY	ETF	136.01	136.05	136.01	136.05	10200.0
2011-04-29 07:00:00	SPY	ETF	136.05	136.11	135.98	136.0	88000.0
2011-04-29 07:30:00	SPY	ETF	136.06	136.29	136.06	136.22	253861.0
2011-04-29 08:00:00	SPY	ETF	136.22	136.26	136.17	136.23	537996.0
2011-04-29 08:30:00	SPY	ETF	136.24	136.2646	136.1	136.11	438452.0
2011-04-29 09:00:00	SPY	ETF	136.11	136.19	136.1	136.16	612833.0
2011-04-29 09:30:00	SPY	ETF	136.16	136.33	136.02	136.02	14623256.0
2011-04-29 10:00:00	SPY	ETF	136.03	136.22	135.98	136.2	7775534.0
2011-04-29 10:30:00	SPY	ETF	136.1999	136.28	136.12	136.26	6415534.0
2011-04-29 11:00:00	SPY	ETF	136.26	136.29	136.18	136.23	6737676.0
2011-04-29 11:30:00	SPY	ETF	136.23	136.43	136.2	136.33	7329001.0
2011-04-29 12:00:00	SPY	ETF	136.34	136.47	136.33	136.45	5371711.0
2011-04-29 12:30:00	SPY	ETF	136.46	136.5	136.42	136.46	2578449.0
2011-04-29 13:00:00	SPY	ETF	136.46	136.49	136.42	136.44	2595088.0
2011-04-29 13:30:00	SPY	ETF	136.44	136.54	136.37	136.39	4697151.0
2011-04-29 14:00:00	SPY	ETF	136.39	136.44	136.355	136.43	2934027.0
2011-04-29 14:30:00	SPY	ETF	136.43	136.57	136.38	136.39	4436569.0
2011-04-29 15:00:00	SPY	ETF	136.39	136.43	136.23	136.28	6418360.0
2011-04-29 15:30:00	SPY	ETF	136.27	136.49	136.27	136.46	18096194.0
2011-04-29 16:00:00	SPY	ETF	136.46	136.84	136.2	136.6	16124568.0
2011-04-29 16:30:00	SPY	ETF	136.58	136.8	136.53	136.76	2035849.0
2011-04-29 17:00:00	SPY	ETF	136.75	136.75	136.56	136.66	157772.0
2011-04-29 17:30:00	SPY	ETF	136.63	136.78	136.63	136.78	58117.0
2011-04-29 18:00:00	SPY	ETF	136.77	136.78	136.54	136.7	28586.0
2011-04-29 18:30:00	SPY	ETF	136.71	136.74	136.3854	136.74	62650.0
2011-04-29 19:00:00	SPY	ETF	136.75	136.75	136.7	136.71	5300.0
2011-04-29 19:30:00	SPY	ETF	136.71	136.78	136.71	136.78	21024.0
2011-04-29 04:30:00	QQQ	ETF	59.01	59.01	59.01	59.01	100.0
2011-04-29 06:30:00	QQQ	ETF	59.07	59.07	59.07	59.07	198800.0
2011-04-29 07:00:00	QQQ	ETF	59.07	59.07	59.01	59.02	236780.0
2011-04-29 07:30:00	QQQ	ETF	59.02	59.09	59.02	59.06	334000.0
2011-04-29 08:00:00	QQQ	ETF	59.05	59.09	59.04	59.09	1123487.0
2011-04-29 08:30:00	QQQ	ETF	59.06	59.07	59.01	59.01	97000.0
2011-04-29 09:00:00	QQQ	ETF	59.02	59.05	59.01	59.04	155024.0
2011-04-29 09:30:00	QQQ	ETF	59.04	59.22	59.0	59.0	7173609.0
2011-04-29 10:00:00	QQQ	ETF	59.0	59.11	58.98	59.085	2610948.0
2011-04-29 10:30:00	QQQ	ETF	59.085	59.14	59.02	59.115	1320519.0
2011-04-29 11:00:00	QQQ	ETF	59.113	59.16	59.05	59.08	2686489.0
2011-04-29 11:30:00	QQQ	ETF	59.07	59.18	59.06	59.12	2644003.0
2011-04-29 12:00:00	QQQ	ETF	59.127	59.19	59.11	59.17	1339989.0
2011-04-29 12:30:00	QQQ	ETF	59.17	59.21	59.17	59.19	809348.0
2011-04-29 13:00:00	QQQ	ETF	59.19	59.25	59.185	59.22	1331809.0
2011-04-29 13:30:00	QQQ	ETF	59.2265	59.26	59.15	59.16	899913.0
2011-04-29 14:00:00	QQQ	ETF	59.16	59.21	59.13	59.185	1241590.0
2011-04-29 14:30:00	QQQ	ETF	59.185	59.29	59.15	59.16	1561959.0

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

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