PREVIEW / etf_1hour / 2008-01-15

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-15.parquet
  size:    100 KB
  rows:    3,352

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-15 04:00:00	SPY	ETF	140.71	140.71	140.53	140.53	8900.0
2008-01-15 05:00:00	SPY	ETF	140.5	140.65	140.42	140.65	74000.0
2008-01-15 06:00:00	SPY	ETF	140.51	140.99	140.36	140.73	355200.0
2008-01-15 07:00:00	SPY	ETF	140.73	140.88	140.05	140.22	1906600.0
2008-01-15 08:00:00	SPY	ETF	140.54	140.54	139.61	139.69	9879700.0
2008-01-15 09:00:00	SPY	ETF	139.69	140.58	139.61	139.86	18735777.0
2008-01-15 10:00:00	SPY	ETF	139.86	140.05	138.36	138.64	45159793.0
2008-01-15 11:00:00	SPY	ETF	138.64	139.05	138.24	138.64	23543470.0
2008-01-15 12:00:00	SPY	ETF	138.64	138.92	138.37	138.66	17828456.0
2008-01-15 13:00:00	SPY	ETF	138.66	141.4903	138.25	138.48	26939870.0
2008-01-15 14:00:00	SPY	ETF	138.48	138.84	138.1	138.22	27240614.0
2008-01-15 15:00:00	SPY	ETF	138.22	139.16	137.9	137.95	54449764.0
2008-01-15 16:00:00	SPY	ETF	138.0199	138.69	136.74	136.77	9779675.0
2008-01-15 17:00:00	SPY	ETF	136.76	137.13	136.71	136.96	1549900.0
2008-01-15 18:00:00	SPY	ETF	136.94	137.04	136.8	136.9	326400.0
2008-01-15 19:00:00	SPY	ETF	136.86	137.01	136.74	136.85	32200.0
2008-01-15 04:00:00	QQQ	ETF	47.7	47.7	47.59	47.59	600.0
2008-01-15 05:00:00	QQQ	ETF	47.53	47.58	47.52	47.58	400.0
2008-01-15 06:00:00	QQQ	ETF	47.56	47.68	47.56	47.62	82800.0
2008-01-15 07:00:00	QQQ	ETF	47.55	47.62	47.31	47.38	795927.0
2008-01-15 08:00:00	QQQ	ETF	47.41	47.57	47.2	47.24	6880881.0
2008-01-15 09:00:00	QQQ	ETF	47.26	47.52	47.26	47.38	19664859.0
2008-01-15 10:00:00	QQQ	ETF	47.37	47.45	46.87	47.0	34056587.0
2008-01-15 11:00:00	QQQ	ETF	47.01	47.18	46.82	47.01	24859526.0
2008-01-15 12:00:00	QQQ	ETF	47.01	47.06	46.67	46.79	21413418.0
2008-01-15 13:00:00	QQQ	ETF	46.79	47.02	46.53	46.58	24767118.0
2008-01-15 14:00:00	QQQ	ETF	46.58	46.78	46.47	46.56	27518905.0
2008-01-15 15:00:00	QQQ	ETF	46.56	46.96	46.35	46.58	58533757.0
2008-01-15 16:00:00	QQQ	ETF	46.58	47.9235	45.44	45.69	21476112.0
2008-01-15 17:00:00	QQQ	ETF	45.67	45.79	45.59	45.75	1803313.0
2008-01-15 18:00:00	QQQ	ETF	45.75	45.78	45.71	45.75	473440.0
2008-01-15 19:00:00	QQQ	ETF	45.71	45.78	45.7	45.76	83215.0
2008-01-15 06:00:00	IWM	ETF	70.59	70.66	70.51	70.6	33100.0
2008-01-15 07:00:00	IWM	ETF	70.54	70.64	70.21	70.33	243400.0
2008-01-15 08:00:00	IWM	ETF	70.46	70.62	69.82	69.87	2543600.0
2008-01-15 09:00:00	IWM	ETF	69.86	70.16	69.84	69.98	7271588.0
2008-01-15 10:00:00	IWM	ETF	69.98	70.07	69.09	69.32	22415389.0
2008-01-15 11:00:00	IWM	ETF	69.33	70.05	69.07	69.27	12108603.0
2008-01-15 12:00:00	IWM	ETF	69.28	69.5	69.17	69.43	6045910.0
2008-01-15 13:00:00	IWM	ETF	69.43	69.97	69.29	69.42	11125130.0
2008-01-15 14:00:00	IWM	ETF	69.42	69.76	69.32	69.5	9747572.0
2008-01-15 15:00:00	IWM	ETF	69.52	69.95	69.25	69.49	21383342.0
2008-01-15 16:00:00	IWM	ETF	69.51	70.94	68.73	68.9	2744600.0
2008-01-15 17:00:00	IWM	ETF	68.9	70.93	68.81	68.9	122400.0
2008-01-15 18:00:00	IWM	ETF	68.95	68.98	68.9	68.98	9400.0
2008-01-15 19:00:00	IWM	ETF	68.98	68.98	68.98	68.98	2000.0
2008-01-15 07:00:00	DIA	ETF	127.24	127.24	126.71	126.95	103900.0
2008-01-15 08:00:00	DIA	ETF	126.9	127.24	126.44	126.49	606700.0
2008-01-15 09:00:00	DIA	ETF	126.54	126.91	126.44	126.65	1533357.0
2008-01-15 10:00:00	DIA	ETF	126.65	126.8	125.5	125.75	3575244.0

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

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