PREVIEW / etf_1hour / 2007-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-26.parquet
  size:    62 KB
  rows:    1,952

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-26 04:00:00	SPY	ETF	142.32	142.33	142.32	142.33	4100.0
2007-01-26 07:00:00	SPY	ETF	142.41	142.44	142.26	142.26	45500.0
2007-01-26 08:00:00	SPY	ETF	142.26	142.6	142.26	142.6	2209400.0
2007-01-26 09:00:00	SPY	ETF	142.63	142.65	142.1	142.21	10524900.0
2007-01-26 10:00:00	SPY	ETF	142.21	142.35	141.67	142.01	18660300.0
2007-01-26 11:00:00	SPY	ETF	142.01	142.03	141.66	141.88	8325400.0
2007-01-26 12:00:00	SPY	ETF	141.88	142.17	141.85	141.91	6629500.0
2007-01-26 13:00:00	SPY	ETF	141.92	141.96	141.58	141.84	5386600.0
2007-01-26 14:00:00	SPY	ETF	141.84	142.12	141.66	142.06	8880400.0
2007-01-26 15:00:00	SPY	ETF	142.05	142.42	142.02	142.2	11761300.0
2007-01-26 16:00:00	SPY	ETF	142.21	142.32	142.05	142.22	700600.0
2007-01-26 17:00:00	SPY	ETF	142.18	142.2	142.17	142.2	1100.0
2007-01-26 18:00:00	SPY	ETF	142.2	142.2	142.2	142.2	900.0
2007-01-26 19:00:00	SPY	ETF	142.2	142.22	142.2	142.22	2700.0
2007-01-26 04:00:00	QQQ	ETF	43.67	43.67	43.67	43.67	200.0
2007-01-26 07:00:00	QQQ	ETF	43.71	43.72	43.65	43.66	81500.0
2007-01-26 08:00:00	QQQ	ETF	43.67	43.83	43.65	43.83	2287212.0
2007-01-26 09:00:00	QQQ	ETF	43.83	43.84	43.41	43.53	25027003.0
2007-01-26 10:00:00	QQQ	ETF	43.54	43.73	43.29	43.62	39607900.0
2007-01-26 11:00:00	QQQ	ETF	43.62	43.66	43.44	43.58	24423600.0
2007-01-26 12:00:00	QQQ	ETF	43.57	43.74	43.55	43.58	16247100.0
2007-01-26 13:00:00	QQQ	ETF	43.58	43.62	43.45	43.61	12212600.0
2007-01-26 14:00:00	QQQ	ETF	43.6	43.7	43.49	43.64	10469200.0
2007-01-26 15:00:00	QQQ	ETF	43.63	43.75	43.57	43.57	12817900.0
2007-01-26 16:00:00	QQQ	ETF	43.57	43.57	43.46	43.53	2024942.0
2007-01-26 17:00:00	QQQ	ETF	43.52	43.55	43.52	43.53	16900.0
2007-01-26 18:00:00	QQQ	ETF	43.55	43.56	43.55	43.55	7900.0
2007-01-26 19:00:00	QQQ	ETF	43.55	43.55	43.53	43.53	4286.0
2007-01-26 08:00:00	IWM	ETF	77.73	77.94	77.73	77.94	159200.0
2007-01-26 09:00:00	IWM	ETF	77.95	78.02	77.3	77.5	8253800.0
2007-01-26 10:00:00	IWM	ETF	77.5	77.87	77.16	77.62	8108400.0
2007-01-26 11:00:00	IWM	ETF	77.62	77.71	77.45	77.53	4550500.0
2007-01-26 12:00:00	IWM	ETF	77.53	77.8	77.52	77.68	4894700.0
2007-01-26 13:00:00	IWM	ETF	77.67	77.75	77.4	77.72	4335400.0
2007-01-26 14:00:00	IWM	ETF	77.72	77.94	77.57	77.8	5167800.0
2007-01-26 15:00:00	IWM	ETF	77.79	78.32	77.77	78.16	11226300.0
2007-01-26 16:00:00	IWM	ETF	78.16	78.19	77.95	77.95	7941600.0
2007-01-26 18:00:00	IWM	ETF	77.9	78.0	77.9	78.0	1200.0
2007-01-26 07:00:00	DIA	ETF	125.03	125.03	125.0	125.0	2600.0
2007-01-26 08:00:00	DIA	ETF	125.05	125.25	125.0	125.25	30500.0
2007-01-26 09:00:00	DIA	ETF	125.25	125.28	124.78	124.84	1226800.0
2007-01-26 10:00:00	DIA	ETF	124.82	124.94	124.4	124.58	2629300.0
2007-01-26 11:00:00	DIA	ETF	124.58	124.58	124.21	124.38	1300700.0
2007-01-26 12:00:00	DIA	ETF	124.37	124.62	124.37	124.45	783700.0
2007-01-26 13:00:00	DIA	ETF	124.4425	124.48	124.21	124.4099	1107600.0
2007-01-26 14:00:00	DIA	ETF	124.4	124.68	124.24	124.55	1130400.0
2007-01-26 15:00:00	DIA	ETF	124.54	124.88	124.52	124.78	1417900.0
2007-01-26 16:00:00	DIA	ETF	124.79	124.8298	124.72	124.77	901600.0
2007-01-26 17:00:00	DIA	ETF	124.8	124.8	124.8	124.8	100.0
2007-01-26 19:00:00	DIA	ETF	124.8	124.8	124.8	124.8	100.0

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

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