PREVIEW / etf_1hour / 2007-03-01

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-01.parquet
  size:    69 KB
  rows:    2,123

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-01 04:00:00	SPY	ETF	141.0	141.36	141.0	141.36	2100.0
2007-03-01 05:00:00	SPY	ETF	141.22	141.45	141.22	141.45	500.0
2007-03-01 06:00:00	SPY	ETF	141.19	141.19	140.9	140.9	38000.0
2007-03-01 07:00:00	SPY	ETF	140.98	140.98	139.75	139.75	3838800.0
2007-03-01 08:00:00	SPY	ETF	139.75	141.25	139.19	139.73	13315200.0
2007-03-01 09:00:00	SPY	ETF	139.74	139.78	138.05	138.84	36576310.0
2007-03-01 10:00:00	SPY	ETF	138.84	141.0	138.77	140.35	61522271.0
2007-03-01 11:00:00	SPY	ETF	140.36	141.16	140.17	140.48	29851869.0
2007-03-01 12:00:00	SPY	ETF	140.48	140.85	140.24	140.78	10975546.0
2007-03-01 13:00:00	SPY	ETF	140.78	140.94	140.3	140.88	8918800.0
2007-03-01 14:00:00	SPY	ETF	140.92	141.25	140.72	141.08	15579000.0
2007-03-01 15:00:00	SPY	ETF	141.09	141.13	140.3	140.59	22331200.0
2007-03-01 16:00:00	SPY	ETF	140.59	140.67	140.51	140.6	1786400.0
2007-03-01 17:00:00	SPY	ETF	140.54	140.56	140.51	140.52	81600.0
2007-03-01 18:00:00	SPY	ETF	140.55	140.61	140.55	140.61	12000.0
2007-03-01 19:00:00	SPY	ETF	140.64	140.85	140.56	140.56	12400.0
2007-03-01 04:00:00	QQQ	ETF	43.47	43.47	43.47	43.47	1835.0
2007-03-01 06:00:00	QQQ	ETF	43.45	43.45	43.45	43.45	100.0
2007-03-01 07:00:00	QQQ	ETF	43.35	43.36	42.85	42.85	1860265.0
2007-03-01 08:00:00	QQQ	ETF	42.87	43.55	42.55	42.7	7990357.0
2007-03-01 09:00:00	QQQ	ETF	42.7	42.77	42.24	42.7	49957321.0
2007-03-01 10:00:00	QQQ	ETF	42.7	43.28	42.69	43.14	55121900.0
2007-03-01 11:00:00	QQQ	ETF	43.14	43.43	42.96	43.18	36498700.0
2007-03-01 12:00:00	QQQ	ETF	43.18	43.31	43.05	43.3	16211900.0
2007-03-01 13:00:00	QQQ	ETF	43.29	43.38	43.1	43.32	9657200.0
2007-03-01 14:00:00	QQQ	ETF	43.37	43.54	43.27	43.41	19174800.0
2007-03-01 15:00:00	QQQ	ETF	43.42	43.43	43.08	43.13	32035600.0
2007-03-01 16:00:00	QQQ	ETF	43.14	43.17	43.06	43.075	3786587.0
2007-03-01 17:00:00	QQQ	ETF	43.1	43.11	43.09	43.1	73960.0
2007-03-01 18:00:00	QQQ	ETF	43.1	43.15	43.1	43.15	126016.0
2007-03-01 19:00:00	QQQ	ETF	43.15	43.18	43.09	43.09	34891.0
2007-03-01 07:00:00	IWM	ETF	78.16	78.16	78.06	78.06	1000.0
2007-03-01 08:00:00	IWM	ETF	78.62	78.83	77.4	77.8	2686400.0
2007-03-01 09:00:00	IWM	ETF	77.85	77.85	76.75	77.67	19238193.0
2007-03-01 10:00:00	IWM	ETF	77.22	78.56	77.22	78.42	21941686.0
2007-03-01 11:00:00	IWM	ETF	78.39	78.6	77.8	78.21	13039175.0
2007-03-01 12:00:00	IWM	ETF	78.33	78.5	78.06	78.48	6434592.0
2007-03-01 13:00:00	IWM	ETF	78.47	78.75	78.35	78.74	8288900.0
2007-03-01 14:00:00	IWM	ETF	78.74	79.1	78.62	78.92	12076900.0
2007-03-01 15:00:00	IWM	ETF	78.92	78.97	78.42	78.48	12466200.0
2007-03-01 16:00:00	IWM	ETF	78.49	78.53	78.41	78.42	332200.0
2007-03-01 17:00:00	IWM	ETF	78.42	78.45	78.4	78.4	26500.0
2007-03-01 18:00:00	IWM	ETF	78.43	78.43	78.43	78.43	3000.0
2007-03-01 19:00:00	IWM	ETF	78.45	78.48	78.45	78.48	1200.0
2007-03-01 07:00:00	DIA	ETF	122.53	122.78	121.7	122.4	168200.0
2007-03-01 08:00:00	DIA	ETF	121.92	122.13	121.31	121.62	823800.0
2007-03-01 09:00:00	DIA	ETF	121.7	121.7	120.05	120.79	4511556.0
2007-03-01 10:00:00	DIA	ETF	120.8	122.54	120.8	122.19	7938399.0
2007-03-01 11:00:00	DIA	ETF	122.17	122.71	121.76	122.38	4002194.0
2007-03-01 12:00:00	DIA	ETF	122.37	122.54	122.03	122.48	1580838.0

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

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