PREVIEW / etf_1hour / 2007-12-26

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-26.parquet
  size:    91 KB
  rows:    3,088

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
2007-12-26 06:00:00	SPY	ETF	149.41	149.52	149.25	149.25	64200.0
2007-12-26 07:00:00	SPY	ETF	149.34	149.34	148.97	149.0	381900.0
2007-12-26 08:00:00	SPY	ETF	149.08	149.13	148.95	149.08	559000.0
2007-12-26 09:00:00	SPY	ETF	149.07	149.07	148.5	148.65	11008508.0
2007-12-26 10:00:00	SPY	ETF	148.64	149.0	148.61	148.88	7701815.0
2007-12-26 11:00:00	SPY	ETF	148.87	149.06	148.76	148.7699	5448603.0
2007-12-26 12:00:00	SPY	ETF	148.77	149.17	148.75	149.12	5812679.0
2007-12-26 13:00:00	SPY	ETF	149.11	149.5	149.08	149.49	8317198.0
2007-12-26 14:00:00	SPY	ETF	149.49	149.55	149.25	149.44	7152747.0
2007-12-26 15:00:00	SPY	ETF	149.44	149.62	149.18	149.46	14813759.0
2007-12-26 16:00:00	SPY	ETF	149.4	149.67	149.4	149.58	1638400.0
2007-12-26 17:00:00	SPY	ETF	149.55	149.6	149.49	149.6	38100.0
2007-12-26 18:00:00	SPY	ETF	149.59	149.59	149.44	149.44	42500.0
2007-12-26 19:00:00	SPY	ETF	149.44	149.44	149.31	149.31	20300.0
2007-12-26 07:00:00	QQQ	ETF	52.26	52.26	52.2	52.2	20352.0
2007-12-26 08:00:00	QQQ	ETF	52.22	52.26	52.17	52.21	290238.0
2007-12-26 09:00:00	QQQ	ETF	52.21	52.21	52.0	52.0794	8889418.0
2007-12-26 10:00:00	QQQ	ETF	52.08	52.25	52.06	52.18	6638453.0
2007-12-26 11:00:00	QQQ	ETF	52.19	52.28	52.16	52.16	5717740.0
2007-12-26 12:00:00	QQQ	ETF	52.16	52.4	52.16	52.38	6268508.0
2007-12-26 13:00:00	QQQ	ETF	52.38	52.56	52.34	52.56	4807991.0
2007-12-26 14:00:00	QQQ	ETF	52.56	52.63	52.5	52.59	9410502.0
2007-12-26 15:00:00	QQQ	ETF	52.59	52.6	52.41	52.5	9209769.0
2007-12-26 16:00:00	QQQ	ETF	52.52	52.57	52.3218	52.51	7213485.0
2007-12-26 17:00:00	QQQ	ETF	52.5	52.51	52.5	52.51	3300.0
2007-12-26 18:00:00	QQQ	ETF	52.52	52.53	52.5	52.5	18305.0
2007-12-26 19:00:00	QQQ	ETF	52.48	52.5	52.46	52.46	4018.0
2007-12-26 07:00:00	IWM	ETF	79.21	79.21	78.94	78.94	12000.0
2007-12-26 08:00:00	IWM	ETF	78.99	78.99	78.92	78.93	84900.0
2007-12-26 09:00:00	IWM	ETF	78.9	78.96	78.72	78.78	6140644.0
2007-12-26 10:00:00	IWM	ETF	78.78	78.97	78.76	78.81	3384570.0
2007-12-26 11:00:00	IWM	ETF	78.81	78.85	78.71	78.77	3499803.0
2007-12-26 12:00:00	IWM	ETF	78.76	79.19	78.75	79.16	5570360.0
2007-12-26 13:00:00	IWM	ETF	79.16	79.76	79.12	79.72	11318017.0
2007-12-26 14:00:00	IWM	ETF	79.72	79.84	79.54	79.7	9772686.0
2007-12-26 15:00:00	IWM	ETF	79.7	79.76	79.26	79.4	12752413.0
2007-12-26 16:00:00	IWM	ETF	79.4	79.66	79.16	79.54	12918000.0
2007-12-26 17:00:00	IWM	ETF	79.49	79.58	79.49	79.5	65300.0
2007-12-26 18:00:00	IWM	ETF	79.55	79.59	79.55	79.59	33100.0
2007-12-26 19:00:00	IWM	ETF	79.49	79.49	79.48	79.48	21600.0
2007-12-26 07:00:00	DIA	ETF	135.13	135.13	135.13	135.13	500.0
2007-12-26 08:00:00	DIA	ETF	135.24	135.26	135.14	135.14	12600.0
2007-12-26 09:00:00	DIA	ETF	135.13	135.2	134.79	134.87	937990.0
2007-12-26 10:00:00	DIA	ETF	134.86	135.06	134.83	134.96	688521.0
2007-12-26 11:00:00	DIA	ETF	134.95	135.07	134.91	134.93	427100.0
2007-12-26 12:00:00	DIA	ETF	134.93	135.22	134.93	135.18	514710.0
2007-12-26 13:00:00	DIA	ETF	135.18	135.42	135.12	135.4	901383.0
2007-12-26 14:00:00	DIA	ETF	135.42	135.43	135.21	135.37	1087989.0
2007-12-26 15:00:00	DIA	ETF	135.36	135.5	135.15	135.3	1127343.0
2007-12-26 16:00:00	DIA	ETF	135.31	135.47	135.28	135.4	49900.0

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

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