PREVIEW / etf_1hour / 2002-12-09

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-12-09.parquet
  size:    16 KB
  rows:    383

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
2002-12-09 08:00:00	SPY	ETF	91.2	91.27	91.13	91.18	10800.0
2002-12-09 09:00:00	SPY	ETF	91.13	91.46	90.9	91.44	2972000.0
2002-12-09 10:00:00	SPY	ETF	91.41	91.44	90.76	90.82	4747600.0
2002-12-09 11:00:00	SPY	ETF	90.77	90.94	90.25	90.45	5337400.0
2002-12-09 12:00:00	SPY	ETF	90.45	90.57	90.19	90.54	2646900.0
2002-12-09 13:00:00	SPY	ETF	90.54	90.55	90.05	90.1	3618300.0
2002-12-09 14:00:00	SPY	ETF	90.1	90.75	90.1	90.4	3294000.0
2002-12-09 15:00:00	SPY	ETF	90.4	90.55	89.62	89.67	6968800.0
2002-12-09 16:00:00	SPY	ETF	89.73	89.84	89.35	89.57	2453500.0
2002-12-09 17:00:00	SPY	ETF	89.57	89.73	89.56	89.7	275400.0
2002-12-09 18:00:00	SPY	ETF	89.66	89.8	89.66	89.68	20700.0
2002-12-09 19:00:00	SPY	ETF	89.79	89.89	89.7	89.75	59800.0
2002-12-09 08:00:00	QQQ	ETF	26.23	26.26	26.16	26.18	66200.0
2002-12-09 09:00:00	QQQ	ETF	26.17	26.27	26.06	26.22	9765700.0
2002-12-09 10:00:00	QQQ	ETF	26.22	26.25	25.72	25.77	15111900.0
2002-12-09 11:00:00	QQQ	ETF	25.75	25.83	25.51	25.62	9524900.0
2002-12-09 12:00:00	QQQ	ETF	25.59	25.69	25.5	25.68	6391400.0
2002-12-09 13:00:00	QQQ	ETF	25.68	25.7	25.42	25.48	4918300.0
2002-12-09 14:00:00	QQQ	ETF	25.5	25.72	25.46	25.52	10163300.0
2002-12-09 15:00:00	QQQ	ETF	25.53	25.59	25.25	25.3	11811500.0
2002-12-09 16:00:00	QQQ	ETF	25.3	25.3	25.2	25.24	2232900.0
2002-12-09 17:00:00	QQQ	ETF	25.24	25.29	25.2	25.28	121700.0
2002-12-09 18:00:00	QQQ	ETF	25.26	25.37	25.26	25.35	70500.0
2002-12-09 19:00:00	QQQ	ETF	25.33	25.41	25.3	25.33	223400.0
2002-12-09 09:00:00	IWM	ETF	39.495	39.495	39.21	39.375	96400.0
2002-12-09 10:00:00	IWM	ETF	39.42	39.42	39.09	39.09	269200.0
2002-12-09 11:00:00	IWM	ETF	39.055	39.08	38.725	38.79	305000.0
2002-12-09 12:00:00	IWM	ETF	38.775	38.865	38.7	38.84	360000.0
2002-12-09 13:00:00	IWM	ETF	38.835	38.88	38.82	38.835	249000.0
2002-12-09 14:00:00	IWM	ETF	38.835	38.945	38.815	38.815	193400.0
2002-12-09 15:00:00	IWM	ETF	38.815	38.875	38.45	38.56	505600.0
2002-12-09 16:00:00	IWM	ETF	38.57	38.625	38.1	38.52	78800.0
2002-12-09 08:00:00	DIA	ETF	86.18	86.2	86.13	86.17	2200.0
2002-12-09 09:00:00	DIA	ETF	86.11	86.26	85.8	86.24	796200.0
2002-12-09 10:00:00	DIA	ETF	86.23	86.25	85.7	85.77	967400.0
2002-12-09 11:00:00	DIA	ETF	85.75	85.98	85.41	85.58	633400.0
2002-12-09 12:00:00	DIA	ETF	85.58	85.67	85.32	85.66	389700.0
2002-12-09 13:00:00	DIA	ETF	85.62	85.64	85.24	85.3	459900.0
2002-12-09 14:00:00	DIA	ETF	85.28	85.8	85.28	85.54	652600.0
2002-12-09 15:00:00	DIA	ETF	85.5	85.65	84.92	84.95	1241800.0
2002-12-09 16:00:00	DIA	ETF	84.93	84.96	84.6	84.83	142300.0
2002-12-09 17:00:00	DIA	ETF	84.8	84.83	84.5	84.8	8500.0
2002-12-09 18:00:00	DIA	ETF	84.8	84.8	84.71	84.71	600.0
2002-12-09 19:00:00	DIA	ETF	84.8	84.8	84.76	84.76	4800.0
2002-12-09 09:00:00	TLT	ETF	86.2	86.31	86.17	86.31	5400.0
2002-12-09 10:00:00	TLT	ETF	86.47	86.6	86.43	86.57	35800.0
2002-12-09 11:00:00	TLT	ETF	86.52	86.57	86.45	86.46	154700.0
2002-12-09 12:00:00	TLT	ETF	86.46	86.5	86.46	86.5	101400.0
2002-12-09 13:00:00	TLT	ETF	86.49	86.85	86.49	86.85	81600.0
2002-12-09 14:00:00	TLT	ETF	86.82	86.82	86.55	86.63	5400.0

> showing 50 of 383 rows — these rows as CSV

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