PREVIEW / etf_1hour / 2010-11-26

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-26.parquet
  size:    108 KB
  rows:    3,204

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-26 04:00:00	SPY	ETF	119.95	119.95	119.1	119.19	78400.0
2010-11-26 05:00:00	SPY	ETF	119.21	119.34	119.0	119.11	15800.0
2010-11-26 06:00:00	SPY	ETF	119.11	119.11	118.79	119.07	320800.0
2010-11-26 07:00:00	SPY	ETF	119.07	119.26	118.78	119.2	1475488.0
2010-11-26 08:00:00	SPY	ETF	119.23	119.28	118.62	119.22	2741904.0
2010-11-26 09:00:00	SPY	ETF	119.21	119.61	119.03	119.6	15862530.0
2010-11-26 10:00:00	SPY	ETF	119.59	119.81	119.41	119.42	14059368.0
2010-11-26 11:00:00	SPY	ETF	119.42	119.54	119.21	119.41	17364774.0
2010-11-26 12:00:00	SPY	ETF	119.41	119.54	119.24	119.3	12012151.0
2010-11-26 13:00:00	SPY	ETF	119.3	119.302	118.78	118.8	5304909.0
2010-11-26 14:00:00	SPY	ETF	118.79	118.86	118.68	118.78	464943.0
2010-11-26 15:00:00	SPY	ETF	118.76	118.84	118.74	118.74	226843.0
2010-11-26 16:00:00	SPY	ETF	118.72	118.84	118.72	118.84	20805.0
2010-11-26 04:00:00	QQQ	ETF	52.95	52.95	52.79	52.79	5300.0
2010-11-26 05:00:00	QQQ	ETF	52.67	52.67	52.61	52.65	1500.0
2010-11-26 06:00:00	QQQ	ETF	52.58	52.61	52.55	52.61	1400.0
2010-11-26 07:00:00	QQQ	ETF	52.6	52.68	52.54	52.66	159581.0
2010-11-26 08:00:00	QQQ	ETF	52.68	52.72	52.58	52.72	606781.0
2010-11-26 09:00:00	QQQ	ETF	52.71	53.03	52.67	53.0	8206358.0
2010-11-26 10:00:00	QQQ	ETF	52.995	53.13	52.92	52.948	4725633.0
2010-11-26 11:00:00	QQQ	ETF	52.94	53.06	52.92	53.015	2021540.0
2010-11-26 12:00:00	QQQ	ETF	53.01	53.05	52.93	52.97	4177956.0
2010-11-26 13:00:00	QQQ	ETF	52.97	53.0201	52.75	52.76	2145819.0
2010-11-26 14:00:00	QQQ	ETF	52.76	52.76	52.73	52.76	42369.0
2010-11-26 15:00:00	QQQ	ETF	52.76	52.76	52.74	52.75	27100.0
2010-11-26 16:00:00	QQQ	ETF	52.74	52.75	52.73	52.75	23613.0
2010-11-26 04:00:00	IWM	ETF	73.51	73.51	73.1	73.1	18847.0
2010-11-26 05:00:00	IWM	ETF	73.1	73.16	73.01	73.16	11100.0
2010-11-26 06:00:00	IWM	ETF	72.91	73.04	72.84	73.04	3975.0
2010-11-26 07:00:00	IWM	ETF	72.96	73.2	72.91	73.18	57050.0
2010-11-26 08:00:00	IWM	ETF	73.19	73.32	73.06	73.31	714856.0
2010-11-26 09:00:00	IWM	ETF	73.31	73.64	73.13	73.62	4239748.0
2010-11-26 10:00:00	IWM	ETF	73.62	73.73	73.34	73.3501	3761489.0
2010-11-26 11:00:00	IWM	ETF	73.36	73.6	73.36	73.51	3553306.0
2010-11-26 12:00:00	IWM	ETF	73.51	73.615	73.37	73.39	4812602.0
2010-11-26 13:00:00	IWM	ETF	73.39	73.41	73.185	73.22	1174794.0
2010-11-26 14:00:00	IWM	ETF	73.22	73.22	73.22	73.22	200.0
2010-11-26 16:00:00	IWM	ETF	73.21	73.21	73.2	73.2	1325.0
2010-11-26 04:00:00	DIA	ETF	111.3	111.3	111.05	111.05	2500.0
2010-11-26 06:00:00	DIA	ETF	110.86	110.86	110.86	110.86	1000.0
2010-11-26 07:00:00	DIA	ETF	110.84	110.92	110.84	110.92	1100.0
2010-11-26 08:00:00	DIA	ETF	111.05	111.1	110.79	111.0	38902.0
2010-11-26 09:00:00	DIA	ETF	110.97	111.1399	110.67	111.1399	698781.0
2010-11-26 10:00:00	DIA	ETF	111.14	111.35	111.04	111.07	572787.0
2010-11-26 11:00:00	DIA	ETF	111.07	111.16	110.88	111.0655	458304.0
2010-11-26 12:00:00	DIA	ETF	111.05	111.15	110.9099	110.94	426106.0
2010-11-26 13:00:00	DIA	ETF	110.92	110.93	110.55	110.65	84254.0
2010-11-26 14:00:00	DIA	ETF	110.65	110.79	110.65	110.7	3096.0
2010-11-26 15:00:00	DIA	ETF	110.84	110.84	110.65	110.65	6854.0
2010-11-26 16:00:00	DIA	ETF	110.75	110.75	110.75	110.75	100.0

> showing 50 of 3,204 rows — these rows as CSV

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