PREVIEW / etf_1hour / 2010-11-24

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-24.parquet
  size:    164 KB
  rows:    5,077

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-11-24 04:00:00	SPY	ETF	118.2	118.38	118.11	118.2	16400.0
2010-11-24 05:00:00	SPY	ETF	118.15	118.67	118.15	118.67	20900.0
2010-11-24 06:00:00	SPY	ETF	118.65	118.83	118.57	118.57	88143.0
2010-11-24 07:00:00	SPY	ETF	118.54	118.79	118.43	118.69	517455.0
2010-11-24 08:00:00	SPY	ETF	118.69	119.47	118.63	119.19	4167430.0
2010-11-24 09:00:00	SPY	ETF	119.17	119.66	119.14	119.54	22040933.0
2010-11-24 10:00:00	SPY	ETF	119.54	120.04	119.32	119.88	25928691.0
2010-11-24 11:00:00	SPY	ETF	119.8875	120.01	119.75	119.905	12925460.0
2010-11-24 12:00:00	SPY	ETF	119.9017	120.08	119.87	120.0	10309052.0
2010-11-24 13:00:00	SPY	ETF	120.0	120.17	119.95	120.09	8544843.0
2010-11-24 14:00:00	SPY	ETF	120.08	120.12	119.89	120.05	9205865.0
2010-11-24 15:00:00	SPY	ETF	120.04	120.23	119.94	120.18	30367778.0
2010-11-24 16:00:00	SPY	ETF	120.19	120.22	119.475	120.05	10387798.0
2010-11-24 17:00:00	SPY	ETF	120.03	120.15	119.9869	120.08	115253.0
2010-11-24 18:00:00	SPY	ETF	120.08	120.15	120.04	120.11	48670.0
2010-11-24 19:00:00	SPY	ETF	120.13	120.13	119.96	120.03	78320.0
2010-11-24 04:00:00	QQQ	ETF	52.05	52.05	52.05	52.05	200.0
2010-11-24 05:00:00	QQQ	ETF	52.2	52.2	52.2	52.2	200.0
2010-11-24 06:00:00	QQQ	ETF	52.22	52.25	52.2	52.21	1550.0
2010-11-24 07:00:00	QQQ	ETF	52.15	52.24	52.15	52.24	18600.0
2010-11-24 08:00:00	QQQ	ETF	52.23	52.6	52.23	52.54	1272491.0
2010-11-24 09:00:00	QQQ	ETF	52.53	52.86	52.51	52.79	9184159.0
2010-11-24 10:00:00	QQQ	ETF	52.79	53.2	52.7	53.15	11733404.0
2010-11-24 11:00:00	QQQ	ETF	53.1401	53.19	53.06	53.125	4670709.0
2010-11-24 12:00:00	QQQ	ETF	53.125	53.18	53.11	53.17	2697120.0
2010-11-24 13:00:00	QQQ	ETF	53.16	53.25	53.14	53.15	2166677.0
2010-11-24 14:00:00	QQQ	ETF	53.159	53.18	53.0705	53.13	2535781.0
2010-11-24 15:00:00	QQQ	ETF	53.12	53.18	53.05	53.12	6651723.0
2010-11-24 16:00:00	QQQ	ETF	53.12	53.185	53.04	53.08	1943016.0
2010-11-24 17:00:00	QQQ	ETF	53.08	53.18	53.05	53.14	45290.0
2010-11-24 18:00:00	QQQ	ETF	53.14	53.15	53.09	53.11	14661.0
2010-11-24 19:00:00	QQQ	ETF	53.12	53.18	53.08	53.18	7501.0
2010-11-24 06:00:00	IWM	ETF	72.3	72.3	72.3	72.3	100.0
2010-11-24 07:00:00	IWM	ETF	72.25	72.42	72.2	72.34	13700.0
2010-11-24 08:00:00	IWM	ETF	71.84	72.92	71.84	72.77	582441.0
2010-11-24 09:00:00	IWM	ETF	72.76	73.17	72.71	72.96	7307792.0
2010-11-24 10:00:00	IWM	ETF	72.95	73.46	72.7799	73.411	6874291.0
2010-11-24 11:00:00	IWM	ETF	73.42	73.61	73.27	73.57	4834890.0
2010-11-24 12:00:00	IWM	ETF	73.57	73.68	73.53	73.57	2824116.0
2010-11-24 13:00:00	IWM	ETF	73.5725	73.67	73.49	73.53	3110429.0
2010-11-24 14:00:00	IWM	ETF	73.54	73.57	73.44	73.54	2514160.0
2010-11-24 15:00:00	IWM	ETF	73.52	73.75	73.49	73.74	7994691.0
2010-11-24 16:00:00	IWM	ETF	73.74	73.8	73.65	73.72	861391.0
2010-11-24 17:00:00	IWM	ETF	73.74	73.74	73.68	73.68	2000.0
2010-11-24 18:00:00	IWM	ETF	73.7	73.72	73.7	73.72	400.0
2010-11-24 19:00:00	IWM	ETF	73.67	73.68	73.65	73.65	1300.0
2010-11-24 08:00:00	DIA	ETF	110.65	111.23	110.63	111.05	18411.0
2010-11-24 09:00:00	DIA	ETF	111.02	111.51	110.98	111.4	859740.0
2010-11-24 10:00:00	DIA	ETF	111.39	111.78	111.22	111.68	1018355.0
2010-11-24 11:00:00	DIA	ETF	111.68	111.77	111.53	111.65	440582.0

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

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