PREVIEW / etf_1hour / 2009-05-11

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-11.parquet
  size:    135 KB
  rows:    4,232

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
2009-05-11 04:00:00	SPY	ETF	91.89	91.96	91.62	91.79	7500.0
2009-05-11 05:00:00	SPY	ETF	91.9	91.9	91.6	91.72	22900.0
2009-05-11 06:00:00	SPY	ETF	91.63	92.05	91.63	92.0	52700.0
2009-05-11 07:00:00	SPY	ETF	91.97	92.04	91.73	91.77	761390.0
2009-05-11 08:00:00	SPY	ETF	91.78	92.4009	91.51	91.65	2522508.0
2009-05-11 09:00:00	SPY	ETF	91.66	92.25	91.04	91.34	30077967.0
2009-05-11 10:00:00	SPY	ETF	91.35	91.99	91.2	91.82	38630711.0
2009-05-11 11:00:00	SPY	ETF	91.82	92.11	91.54	91.57	24986592.0
2009-05-11 12:00:00	SPY	ETF	91.57	91.75	91.43	91.44	14983275.0
2009-05-11 13:00:00	SPY	ETF	91.44	91.94	91.28	91.8	24278210.0
2009-05-11 14:00:00	SPY	ETF	91.8	91.93	91.54	91.7413	42369471.0
2009-05-11 15:00:00	SPY	ETF	91.74	91.8	91.06	91.19	54945739.0
2009-05-11 16:00:00	SPY	ETF	91.21	91.6102	91.0845	91.2	9554053.0
2009-05-11 17:00:00	SPY	ETF	91.22	93.1258	91.0	91.06	3080474.0
2009-05-11 18:00:00	SPY	ETF	91.06	91.09	90.81	90.92	183817.0
2009-05-11 19:00:00	SPY	ETF	90.89	91.03	90.85	90.88	83702.0
2009-05-11 04:00:00	QQQ	ETF	33.76	33.76	33.66	33.75	2737.0
2009-05-11 06:00:00	QQQ	ETF	33.77	33.8	33.73	33.8	52800.0
2009-05-11 07:00:00	QQQ	ETF	33.8	33.85	33.77	33.78	400170.0
2009-05-11 08:00:00	QQQ	ETF	33.79	33.83	33.71	33.75	1391879.0
2009-05-11 09:00:00	QQQ	ETF	33.75	33.95	33.68	33.9001	15895803.0
2009-05-11 10:00:00	QQQ	ETF	33.91	34.64	33.85	34.4	43042798.0
2009-05-11 11:00:00	QQQ	ETF	34.4	34.57	34.31	34.36	15611295.0
2009-05-11 12:00:00	QQQ	ETF	34.35	34.5	34.3	34.4	8709404.0
2009-05-11 13:00:00	QQQ	ETF	34.4001	34.72	34.36	34.65	12218702.0
2009-05-11 14:00:00	QQQ	ETF	34.65	34.66	33.84	34.59	13513840.0
2009-05-11 15:00:00	QQQ	ETF	34.58	34.6	34.29	34.36	19875639.0
2009-05-11 16:00:00	QQQ	ETF	34.36	34.502	34.32	34.34	4684060.0
2009-05-11 17:00:00	QQQ	ETF	34.34	34.35	34.3	34.3	31996.0
2009-05-11 18:00:00	QQQ	ETF	34.3	34.3	34.19	34.25	131831.0
2009-05-11 19:00:00	QQQ	ETF	34.22	34.29	34.22	34.24	15051.0
2009-05-11 06:00:00	IWM	ETF	50.27	50.31	50.27	50.31	200.0
2009-05-11 07:00:00	IWM	ETF	50.32	50.33	50.21	50.21	23220.0
2009-05-11 08:00:00	IWM	ETF	50.24	50.37	50.07	50.08	195750.0
2009-05-11 09:00:00	IWM	ETF	50.09	50.33	49.79	49.97	4416212.0
2009-05-11 10:00:00	IWM	ETF	49.97	50.6	49.87	50.43	5578176.0
2009-05-11 11:00:00	IWM	ETF	50.43	50.61	50.15	50.17	3695029.0
2009-05-11 12:00:00	IWM	ETF	50.16	50.48	50.07	50.23	3149992.0
2009-05-11 13:00:00	IWM	ETF	50.22	50.66	50.11	50.5	3626233.0
2009-05-11 14:00:00	IWM	ETF	50.5	50.61	50.31	50.51	5499447.0
2009-05-11 15:00:00	IWM	ETF	50.5	50.55	50.15	50.24	10595282.0
2009-05-11 16:00:00	IWM	ETF	50.22	50.48	50.2	50.34	2219800.0
2009-05-11 17:00:00	IWM	ETF	50.35	50.36	50.28	50.36	34985.0
2009-05-11 18:00:00	IWM	ETF	50.3	50.3	50.19	50.19	11900.0
2009-05-11 19:00:00	IWM	ETF	50.15	50.15	50.14	50.15	1600.0
2009-05-11 04:00:00	DIA	ETF	84.88	84.88	84.73	84.73	1400.0
2009-05-11 06:00:00	DIA	ETF	84.77	84.77	84.77	84.77	200.0
2009-05-11 07:00:00	DIA	ETF	84.97	85.0	84.8	84.8	5741.0
2009-05-11 08:00:00	DIA	ETF	84.82	84.92	84.58	84.65	63374.0
2009-05-11 09:00:00	DIA	ETF	84.74	84.99	84.33	84.6	1613531.0

> showing 50 of 4,232 rows — these rows as CSV

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