PREVIEW / etf_1hour / 2007-09-25

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-25.parquet
  size:    85 KB
  rows:    2,855

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-09-25 04:00:00	SPY	ETF	151.27	151.27	151.07	151.07	2100.0
2007-09-25 05:00:00	SPY	ETF	151.16	151.16	151.04	151.04	13200.0
2007-09-25 06:00:00	SPY	ETF	151.03	151.05	150.94	151.02	134300.0
2007-09-25 07:00:00	SPY	ETF	151.02	151.24	150.9	151.18	786600.0
2007-09-25 08:00:00	SPY	ETF	151.2	151.3	150.82	150.86	2162000.0
2007-09-25 09:00:00	SPY	ETF	150.85	151.69	150.58	150.74	21707066.0
2007-09-25 10:00:00	SPY	ETF	150.74	151.55	150.47	151.24	33339900.0
2007-09-25 11:00:00	SPY	ETF	151.245	151.62	151.0	151.19	15189500.0
2007-09-25 12:00:00	SPY	ETF	151.19	151.28	150.94	151.21	10063900.0
2007-09-25 13:00:00	SPY	ETF	151.2	151.5463	151.13	151.34	11170700.0
2007-09-25 14:00:00	SPY	ETF	151.34	151.48	151.12	151.44	11751500.0
2007-09-25 15:00:00	SPY	ETF	151.44	151.65	151.18	151.63	26079500.0
2007-09-25 16:00:00	SPY	ETF	151.65	151.66	151.21	151.52	8339800.0
2007-09-25 17:00:00	SPY	ETF	151.51	151.6	151.49	151.58	69300.0
2007-09-25 18:00:00	SPY	ETF	151.58	151.62	151.39	151.59	46800.0
2007-09-25 19:00:00	SPY	ETF	151.55	151.7	151.55	151.65	6400.0
2007-09-25 07:00:00	QQQ	ETF	50.4	50.46	50.37	50.43	110808.0
2007-09-25 08:00:00	QQQ	ETF	50.42	50.46	50.37	50.39	387986.0
2007-09-25 09:00:00	QQQ	ETF	50.39	50.58	50.36	50.5	17071904.0
2007-09-25 10:00:00	QQQ	ETF	50.5	50.76	50.4	50.72	19857836.0
2007-09-25 11:00:00	QQQ	ETF	50.72	50.84	50.64	50.7185	12663656.0
2007-09-25 12:00:00	QQQ	ETF	50.71	50.8	50.64	50.78	9045911.0
2007-09-25 13:00:00	QQQ	ETF	50.78	50.9	50.76	50.84	7422933.0
2007-09-25 14:00:00	QQQ	ETF	50.84	50.96	50.74	50.95	10606077.0
2007-09-25 15:00:00	QQQ	ETF	50.948	51.07	50.87	51.06	16407099.0
2007-09-25 16:00:00	QQQ	ETF	51.06	51.12	50.5771	51.11	7371039.0
2007-09-25 17:00:00	QQQ	ETF	51.12	51.16	50.43	51.16	50562.0
2007-09-25 18:00:00	QQQ	ETF	51.16	51.16	51.12	51.12	44066.0
2007-09-25 19:00:00	QQQ	ETF	51.12	51.16	51.12	51.15	62741.0
2007-09-25 04:00:00	IWM	ETF	79.85	79.85	79.77	79.77	1000.0
2007-09-25 07:00:00	IWM	ETF	79.79	79.87	79.75	79.87	12300.0
2007-09-25 08:00:00	IWM	ETF	79.9	79.9	79.61	79.63	303500.0
2007-09-25 09:00:00	IWM	ETF	79.63	80.34	75.67	79.47	7340384.0
2007-09-25 10:00:00	IWM	ETF	79.48	79.92	79.28	79.59	11966000.0
2007-09-25 11:00:00	IWM	ETF	79.59	79.81	79.39	79.53	6817800.0
2007-09-25 12:00:00	IWM	ETF	79.53	79.78	79.46	79.66	5395300.0
2007-09-25 13:00:00	IWM	ETF	79.66	79.93	79.61	79.77	4823100.0
2007-09-25 14:00:00	IWM	ETF	79.76	80.03	79.62	79.98	5478100.0
2007-09-25 15:00:00	IWM	ETF	79.99	80.07	79.68	80.05	9973200.0
2007-09-25 16:00:00	IWM	ETF	80.04	80.07	79.72	80.02	2952369.0
2007-09-25 17:00:00	IWM	ETF	80.0	80.15	79.99	80.15	51000.0
2007-09-25 19:00:00	IWM	ETF	80.04	80.05	80.04	80.05	500.0
2007-09-25 07:00:00	DIA	ETF	137.11	137.26	137.11	137.26	3700.0
2007-09-25 08:00:00	DIA	ETF	137.25	137.32	137.03	137.04	30900.0
2007-09-25 09:00:00	DIA	ETF	137.06	137.16	136.85	137.04	1217500.0
2007-09-25 10:00:00	DIA	ETF	137.03	137.67	136.83	137.47	2757100.0
2007-09-25 11:00:00	DIA	ETF	137.48	137.82	137.26	137.46	1774100.0
2007-09-25 12:00:00	DIA	ETF	137.45	137.5	137.28	137.42	621200.0
2007-09-25 13:00:00	DIA	ETF	137.4	137.6	137.34	137.59	3132800.0
2007-09-25 14:00:00	DIA	ETF	137.57	137.67	137.43	137.63	1393800.0

> showing 50 of 2,855 rows — these rows as CSV

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