PREVIEW / etf_1hour / 2008-01-18

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-18.parquet
  size:    102 KB
  rows:    3,399

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
2008-01-18 04:00:00	SPY	ETF	134.02	134.49	134.01	134.4	21300.0
2008-01-18 05:00:00	SPY	ETF	134.5	135.16	134.5	134.78	24200.0
2008-01-18 06:00:00	SPY	ETF	134.81	135.2	134.63	135.1	482600.0
2008-01-18 07:00:00	SPY	ETF	135.1	135.5	134.69	135.36	2026800.0
2008-01-18 08:00:00	SPY	ETF	135.36	135.51	133.95	135.04	4950797.0
2008-01-18 09:00:00	SPY	ETF	135.03	135.04	133.61	133.73	48332876.0
2008-01-18 10:00:00	SPY	ETF	133.74	135.02	133.5	133.67	52024523.0
2008-01-18 11:00:00	SPY	ETF	133.67	133.77	131.1	131.43	65204170.0
2008-01-18 12:00:00	SPY	ETF	131.42	133.31	131.34	132.39	42028056.0
2008-01-18 13:00:00	SPY	ETF	132.38	132.89	131.6	132.01	29797402.0
2008-01-18 14:00:00	SPY	ETF	132.01	132.61	131.4	132.0	35804787.0
2008-01-18 15:00:00	SPY	ETF	132.0	132.73	131.57	132.49	54766998.0
2008-01-18 16:00:00	SPY	ETF	132.53	135.36	132.01	132.13	7776600.0
2008-01-18 17:00:00	SPY	ETF	132.11	134.72	132.02	132.05	161900.0
2008-01-18 18:00:00	SPY	ETF	132.05	132.05	131.73	131.9	101600.0
2008-01-18 19:00:00	SPY	ETF	131.8	131.9	131.65	131.7	34300.0
2008-01-18 20:00:00	SPY	ETF	131.7	131.7	131.7	131.7	300.0
2008-01-18 04:00:00	QQQ	ETF	45.61	45.72	45.61	45.72	2200.0
2008-01-18 05:00:00	QQQ	ETF	45.74	45.87	45.74	45.79	7700.0
2008-01-18 06:00:00	QQQ	ETF	45.81	45.93	45.78	45.93	21500.0
2008-01-18 07:00:00	QQQ	ETF	45.93	46.03	45.76	46.0	735194.0
2008-01-18 08:00:00	QQQ	ETF	46.0	46.07	45.65	45.95	2279399.0
2008-01-18 09:00:00	QQQ	ETF	45.94	45.95	45.43	45.66	28123884.0
2008-01-18 10:00:00	QQQ	ETF	45.66	46.14	45.62	45.76	38456939.0
2008-01-18 11:00:00	QQQ	ETF	45.76	45.81	44.76	45.1	52610940.0
2008-01-18 12:00:00	QQQ	ETF	45.11	45.77	45.08	45.54	37770261.0
2008-01-18 13:00:00	QQQ	ETF	45.55	45.75	45.04	45.38	21955949.0
2008-01-18 14:00:00	QQQ	ETF	45.38	45.52	45.02	45.32	28347365.0
2008-01-18 15:00:00	QQQ	ETF	45.32	45.52	45.14	45.36	38882792.0
2008-01-18 16:00:00	QQQ	ETF	45.37	45.41	45.15	45.29	23384223.0
2008-01-18 17:00:00	QQQ	ETF	45.26	45.35	45.23	45.24	356946.0
2008-01-18 18:00:00	QQQ	ETF	45.23	45.24	45.15	45.23	72975.0
2008-01-18 19:00:00	QQQ	ETF	45.18	45.25	45.16	45.19	55315.0
2008-01-18 04:00:00	IWM	ETF	68.34	68.34	68.34	68.34	700.0
2008-01-18 06:00:00	IWM	ETF	68.65	68.65	68.65	68.65	200.0
2008-01-18 07:00:00	IWM	ETF	68.7	68.85	68.36	68.74	161900.0
2008-01-18 08:00:00	IWM	ETF	68.7	68.8	68.46	68.54	829000.0
2008-01-18 09:00:00	IWM	ETF	68.54	68.59	67.6	67.67	13227582.0
2008-01-18 10:00:00	IWM	ETF	67.67	68.81	67.46	67.75	22753642.0
2008-01-18 11:00:00	IWM	ETF	67.76	67.85	63.3	66.56	24535006.0
2008-01-18 12:00:00	IWM	ETF	66.57	67.39	66.51	67.11	14615776.0
2008-01-18 13:00:00	IWM	ETF	67.11	67.53	66.81	67.06	11668414.0
2008-01-18 14:00:00	IWM	ETF	67.06	67.26	66.49	66.94	14619212.0
2008-01-18 15:00:00	IWM	ETF	66.94	67.25	66.61	67.17	20547365.0
2008-01-18 16:00:00	IWM	ETF	67.17	67.26	66.86	67.01	8895698.0
2008-01-18 17:00:00	IWM	ETF	67.04	67.04	66.97	67.01	19500.0
2008-01-18 18:00:00	IWM	ETF	66.95	67.03	66.76	66.76	13100.0
2008-01-18 19:00:00	IWM	ETF	66.8	66.8	66.8	66.8	100.0
2008-01-18 07:00:00	DIA	ETF	123.1	123.46	122.94	123.45	23700.0
2008-01-18 08:00:00	DIA	ETF	123.42	123.48	122.9	123.02	97000.0

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

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