PREVIEW / etf_30min / 2011-11-08

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-11-08.parquet
  size:    283 KB
  rows:    9,451

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-08 04:00:00	SPY	ETF	126.2	126.9	126.2	126.9	1575.0
2011-11-08 04:30:00	SPY	ETF	126.78	126.81	126.49	126.52	108720.0
2011-11-08 05:00:00	SPY	ETF	126.48	126.7	126.46	126.7	11880.0
2011-11-08 05:30:00	SPY	ETF	126.65	126.75	126.6	126.6	5500.0
2011-11-08 06:00:00	SPY	ETF	126.67	126.67	126.46	126.6	14200.0
2011-11-08 06:30:00	SPY	ETF	126.63	126.87	126.63	126.74	45480.0
2011-11-08 07:00:00	SPY	ETF	126.82	126.88	126.61	126.86	254789.0
2011-11-08 07:30:00	SPY	ETF	126.83	127.26	126.82	127.2	596486.0
2011-11-08 08:00:00	SPY	ETF	127.2	127.27	127.03	127.03	1329801.0
2011-11-08 08:30:00	SPY	ETF	127.03	127.09	126.9	127.0	443766.0
2011-11-08 09:00:00	SPY	ETF	127.0	127.22	126.84	126.92	1325158.0
2011-11-08 09:30:00	SPY	ETF	126.92	127.35	126.66	127.34	17919877.0
2011-11-08 10:00:00	SPY	ETF	127.33	127.39	126.17	126.37	26210623.0
2011-11-08 10:30:00	SPY	ETF	126.38	126.75	126.24	126.47	16839709.0
2011-11-08 11:00:00	SPY	ETF	126.46	126.6	125.71	125.98	15166712.0
2011-11-08 11:30:00	SPY	ETF	125.98	126.2	125.79	126.0699	10322885.0
2011-11-08 12:00:00	SPY	ETF	126.06	126.43	125.86	126.26	7260534.0
2011-11-08 12:30:00	SPY	ETF	126.27	126.48	126.07	126.23	7975386.0
2011-11-08 13:00:00	SPY	ETF	126.23	126.51	126.0	126.44	8328725.0
2011-11-08 13:30:00	SPY	ETF	126.45	127.31	126.38	127.11	20113115.0
2011-11-08 14:00:00	SPY	ETF	127.11	127.49	126.86	127.48	15127918.0
2011-11-08 14:30:00	SPY	ETF	127.48	127.6	127.33	127.489	13060395.0
2011-11-08 15:00:00	SPY	ETF	127.49	127.71	127.2	127.68	15670957.0
2011-11-08 15:30:00	SPY	ETF	127.69	128.02	127.64	127.87	26909319.0
2011-11-08 16:00:00	SPY	ETF	127.88	128.06	126.02	127.87	13947162.0
2011-11-08 16:30:00	SPY	ETF	127.86	127.93	127.84	127.88	2294595.0
2011-11-08 17:00:00	SPY	ETF	127.88	127.92	127.83	127.88	131815.0
2011-11-08 17:30:00	SPY	ETF	127.88	127.88	126.3548	127.85	289003.0
2011-11-08 18:00:00	SPY	ETF	127.84	127.86	127.7	127.79	235827.0
2011-11-08 18:30:00	SPY	ETF	127.77	127.83	127.75	127.83	28390.0
2011-11-08 19:00:00	SPY	ETF	127.81	127.82	127.72	127.75	29220.0
2011-11-08 19:30:00	SPY	ETF	127.73	127.84	127.72	127.84	49617.0
2011-11-08 04:00:00	QQQ	ETF	58.53	58.53	58.53	58.53	200.0
2011-11-08 05:30:00	QQQ	ETF	58.59	58.59	58.59	58.59	400.0
2011-11-08 06:00:00	QQQ	ETF	58.57	58.57	58.56	58.56	1500.0
2011-11-08 06:30:00	QQQ	ETF	58.56	58.63	58.56	58.59	3600.0
2011-11-08 07:00:00	QQQ	ETF	58.5	58.66	58.5	58.65	13270.0
2011-11-08 07:30:00	QQQ	ETF	58.65	58.84	58.63	58.82	27998.0
2011-11-08 08:00:00	QQQ	ETF	58.82	58.87	58.73	58.73	1128243.0
2011-11-08 08:30:00	QQQ	ETF	58.73	58.75	58.67	58.72	216470.0
2011-11-08 09:00:00	QQQ	ETF	58.72	58.77	58.62	58.63	413667.0
2011-11-08 09:30:00	QQQ	ETF	58.62	58.85	58.54	58.84	5994994.0
2011-11-08 10:00:00	QQQ	ETF	58.8401	58.86	58.3207	58.3984	6931402.0
2011-11-08 10:30:00	QQQ	ETF	58.39	58.524	58.27	58.37	4082997.0
2011-11-08 11:00:00	QQQ	ETF	58.35	58.43	57.97	58.15	3495285.0
2011-11-08 11:30:00	QQQ	ETF	58.14	58.284	58.09	58.23	2935107.0
2011-11-08 12:00:00	QQQ	ETF	58.23	58.37	58.16	58.2998	2464818.0
2011-11-08 12:30:00	QQQ	ETF	58.295	58.39	58.22	58.2637	2561343.0
2011-11-08 13:00:00	QQQ	ETF	58.26	58.41	58.17	58.4	2149495.0
2011-11-08 13:30:00	QQQ	ETF	58.3999	58.75	58.36	58.6999	4058987.0

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

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