PREVIEW / etf_1hour / 2007-01-22

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-22.parquet
  size:    61 KB
  rows:    1,915

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-22 07:00:00	SPY	ETF	143.1	143.13	143.1	143.13	15000.0
2007-01-22 08:00:00	SPY	ETF	143.12	143.15	143.04	143.07	392700.0
2007-01-22 09:00:00	SPY	ETF	143.1	143.1	142.76	142.83	4771600.0
2007-01-22 10:00:00	SPY	ETF	142.84	142.85	142.1	142.26	13165600.0
2007-01-22 11:00:00	SPY	ETF	142.25	142.28	142.02	142.12	9492800.0
2007-01-22 12:00:00	SPY	ETF	142.11	142.2	141.96	141.99	5898000.0
2007-01-22 13:00:00	SPY	ETF	141.99	142.24	141.93	142.2	8230300.0
2007-01-22 14:00:00	SPY	ETF	142.19	142.41	142.19	142.29	6356400.0
2007-01-22 15:00:00	SPY	ETF	142.29	142.37	142.05	142.21	8131100.0
2007-01-22 16:00:00	SPY	ETF	142.21	142.44	142.18	142.43	1586700.0
2007-01-22 17:00:00	SPY	ETF	142.39	142.45	142.38	142.38	1294100.0
2007-01-22 18:00:00	SPY	ETF	142.39	142.42	142.39	142.4	4600.0
2007-01-22 19:00:00	SPY	ETF	142.39	142.39	142.38	142.39	1600.0
2007-01-22 07:00:00	QQQ	ETF	44.24	44.25	44.22	44.25	31550.0
2007-01-22 08:00:00	QQQ	ETF	44.25	44.26	44.2	44.2	271657.0
2007-01-22 09:00:00	QQQ	ETF	44.2	44.23	43.97	44.03	20376289.0
2007-01-22 10:00:00	QQQ	ETF	44.03	44.04	43.58	43.59	35774400.0
2007-01-22 11:00:00	QQQ	ETF	43.6	43.68	43.51	43.61	15379400.0
2007-01-22 12:00:00	QQQ	ETF	43.61	43.69	43.53	43.59	12604900.0
2007-01-22 13:00:00	QQQ	ETF	43.59	43.71	43.56	43.69	10175600.0
2007-01-22 14:00:00	QQQ	ETF	43.7	43.8	43.66	43.75	10391900.0
2007-01-22 15:00:00	QQQ	ETF	43.74	43.78	43.66	43.69	11637400.0
2007-01-22 16:00:00	QQQ	ETF	43.7	43.78	43.65	43.75	1954632.0
2007-01-22 17:00:00	QQQ	ETF	43.74	43.76	43.71	43.76	143272.0
2007-01-22 18:00:00	QQQ	ETF	43.75	43.77	43.74	43.74	78615.0
2007-01-22 19:00:00	QQQ	ETF	43.75	43.76	43.74	43.76	5885.0
2007-01-22 08:00:00	IWM	ETF	77.88	77.92	77.88	77.88	15100.0
2007-01-22 09:00:00	IWM	ETF	77.84	77.9	77.42	77.51	5989700.0
2007-01-22 10:00:00	IWM	ETF	77.52	77.53	77.0	77.18	9639400.0
2007-01-22 11:00:00	IWM	ETF	77.19	77.19	76.91	77.09	5769300.0
2007-01-22 12:00:00	IWM	ETF	77.09	77.17	76.96	77.05	2449500.0
2007-01-22 13:00:00	IWM	ETF	77.05	77.31	77.0	77.26	2865800.0
2007-01-22 14:00:00	IWM	ETF	77.26	77.4	77.24	77.32	2287700.0
2007-01-22 15:00:00	IWM	ETF	77.31	77.33	77.08	77.15	5013800.0
2007-01-22 16:00:00	IWM	ETF	77.15	77.31	77.06	77.12	1536800.0
2007-01-22 17:00:00	IWM	ETF	77.26	77.26	77.2	77.25	4000.0
2007-01-22 07:00:00	DIA	ETF	125.6	125.6	125.6	125.6	1000.0
2007-01-22 08:00:00	DIA	ETF	125.63	125.63	125.5	125.58	48000.0
2007-01-22 09:00:00	DIA	ETF	125.55	125.55	125.2	125.26	935100.0
2007-01-22 10:00:00	DIA	ETF	125.26	125.28	124.5	124.6	2938900.0
2007-01-22 11:00:00	DIA	ETF	124.6	124.68	124.46	124.53	1306800.0
2007-01-22 12:00:00	DIA	ETF	124.53	124.58	124.38	124.46	824600.0
2007-01-22 13:00:00	DIA	ETF	124.46	124.65	124.39	124.58	1222300.0
2007-01-22 14:00:00	DIA	ETF	124.59	124.73	124.57	124.68	1024500.0
2007-01-22 15:00:00	DIA	ETF	124.69	124.81	124.47	124.69	1819200.0
2007-01-22 16:00:00	DIA	ETF	124.71	124.85	124.69	124.84	86000.0
2007-01-22 17:00:00	DIA	ETF	124.85	124.85	124.85	124.85	1000.0
2007-01-22 18:00:00	DIA	ETF	124.85	124.85	124.85	124.85	400.0
2007-01-22 19:00:00	DIA	ETF	124.84	124.84	124.84	124.84	100.0
2007-01-22 08:00:00	GLD	ETF	62.87	62.9	62.8	62.85	55900.0

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

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