PREVIEW / etf_30min / 2011-01-10

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-10.parquet
  size:    269 KB
  rows:    8,977

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-01-10 04:00:00	SPY	ETF	126.5	126.65	126.49	126.63	2660.0
2011-01-10 05:00:00	SPY	ETF	126.51	126.51	126.42	126.42	14150.0
2011-01-10 05:30:00	SPY	ETF	126.4	126.49	126.23	126.48	40055.0
2011-01-10 06:00:00	SPY	ETF	126.48	126.56	126.44	126.56	15100.0
2011-01-10 06:30:00	SPY	ETF	126.59	126.59	126.38	126.54	68300.0
2011-01-10 07:00:00	SPY	ETF	126.55	126.62	126.53	126.6	251536.0
2011-01-10 07:30:00	SPY	ETF	126.6	126.61	126.41	126.49	369443.0
2011-01-10 08:00:00	SPY	ETF	126.49	126.61	126.4	126.6	427158.0
2011-01-10 08:30:00	SPY	ETF	126.59	126.68	126.5	126.59	526029.0
2011-01-10 09:00:00	SPY	ETF	126.6	126.7	126.54	126.59	623305.0
2011-01-10 09:30:00	SPY	ETF	126.58	126.81	126.2	126.25	15781103.0
2011-01-10 10:00:00	SPY	ETF	126.25	126.64	126.2	126.6	14015083.0
2011-01-10 10:30:00	SPY	ETF	126.6	126.89	126.46	126.55	11188905.0
2011-01-10 11:00:00	SPY	ETF	126.55	126.6565	126.37	126.61	7456956.0
2011-01-10 11:30:00	SPY	ETF	126.6	126.83	126.48	126.8	8614345.0
2011-01-10 12:00:00	SPY	ETF	126.8	126.89	126.61	126.82	9245186.0
2011-01-10 12:30:00	SPY	ETF	126.83	126.92	126.73	126.79	5421232.0
2011-01-10 13:00:00	SPY	ETF	126.785	126.97	126.78	126.92	4346520.0
2011-01-10 13:30:00	SPY	ETF	126.93	127.0	126.89	126.91	4808008.0
2011-01-10 14:00:00	SPY	ETF	126.91	126.95	126.73	126.93	5505091.0
2011-01-10 14:30:00	SPY	ETF	126.922	127.05	126.88	127.02	4944898.0
2011-01-10 15:00:00	SPY	ETF	127.02	127.16	126.92	127.13	6633103.0
2011-01-10 15:30:00	SPY	ETF	127.13	127.16	126.97	126.98	10791435.0
2011-01-10 16:00:00	SPY	ETF	127.01	127.15	126.342	126.95	9001940.0
2011-01-10 16:30:00	SPY	ETF	126.94	126.96	126.8481	126.91	490617.0
2011-01-10 17:00:00	SPY	ETF	126.88	126.95	126.87	126.95	226736.0
2011-01-10 17:30:00	SPY	ETF	126.91	126.96	126.9	126.94	12908.0
2011-01-10 18:00:00	SPY	ETF	126.94	127.01	126.9	126.91	31386.0
2011-01-10 18:30:00	SPY	ETF	126.93	127.02	126.89	127.02	66278.0
2011-01-10 19:00:00	SPY	ETF	127.02	127.06	126.98	126.98	48313.0
2011-01-10 19:30:00	SPY	ETF	126.97	126.97	126.85	126.86	57369.0
2011-01-10 04:00:00	QQQ	ETF	55.64	55.64	55.64	55.64	200.0
2011-01-10 05:30:00	QQQ	ETF	55.57	55.58	55.56	55.58	400.0
2011-01-10 06:00:00	QQQ	ETF	55.61	55.67	55.6	55.67	43000.0
2011-01-10 06:30:00	QQQ	ETF	55.64	55.64	55.59	55.59	1200.0
2011-01-10 07:00:00	QQQ	ETF	55.63	55.68	55.62	55.67	33607.0
2011-01-10 07:30:00	QQQ	ETF	55.68	55.68	55.62	55.63	25556.0
2011-01-10 08:00:00	QQQ	ETF	55.63	55.71	55.6	55.71	176314.0
2011-01-10 08:30:00	QQQ	ETF	55.7	55.87	55.67	55.7	133808.0
2011-01-10 09:00:00	QQQ	ETF	55.71	55.76	55.7	55.72	143818.0
2011-01-10 09:30:00	QQQ	ETF	55.72	55.89	55.6	55.65	9544967.0
2011-01-10 10:00:00	QQQ	ETF	55.64	55.865	55.58	55.79	8259761.0
2011-01-10 10:30:00	QQQ	ETF	55.79	55.89	55.7	55.74	3767052.0
2011-01-10 11:00:00	QQQ	ETF	55.7436	55.79	55.7	55.76	2575147.0
2011-01-10 11:30:00	QQQ	ETF	55.75	55.9	55.73	55.9	2499864.0
2011-01-10 12:00:00	QQQ	ETF	55.8919	55.95	55.8	55.89	3575105.0
2011-01-10 12:30:00	QQQ	ETF	55.9	55.94	55.85	55.87	2778542.0
2011-01-10 13:00:00	QQQ	ETF	55.86	56.0	55.86	55.9799	1616098.0
2011-01-10 13:30:00	QQQ	ETF	55.98	56.06	55.97	56.0	1833524.0
2011-01-10 14:00:00	QQQ	ETF	56.0	56.02	55.94	56.01	1734924.0

> showing 50 of 8,977 rows — these rows as CSV

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