PREVIEW / etf_1hour / 2010-09-21

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-21.parquet
  size:    169 KB
  rows:    5,134

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
2010-09-21 04:00:00	SPY	ETF	114.0	114.1	113.98	114.0	9500.0
2010-09-21 05:00:00	SPY	ETF	114.07	114.25	114.07	114.11	984.0
2010-09-21 06:00:00	SPY	ETF	114.01	114.06	113.96	114.06	13150.0
2010-09-21 07:00:00	SPY	ETF	114.06	114.21	114.01	114.12	287920.0
2010-09-21 08:00:00	SPY	ETF	114.15	114.37	113.76	114.29	3118282.0
2010-09-21 09:00:00	SPY	ETF	114.29	114.42	114.01	114.1	21190073.0
2010-09-21 10:00:00	SPY	ETF	114.1	114.26	114.02	114.08	21273991.0
2010-09-21 11:00:00	SPY	ETF	114.09	114.19	113.83	113.95	18006726.0
2010-09-21 12:00:00	SPY	ETF	113.95	114.04	113.83	113.96	7531055.0
2010-09-21 13:00:00	SPY	ETF	113.96	113.96	113.71	113.86	12217340.0
2010-09-21 14:00:00	SPY	ETF	113.85	114.84	113.51	114.43	74426223.0
2010-09-21 15:00:00	SPY	ETF	114.43	114.5665	113.6	114.0	84362062.0
2010-09-21 16:00:00	SPY	ETF	113.98	114.815	113.555	113.85	17483956.0
2010-09-21 17:00:00	SPY	ETF	113.86	114.2323	113.75	113.82	4167669.0
2010-09-21 18:00:00	SPY	ETF	113.8	114.0	113.77	113.87	117624.0
2010-09-21 19:00:00	SPY	ETF	113.88	113.98	113.8	113.87	151245.0
2010-09-21 05:00:00	QQQ	ETF	48.81	48.81	48.81	48.81	100.0
2010-09-21 06:00:00	QQQ	ETF	48.74	48.78	48.74	48.78	57652.0
2010-09-21 07:00:00	QQQ	ETF	48.79	48.82	48.76	48.81	28252.0
2010-09-21 08:00:00	QQQ	ETF	48.8	48.85	48.63	48.82	1054767.0
2010-09-21 09:00:00	QQQ	ETF	48.83	48.89	48.69	48.77	7639324.0
2010-09-21 10:00:00	QQQ	ETF	48.77	48.91	48.75	48.8	9485825.0
2010-09-21 11:00:00	QQQ	ETF	48.79	48.86	48.71	48.77	5387113.0
2010-09-21 12:00:00	QQQ	ETF	48.76	48.83	48.73	48.82	2936803.0
2010-09-21 13:00:00	QQQ	ETF	48.82	48.82	48.71	48.79	3865708.0
2010-09-21 14:00:00	QQQ	ETF	48.79	49.17	48.66	48.97	24572352.0
2010-09-21 15:00:00	QQQ	ETF	48.97	48.99	48.61	48.8	23443773.0
2010-09-21 16:00:00	QQQ	ETF	48.8	48.85	48.74	48.76	1796800.0
2010-09-21 17:00:00	QQQ	ETF	48.75	48.76	48.71	48.71	102722.0
2010-09-21 18:00:00	QQQ	ETF	48.71	48.76	48.7	48.72	129980.0
2010-09-21 19:00:00	QQQ	ETF	48.74	48.75	48.72	48.73	18849.0
2010-09-21 04:00:00	IWM	ETF	66.87	66.87	66.87	66.87	118.0
2010-09-21 05:00:00	IWM	ETF	67.02	67.09	67.02	67.09	236.0
2010-09-21 07:00:00	IWM	ETF	66.94	67.02	66.92	66.98	5000.0
2010-09-21 08:00:00	IWM	ETF	67.04	67.2	66.64	67.11	367766.0
2010-09-21 09:00:00	IWM	ETF	67.13	67.19	66.69	66.78	5550490.0
2010-09-21 10:00:00	IWM	ETF	66.77	67.11	66.67	66.88	6649117.0
2010-09-21 11:00:00	IWM	ETF	66.87	67.06	66.69	66.8	4883350.0
2010-09-21 12:00:00	IWM	ETF	66.8	66.93	66.71	66.84	3688409.0
2010-09-21 13:00:00	IWM	ETF	66.84	66.85	66.57	66.78	4779274.0
2010-09-21 14:00:00	IWM	ETF	66.78	67.43	66.56	67.15	17110445.0
2010-09-21 15:00:00	IWM	ETF	67.14	67.19	66.53	66.65	13625828.0
2010-09-21 16:00:00	IWM	ETF	66.66	67.1134	66.56	66.62	2459578.0
2010-09-21 17:00:00	IWM	ETF	66.59	67.1133	66.53	66.765	1320600.0
2010-09-21 18:00:00	IWM	ETF	66.51	66.58	66.5	66.54	5903.0
2010-09-21 19:00:00	IWM	ETF	66.53	66.53	66.5	66.51	1150.0
2010-09-21 07:00:00	DIA	ETF	107.47	107.53	107.47	107.53	5100.0
2010-09-21 08:00:00	DIA	ETF	107.48	107.65	107.33	107.59	21400.0
2010-09-21 09:00:00	DIA	ETF	107.66	107.7	107.36	107.43	695397.0
2010-09-21 10:00:00	DIA	ETF	107.43	107.61	107.39	107.48	694422.0

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

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