PREVIEW / etf_1hour / 2003-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-13.parquet
  size:    16 KB
  rows:    378

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
2003-01-13 08:00:00	SPY	ETF	93.96	93.96	93.67	93.8	54800.0
2003-01-13 09:00:00	SPY	ETF	93.74	93.85	93.4	93.66	4673700.0
2003-01-13 10:00:00	SPY	ETF	93.63	93.86	92.44	92.65	7705500.0
2003-01-13 11:00:00	SPY	ETF	92.62	92.94	92.47	92.92	3213200.0
2003-01-13 12:00:00	SPY	ETF	92.93	93.14	92.81	93.05	1529700.0
2003-01-13 13:00:00	SPY	ETF	93.05	93.17	92.82	93.08	1879200.0
2003-01-13 14:00:00	SPY	ETF	93.09	93.4	92.76	92.89	3719300.0
2003-01-13 15:00:00	SPY	ETF	92.92	93.11	92.73	92.85	4248500.0
2003-01-13 16:00:00	SPY	ETF	92.9	93.07	92.85	93.01	2307700.0
2003-01-13 17:00:00	SPY	ETF	93.03	93.05	92.98	93.03	25900.0
2003-01-13 18:00:00	SPY	ETF	93.03	93.54	92.97	92.97	2600.0
2003-01-13 19:00:00	SPY	ETF	93.0	93.0	93.0	93.0	400.0
2003-01-13 08:00:00	QQQ	ETF	27.39	27.5	27.36	27.47	156000.0
2003-01-13 09:00:00	QQQ	ETF	27.47	27.47	27.21	27.34	14471000.0
2003-01-13 10:00:00	QQQ	ETF	27.31	27.4	26.73	26.83	20550300.0
2003-01-13 11:00:00	QQQ	ETF	26.83	26.99	26.73	26.95	7244100.0
2003-01-13 12:00:00	QQQ	ETF	26.95	27.1	26.89	27.01	4988300.0
2003-01-13 13:00:00	QQQ	ETF	27.01	27.06	26.86	27.02	4688500.0
2003-01-13 14:00:00	QQQ	ETF	27.0	27.09	26.83	26.86	5943200.0
2003-01-13 15:00:00	QQQ	ETF	26.86	27.0	26.82	26.88	5943700.0
2003-01-13 16:00:00	QQQ	ETF	26.88	26.99	26.87	26.96	2182200.0
2003-01-13 17:00:00	QQQ	ETF	26.98	27.0	26.96	27.0	72200.0
2003-01-13 18:00:00	QQQ	ETF	27.0	27.33	26.99	27.0	55200.0
2003-01-13 19:00:00	QQQ	ETF	26.97	27.02	26.97	27.02	5000.0
2003-01-13 09:00:00	IWM	ETF	39.66	39.815	39.47	39.55	352200.0
2003-01-13 10:00:00	IWM	ETF	39.585	39.665	39.09	39.205	421800.0
2003-01-13 11:00:00	IWM	ETF	39.2	39.395	39.14	39.35	181600.0
2003-01-13 12:00:00	IWM	ETF	39.38	39.43	39.32	39.39	105000.0
2003-01-13 13:00:00	IWM	ETF	39.4	39.42	39.3	39.38	153400.0
2003-01-13 14:00:00	IWM	ETF	39.44	39.515	39.28	39.28	102800.0
2003-01-13 15:00:00	IWM	ETF	39.28	39.42	39.28	39.325	318000.0
2003-01-13 16:00:00	IWM	ETF	39.33	39.49	39.33	39.49	52600.0
2003-01-13 08:00:00	DIA	ETF	88.85	89.01	88.75	88.76	2600.0
2003-01-13 09:00:00	DIA	ETF	88.71	88.77	87.95	88.65	1177300.0
2003-01-13 10:00:00	DIA	ETF	88.59	88.88	87.58	87.8	1617900.0
2003-01-13 11:00:00	DIA	ETF	87.78	88.0	87.6	87.94	614900.0
2003-01-13 12:00:00	DIA	ETF	87.95	88.2	87.89	88.12	293600.0
2003-01-13 13:00:00	DIA	ETF	88.1	88.25	87.9	88.18	722900.0
2003-01-13 14:00:00	DIA	ETF	88.18	88.5	87.92	88.02	681800.0
2003-01-13 15:00:00	DIA	ETF	88.03	88.29	87.84	88.05	645800.0
2003-01-13 16:00:00	DIA	ETF	88.01	88.15	87.99	88.15	45900.0
2003-01-13 17:00:00	DIA	ETF	88.15	88.19	88.02	88.08	4600.0
2003-01-13 18:00:00	DIA	ETF	88.51	88.51	88.17	88.17	400.0
2003-01-13 09:00:00	TLT	ETF	85.54	85.56	85.44	85.5	17000.0
2003-01-13 10:00:00	TLT	ETF	85.43	85.82	85.4	85.75	25800.0
2003-01-13 11:00:00	TLT	ETF	85.8	85.87	85.67	85.85	4600.0
2003-01-13 12:00:00	TLT	ETF	85.65	85.67	85.6	85.67	500.0
2003-01-13 13:00:00	TLT	ETF	85.76	85.8	85.76	85.77	1600.0
2003-01-13 14:00:00	TLT	ETF	85.73	85.78	85.72	85.78	700.0
2003-01-13 15:00:00	TLT	ETF	85.61	85.75	85.6	85.75	2900.0

> showing 50 of 378 rows — these rows as CSV

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