PREVIEW / etf_1hour / 2007-03-05

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-05.parquet
  size:    82 KB
  rows:    2,562

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-03-05 04:00:00	SPY	ETF	137.99	137.99	137.65	137.72	20000.0
2007-03-05 05:00:00	SPY	ETF	137.69	137.69	137.41	137.45	33500.0
2007-03-05 06:00:00	SPY	ETF	137.61	137.81	137.53	137.79	118800.0
2007-03-05 07:00:00	SPY	ETF	137.75	137.81	137.39	137.72	1890100.0
2007-03-05 08:00:00	SPY	ETF	137.7	138.55	137.42	138.07	5723800.0
2007-03-05 09:00:00	SPY	ETF	138.08	138.86	137.82	138.85	21682201.0
2007-03-05 10:00:00	SPY	ETF	138.85	139.58	138.31	139.09	28528000.0
2007-03-05 11:00:00	SPY	ETF	139.1	139.52	138.57	138.59	17854100.0
2007-03-05 12:00:00	SPY	ETF	138.59	138.71	138.15	138.4	13014800.0
2007-03-05 13:00:00	SPY	ETF	138.41	139.0	138.28	138.86	9357600.0
2007-03-05 14:00:00	SPY	ETF	138.86	139.09	138.55	138.65	10032400.0
2007-03-05 15:00:00	SPY	ETF	138.6475	139.014	137.66	137.69	26111900.0
2007-03-05 16:00:00	SPY	ETF	137.66	137.66	137.34	137.5	4451000.0
2007-03-05 17:00:00	SPY	ETF	137.5	139.7	137.17	137.699	721500.0
2007-03-05 18:00:00	SPY	ETF	138.079	139.299	137.08	137.68	473000.0
2007-03-05 19:00:00	SPY	ETF	137.67	139.02	137.67	137.87	589000.0
2007-03-05 04:00:00	QQQ	ETF	42.05	42.05	42.02	42.03	1300.0
2007-03-05 05:00:00	QQQ	ETF	42.03	42.03	41.96	41.96	1700.0
2007-03-05 06:00:00	QQQ	ETF	41.96	42.08	41.94	42.08	84600.0
2007-03-05 07:00:00	QQQ	ETF	42.07	42.11	41.89	42.1	1103606.0
2007-03-05 08:00:00	QQQ	ETF	42.1	42.16	41.92	42.15	3655142.0
2007-03-05 09:00:00	QQQ	ETF	42.14	42.51	41.65	42.51	34811065.0
2007-03-05 10:00:00	QQQ	ETF	42.52	42.8	42.25	42.53	34765300.0
2007-03-05 11:00:00	QQQ	ETF	42.53	42.7	42.36	42.37	16868500.0
2007-03-05 12:00:00	QQQ	ETF	42.37	42.42	42.26	42.3	13455300.0
2007-03-05 13:00:00	QQQ	ETF	42.3	42.56	42.27	42.55	15431000.0
2007-03-05 14:00:00	QQQ	ETF	42.55	42.62	42.37	42.43	15855400.0
2007-03-05 15:00:00	QQQ	ETF	42.43	42.46	42.11	42.16	26916600.0
2007-03-05 16:00:00	QQQ	ETF	42.15	42.3	42.03	42.15	6266409.0
2007-03-05 17:00:00	QQQ	ETF	42.15	42.774	42.05	42.17	2121324.0
2007-03-05 18:00:00	QQQ	ETF	42.31	42.79	42.05	42.19	298210.0
2007-03-05 19:00:00	QQQ	ETF	42.19	42.31	42.19	42.3	2643579.0
2007-03-05 05:00:00	IWM	ETF	76.26	76.26	76.26	76.26	200.0
2007-03-05 07:00:00	IWM	ETF	76.03	76.04	75.8	75.87	220800.0
2007-03-05 08:00:00	IWM	ETF	75.85	78.89	75.77	76.05	2037400.0
2007-03-05 09:00:00	IWM	ETF	76.05	76.81	75.84	76.8	14378300.0
2007-03-05 10:00:00	IWM	ETF	76.8	77.29	76.35	76.66	20025600.0
2007-03-05 11:00:00	IWM	ETF	76.65	76.95	76.27	76.28	13655600.0
2007-03-05 12:00:00	IWM	ETF	76.28	76.56	75.93	75.98	17957100.0
2007-03-05 13:00:00	IWM	ETF	75.99	76.42	75.86	76.365	13435900.0
2007-03-05 14:00:00	IWM	ETF	76.35	77.0225	75.99	76.29	14665600.0
2007-03-05 15:00:00	IWM	ETF	76.29	77.0234	75.45	75.45	20415217.0
2007-03-05 16:00:00	IWM	ETF	75.45	76.1	75.16	75.34	1915400.0
2007-03-05 17:00:00	IWM	ETF	75.29	75.29	75.11	75.15	94700.0
2007-03-05 18:00:00	IWM	ETF	75.11	75.28	74.97	75.28	32000.0
2007-03-05 19:00:00	IWM	ETF	75.33	76.84	75.33	75.52	202900.0
2007-03-05 07:00:00	DIA	ETF	119.88	120.17	119.82	120.06	111700.0
2007-03-05 08:00:00	DIA	ETF	119.93	120.66	119.93	120.57	752100.0
2007-03-05 09:00:00	DIA	ETF	120.57	121.48	120.28	121.39	3141100.0
2007-03-05 10:00:00	DIA	ETF	121.39	121.82	120.87	121.54	3020100.0

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

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