PREVIEW / etf_1hour / 2011-06-16

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-16.parquet
  size:    183 KB
  rows:    5,609

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-16 04:00:00	SPY	ETF	127.0	127.46	127.0	127.35	17552.0
2011-06-16 05:00:00	SPY	ETF	127.1	127.12	126.76	126.95	13300.0
2011-06-16 06:00:00	SPY	ETF	126.92	127.08	126.82	127.04	48755.0
2011-06-16 07:00:00	SPY	ETF	127.01	127.15	126.48	126.5	871093.0
2011-06-16 08:00:00	SPY	ETF	126.48	127.25	126.44	127.21	5062874.0
2011-06-16 09:00:00	SPY	ETF	127.2	127.54	126.91	127.27	31807695.0
2011-06-16 10:00:00	SPY	ETF	127.29	127.87	126.67	127.65	59695644.0
2011-06-16 11:00:00	SPY	ETF	127.641	127.97	127.3	127.61	38283567.0
2011-06-16 12:00:00	SPY	ETF	127.61	127.86	127.56	127.56	15620817.0
2011-06-16 13:00:00	SPY	ETF	127.57	127.71	126.85	126.86	30521321.0
2011-06-16 14:00:00	SPY	ETF	126.86	127.0757	126.32	126.73	36008029.0
2011-06-16 15:00:00	SPY	ETF	126.72	127.39	126.66	127.3	53154192.0
2011-06-16 16:00:00	SPY	ETF	127.31	127.6	126.46	127.55	26498599.0
2011-06-16 17:00:00	SPY	ETF	127.57	127.57	126.7647	127.51	284943.0
2011-06-16 18:00:00	SPY	ETF	127.52	127.79	127.28	127.77	174365.0
2011-06-16 19:00:00	SPY	ETF	127.75	127.88	127.72	127.83	145287.0
2011-06-16 05:00:00	QQQ	ETF	54.15	54.15	54.15	54.15	100.0
2011-06-16 06:00:00	QQQ	ETF	54.18	54.3	54.18	54.3	2240.0
2011-06-16 07:00:00	QQQ	ETF	54.27	54.27	54.09	54.12	108586.0
2011-06-16 08:00:00	QQQ	ETF	54.1	54.41	54.07	54.38	445089.0
2011-06-16 09:00:00	QQQ	ETF	54.37	54.41	54.22	54.33	5924277.0
2011-06-16 10:00:00	QQQ	ETF	54.32	54.5	54.13	54.395	9514863.0
2011-06-16 11:00:00	QQQ	ETF	54.39	54.5	54.27	54.35	6552092.0
2011-06-16 12:00:00	QQQ	ETF	54.35	54.4199	54.33	54.35	2515026.0
2011-06-16 13:00:00	QQQ	ETF	54.3473	54.3889	54.07	54.08	5656221.0
2011-06-16 14:00:00	QQQ	ETF	54.08	54.13	53.615	53.795	9555524.0
2011-06-16 15:00:00	QQQ	ETF	53.8	54.13	53.78	54.08	10337268.0
2011-06-16 16:00:00	QQQ	ETF	54.07	54.18	53.91	54.13	2963208.0
2011-06-16 17:00:00	QQQ	ETF	54.13	54.15	54.1	54.14	214648.0
2011-06-16 18:00:00	QQQ	ETF	54.14	54.22	54.08	54.21	95027.0
2011-06-16 19:00:00	QQQ	ETF	54.21	54.27	54.21	54.26	43866.0
2011-06-16 04:00:00	IWM	ETF	78.11	78.22	78.11	78.22	300.0
2011-06-16 05:00:00	IWM	ETF	78.02	78.02	77.78	77.96	3100.0
2011-06-16 06:00:00	IWM	ETF	77.89	78.0	77.89	78.0	5000.0
2011-06-16 07:00:00	IWM	ETF	78.1	78.1	77.59	77.59	34163.0
2011-06-16 08:00:00	IWM	ETF	77.64	78.23	77.6	78.22	1377724.0
2011-06-16 09:00:00	IWM	ETF	78.21	78.41	77.87	78.1	8264671.0
2011-06-16 10:00:00	IWM	ETF	78.08	78.87	77.68	78.6201	17724766.0
2011-06-16 11:00:00	IWM	ETF	78.62	78.84	78.35	78.65	7530993.0
2011-06-16 12:00:00	IWM	ETF	78.66	78.88	78.64	78.68	3367471.0
2011-06-16 13:00:00	IWM	ETF	78.6799	78.6799	77.8	77.82	8736320.0
2011-06-16 14:00:00	IWM	ETF	77.82	77.93	77.23	77.615	10800746.0
2011-06-16 15:00:00	IWM	ETF	77.62	78.27	77.5	78.24	16716765.0
2011-06-16 16:00:00	IWM	ETF	78.25	78.55	78.17	78.4	1718119.0
2011-06-16 17:00:00	IWM	ETF	78.34	78.36	78.31	78.35	17368.0
2011-06-16 18:00:00	IWM	ETF	78.35	78.46	78.35	78.46	12785.0
2011-06-16 19:00:00	IWM	ETF	78.46	78.56	78.42	78.56	18723.0
2011-06-16 05:00:00	DIA	ETF	118.76	118.76	118.66	118.66	300.0
2011-06-16 06:00:00	DIA	ETF	118.78	118.85	118.78	118.85	1000.0
2011-06-16 07:00:00	DIA	ETF	118.84	118.85	118.45	118.45	6825.0

> showing 50 of 5,609 rows — these rows as CSV

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