PREVIEW / etf_1hour / 2012-01-11

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-11.parquet
  size:    180 KB
  rows:    5,638

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
2012-01-11 04:00:00	SPY	ETF	129.17	129.22	129.17	129.22	1800.0
2012-01-11 05:00:00	SPY	ETF	129.1	129.1	129.07	129.07	1400.0
2012-01-11 06:00:00	SPY	ETF	129.07	129.07	128.61	128.65	95050.0
2012-01-11 07:00:00	SPY	ETF	128.62	128.95	128.36	128.78	556163.0
2012-01-11 08:00:00	SPY	ETF	128.8	128.86	128.5	128.73	1659866.0
2012-01-11 09:00:00	SPY	ETF	128.73	129.05	128.57	128.64	16494376.0
2012-01-11 10:00:00	SPY	ETF	128.63	129.13	128.52	128.781	19786360.0
2012-01-11 11:00:00	SPY	ETF	128.79	129.03	128.66	128.86	13484902.0
2012-01-11 12:00:00	SPY	ETF	128.86	129.05	128.76	128.97	8169466.0
2012-01-11 13:00:00	SPY	ETF	128.97	129.23	128.95	129.03	10242317.0
2012-01-11 14:00:00	SPY	ETF	129.03	129.16	128.85	129.021	14410288.0
2012-01-11 15:00:00	SPY	ETF	129.02	129.37	129.0	129.24	21107807.0
2012-01-11 16:00:00	SPY	ETF	129.25	129.32	129.2	129.25	2646807.0
2012-01-11 17:00:00	SPY	ETF	129.24	129.27	129.12	129.25	316615.0
2012-01-11 18:00:00	SPY	ETF	129.26	129.3	129.2	129.22	77241.0
2012-01-11 19:00:00	SPY	ETF	129.2	129.2	129.12	129.15	246003.0
2012-01-11 06:00:00	QQQ	ETF	57.9	57.9	57.86	57.87	7400.0
2012-01-11 07:00:00	QQQ	ETF	57.87	58.0	57.79	57.97	101528.0
2012-01-11 08:00:00	QQQ	ETF	57.94	58.0	57.83	57.97	393820.0
2012-01-11 09:00:00	QQQ	ETF	57.97	58.175	57.87	57.88	5051326.0
2012-01-11 10:00:00	QQQ	ETF	57.88	58.2249	57.81	58.1	6506551.0
2012-01-11 11:00:00	QQQ	ETF	58.1	58.22	58.01	58.1129	3346700.0
2012-01-11 12:00:00	QQQ	ETF	58.12	58.17	58.05	58.1	3684864.0
2012-01-11 13:00:00	QQQ	ETF	58.11	58.24	58.05	58.0717	3498461.0
2012-01-11 14:00:00	QQQ	ETF	58.08	58.225	58.08	58.18	3296180.0
2012-01-11 15:00:00	QQQ	ETF	58.18	58.29	58.16	58.16	4233183.0
2012-01-11 16:00:00	QQQ	ETF	58.16	58.17	58.11	58.15	650932.0
2012-01-11 17:00:00	QQQ	ETF	58.13	58.1699	58.11	58.13	47208.0
2012-01-11 18:00:00	QQQ	ETF	58.14	58.16	58.13	58.14	17186.0
2012-01-11 19:00:00	QQQ	ETF	58.14	58.14	58.1	58.12	60998.0
2012-01-11 06:00:00	IWM	ETF	76.0	76.0	76.0	76.0	700.0
2012-01-11 07:00:00	IWM	ETF	75.92	76.12	75.73	76.01	170644.0
2012-01-11 08:00:00	IWM	ETF	76.01	76.06	75.83	75.98	231635.0
2012-01-11 09:00:00	IWM	ETF	75.97	76.29	75.87	75.99	3232964.0
2012-01-11 10:00:00	IWM	ETF	75.9898	76.29	75.87	76.07	4042048.0
2012-01-11 11:00:00	IWM	ETF	76.07	76.42	76.01	76.24	3934690.0
2012-01-11 12:00:00	IWM	ETF	76.25	76.46	76.2	76.37	3200220.0
2012-01-11 13:00:00	IWM	ETF	76.37	76.56	76.32	76.405	3100372.0
2012-01-11 14:00:00	IWM	ETF	76.4098	76.51	76.275	76.42	4200653.0
2012-01-11 15:00:00	IWM	ETF	76.42	76.67	76.41	76.56	6223440.0
2012-01-11 16:00:00	IWM	ETF	76.57	76.61	75.9	76.56	2833742.0
2012-01-11 17:00:00	IWM	ETF	76.57	76.62	76.55	76.62	45295.0
2012-01-11 18:00:00	IWM	ETF	76.6	76.6	76.57	76.57	4790.0
2012-01-11 19:00:00	IWM	ETF	76.59	76.59	76.55	76.55	5967.0
2012-01-11 07:00:00	DIA	ETF	124.2	124.2	124.2	124.2	750.0
2012-01-11 08:00:00	DIA	ETF	124.1	124.12	123.94	124.07	14820.0
2012-01-11 09:00:00	DIA	ETF	124.08	124.21	123.85	123.8701	730047.0
2012-01-11 10:00:00	DIA	ETF	123.89	124.32	123.8	124.03	979333.0
2012-01-11 11:00:00	DIA	ETF	124.03	124.15	123.8423	124.0	537982.0
2012-01-11 12:00:00	DIA	ETF	124.01	124.14	123.94	124.04	438024.0

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

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