PREVIEW / etf_1hour / 2007-01-09

all etf 1-hour files

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

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-09 04:00:00	SPY	ETF	141.6	141.6	141.6	141.6	1900.0
2007-01-09 06:00:00	SPY	ETF	141.64	141.64	141.55	141.59	95000.0
2007-01-09 07:00:00	SPY	ETF	141.55	141.55	141.39	141.48	47700.0
2007-01-09 08:00:00	SPY	ETF	141.52	141.55	141.37	141.44	534900.0
2007-01-09 09:00:00	SPY	ETF	141.45	141.45	141.01	141.12	4993100.0
2007-01-09 10:00:00	SPY	ETF	141.13	141.47	140.95	141.22	7692700.0
2007-01-09 11:00:00	SPY	ETF	141.23	141.33	140.48	140.55	8979600.0
2007-01-09 12:00:00	SPY	ETF	140.56	140.73	140.4	140.61	9068000.0
2007-01-09 13:00:00	SPY	ETF	140.61	141.14	140.58	140.92	7500100.0
2007-01-09 14:00:00	SPY	ETF	140.92	141.25	140.79	141.04	10442500.0
2007-01-09 15:00:00	SPY	ETF	141.0488	141.6	140.91	141.13	18640000.0
2007-01-09 16:00:00	SPY	ETF	141.11	141.18	141.02	141.13	5343700.0
2007-01-09 17:00:00	SPY	ETF	141.11	141.11	141.04	141.04	23900.0
2007-01-09 18:00:00	SPY	ETF	141.08	141.08	141.05	141.08	3000.0
2007-01-09 19:00:00	SPY	ETF	141.08	141.08	141.0	141.01	47300.0
2007-01-09 07:00:00	QQQ	ETF	44.06	44.06	43.97	44.01	235181.0
2007-01-09 08:00:00	QQQ	ETF	44.04	44.05	44.0	44.03	1185988.0
2007-01-09 09:00:00	QQQ	ETF	44.02	44.1	43.85	43.96	11448880.0
2007-01-09 10:00:00	QQQ	ETF	43.97	44.21	43.88	44.11	20714000.0
2007-01-09 11:00:00	QQQ	ETF	44.11	44.16	43.84	43.89	15051200.0
2007-01-09 12:00:00	QQQ	ETF	43.88	44.0	43.63	43.78	19658900.0
2007-01-09 13:00:00	QQQ	ETF	43.78	44.24	43.75	44.09	14242200.0
2007-01-09 14:00:00	QQQ	ETF	44.09	44.2	43.99	44.14	12042400.0
2007-01-09 15:00:00	QQQ	ETF	44.13	44.29	44.06	44.12	17485100.0
2007-01-09 16:00:00	QQQ	ETF	44.11	44.14	43.9	44.1	6300994.0
2007-01-09 17:00:00	QQQ	ETF	44.1	44.11	44.08	44.11	1526652.0
2007-01-09 18:00:00	QQQ	ETF	44.11	44.11	44.09	44.1	19016.0
2007-01-09 19:00:00	QQQ	ETF	44.1	44.1	44.02	44.03	86229.0
2007-01-09 08:00:00	IWM	ETF	77.22	77.22	77.06	77.14	29200.0
2007-01-09 09:00:00	IWM	ETF	77.1	77.21	76.7	76.75	4113200.0
2007-01-09 10:00:00	IWM	ETF	76.77	77.06	76.67	76.9	4463500.0
2007-01-09 11:00:00	IWM	ETF	76.9	76.96	76.3	76.39	9790400.0
2007-01-09 12:00:00	IWM	ETF	76.38	76.56	76.19	76.47	10683100.0
2007-01-09 13:00:00	IWM	ETF	76.46	77.01	76.44	76.82	5038900.0
2007-01-09 14:00:00	IWM	ETF	76.81	77.15	76.81	77.03	6373600.0
2007-01-09 15:00:00	IWM	ETF	77.02	77.31	76.92	77.31	12029100.0
2007-01-09 16:00:00	IWM	ETF	77.31	77.31	77.2	77.24	104300.0
2007-01-09 17:00:00	IWM	ETF	77.18	77.18	77.11	77.11	30500.0
2007-01-09 18:00:00	IWM	ETF	77.15	77.15	77.14	77.14	2000.0
2007-01-09 19:00:00	IWM	ETF	77.11	77.11	77.1	77.1	1500.0
2007-01-09 08:00:00	DIA	ETF	124.46	124.5	124.38	124.45	27900.0
2007-01-09 09:00:00	DIA	ETF	124.43	124.57	124.17	124.25	925100.0
2007-01-09 10:00:00	DIA	ETF	124.26	124.48	124.12	124.32	1421100.0
2007-01-09 11:00:00	DIA	ETF	124.32	124.4	123.42	123.7	1189100.0
2007-01-09 12:00:00	DIA	ETF	123.7	123.83	123.62	123.73	1120900.0
2007-01-09 13:00:00	DIA	ETF	123.73	124.04	123.71	123.9	801900.0
2007-01-09 14:00:00	DIA	ETF	123.9	124.14	123.82	124.01	803800.0
2007-01-09 15:00:00	DIA	ETF	124.0	124.24	123.91	124.11	1006400.0
2007-01-09 16:00:00	DIA	ETF	124.11	124.19	124.06	124.17	56100.0
2007-01-09 17:00:00	DIA	ETF	124.14	124.14	124.14	124.14	800.0

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

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