PREVIEW / etf_1hour / 2007-01-25

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-25.parquet
  size:    64 KB
  rows:    1,996

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-01-25 04:00:00	SPY	ETF	143.94	143.94	143.94	143.94	1400.0
2007-01-25 06:00:00	SPY	ETF	144.02	144.02	143.97	143.97	12500.0
2007-01-25 07:00:00	SPY	ETF	143.91	143.93	143.82	143.82	18600.0
2007-01-25 08:00:00	SPY	ETF	143.82	143.96	143.82	143.88	378400.0
2007-01-25 09:00:00	SPY	ETF	143.9	143.96	143.7	143.77	4676900.0
2007-01-25 10:00:00	SPY	ETF	143.77	143.8	143.35	143.51	7024100.0
2007-01-25 11:00:00	SPY	ETF	143.52	143.61	143.26	143.3	4050200.0
2007-01-25 12:00:00	SPY	ETF	143.3	143.31	143.0	143.07	7520500.0
2007-01-25 13:00:00	SPY	ETF	143.08	143.15	142.46	142.57	12387100.0
2007-01-25 14:00:00	SPY	ETF	142.57	142.87	142.01	142.51	14668300.0
2007-01-25 15:00:00	SPY	ETF	142.51	142.88	142.14	142.35	13673100.0
2007-01-25 16:00:00	SPY	ETF	142.34	143.0663	142.21	142.25	1636700.0
2007-01-25 17:00:00	SPY	ETF	142.28	142.3	142.22	142.22	100600.0
2007-01-25 18:00:00	SPY	ETF	142.33	142.38	142.31	142.32	20400.0
2007-01-25 19:00:00	SPY	ETF	142.3	142.31	142.28	142.28	1200.0
2007-01-25 04:00:00	QQQ	ETF	44.39	44.39	44.39	44.39	200.0
2007-01-25 07:00:00	QQQ	ETF	44.42	44.42	44.31	44.33	418322.0
2007-01-25 08:00:00	QQQ	ETF	44.35	44.41	44.34	44.39	879931.0
2007-01-25 09:00:00	QQQ	ETF	44.4	44.47	44.3	44.41	11785772.0
2007-01-25 10:00:00	QQQ	ETF	44.41	44.42	44.02	44.18	32267300.0
2007-01-25 11:00:00	QQQ	ETF	44.17	44.23	44.04	44.06	13379200.0
2007-01-25 12:00:00	QQQ	ETF	44.06	44.09	43.9	43.98	21377600.0
2007-01-25 13:00:00	QQQ	ETF	43.99	44.06	43.76	43.76	18118300.0
2007-01-25 14:00:00	QQQ	ETF	43.76	43.8	43.65	43.77	18360800.0
2007-01-25 15:00:00	QQQ	ETF	43.76	43.76	43.58	43.69	27213600.0
2007-01-25 16:00:00	QQQ	ETF	43.69	44.2798	43.65	43.71	9481969.0
2007-01-25 17:00:00	QQQ	ETF	43.71	43.73	43.61	43.66	318659.0
2007-01-25 18:00:00	QQQ	ETF	43.66	43.68	43.65	43.67	59056.0
2007-01-25 19:00:00	QQQ	ETF	43.68	43.68	43.64	43.66	32585.0
2007-01-25 07:00:00	IWM	ETF	78.85	78.85	78.85	78.85	500.0
2007-01-25 08:00:00	IWM	ETF	78.73	78.8	78.71	78.77	399600.0
2007-01-25 09:00:00	IWM	ETF	78.77	78.95	78.46	78.55	4828000.0
2007-01-25 10:00:00	IWM	ETF	78.54	78.57	78.17	78.42	7979900.0
2007-01-25 11:00:00	IWM	ETF	78.42	78.52	78.16	78.21	6496300.0
2007-01-25 12:00:00	IWM	ETF	78.21	78.21	78.02	78.12	4858200.0
2007-01-25 13:00:00	IWM	ETF	78.13	78.22	77.79	77.82	4678900.0
2007-01-25 14:00:00	IWM	ETF	77.82	77.83	77.57	77.75	14434000.0
2007-01-25 15:00:00	IWM	ETF	77.75	77.77	77.53	77.75	8218500.0
2007-01-25 16:00:00	IWM	ETF	77.76	78.7803	77.7	78.7803	955500.0
2007-01-25 17:00:00	IWM	ETF	77.7	77.75	77.64	77.75	61300.0
2007-01-25 18:00:00	IWM	ETF	77.71	77.8	77.71	77.8	24700.0
2007-01-25 07:00:00	DIA	ETF	126.06	126.06	126.04	126.04	8500.0
2007-01-25 08:00:00	DIA	ETF	126.04	126.08	125.98	126.0	65500.0
2007-01-25 09:00:00	DIA	ETF	126.07	126.15	125.9	125.99	737500.0
2007-01-25 10:00:00	DIA	ETF	125.99	126.02	125.7	125.84	1708500.0
2007-01-25 11:00:00	DIA	ETF	125.85	125.89	125.63	125.67	957800.0
2007-01-25 12:00:00	DIA	ETF	125.67	125.69	125.5	125.53	779300.0
2007-01-25 13:00:00	DIA	ETF	125.55	125.59	125.04	125.07	1387200.0
2007-01-25 14:00:00	DIA	ETF	125.06	125.1	124.87	125.0499	1378700.0
2007-01-25 15:00:00	DIA	ETF	125.04	125.04	124.79	124.99	1411700.0

> showing 50 of 1,996 rows — these rows as CSV

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