PREVIEW / etf_1hour / 2002-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-07-01.parquet
  size:    14 KB
  rows:    311

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-07-01 09:00:00	SPY	ETF	99.18	99.8	99.09	99.48	1788200.0
2002-07-01 10:00:00	SPY	ETF	99.47	99.77	98.8	99.09	2392400.0
2002-07-01 11:00:00	SPY	ETF	99.12	99.15	98.52	98.56	1932200.0
2002-07-01 12:00:00	SPY	ETF	98.55	98.65	98.17	98.37	2253700.0
2002-07-01 13:00:00	SPY	ETF	98.37	98.8	98.05	98.62	1904500.0
2002-07-01 14:00:00	SPY	ETF	98.66	98.79	97.95	98.04	2660300.0
2002-07-01 15:00:00	SPY	ETF	98.01	98.07	96.95	97.0	4950300.0
2002-07-01 16:00:00	SPY	ETF	97.06	97.24	96.85	97.2	1866600.0
2002-07-01 17:00:00	SPY	ETF	97.15	97.23	96.8	97.17	30800.0
2002-07-01 18:00:00	SPY	ETF	97.19	97.19	97.15	97.19	1600.0
2002-07-01 09:00:00	QQQ	ETF	25.97	26.14	25.83	26.01	9392000.0
2002-07-01 10:00:00	QQQ	ETF	26.03	26.1	25.65	25.75	11176600.0
2002-07-01 11:00:00	QQQ	ETF	25.76	25.8	25.4	25.42	8560800.0
2002-07-01 12:00:00	QQQ	ETF	25.41	25.51	25.32	25.44	6955700.0
2002-07-01 13:00:00	QQQ	ETF	25.42	25.6	25.3	25.47	5749800.0
2002-07-01 14:00:00	QQQ	ETF	25.47	25.56	25.17	25.18	7197200.0
2002-07-01 15:00:00	QQQ	ETF	25.18	25.2	24.81	24.86	11970400.0
2002-07-01 16:00:00	QQQ	ETF	24.84	26.75	24.75	24.85	2539300.0
2002-07-01 17:00:00	QQQ	ETF	24.85	24.87	24.8	24.83	72000.0
2002-07-01 18:00:00	QQQ	ETF	24.82	24.84	24.8	24.83	20900.0
2002-07-01 09:00:00	IWM	ETF	45.45	45.8	45.35	45.53	133200.0
2002-07-01 10:00:00	IWM	ETF	45.53	45.625	45.175	45.39	384200.0
2002-07-01 11:00:00	IWM	ETF	45.345	45.35	45.055	45.08	180600.0
2002-07-01 12:00:00	IWM	ETF	45.075	45.14	44.88	45.105	229800.0
2002-07-01 13:00:00	IWM	ETF	45.1	45.14	44.97	45.075	234400.0
2002-07-01 14:00:00	IWM	ETF	45.035	45.095	44.795	44.795	93600.0
2002-07-01 15:00:00	IWM	ETF	44.805	44.805	44.35	44.395	419400.0
2002-07-01 16:00:00	IWM	ETF	44.415	44.65	44.3	44.4	40200.0
2002-07-01 09:00:00	DIA	ETF	92.67	93.37	92.6	93.16	573200.0
2002-07-01 10:00:00	DIA	ETF	93.15	93.3	92.62	92.96	470600.0
2002-07-01 11:00:00	DIA	ETF	92.95	92.99	92.4	92.5	349100.0
2002-07-01 12:00:00	DIA	ETF	92.5	92.55	92.22	92.31	419100.0
2002-07-01 13:00:00	DIA	ETF	92.32	92.68	92.0	92.55	411700.0
2002-07-01 14:00:00	DIA	ETF	92.55	92.73	91.99	92.07	470100.0
2002-07-01 15:00:00	DIA	ETF	92.09	92.14	91.1	91.24	1238800.0
2002-07-01 16:00:00	DIA	ETF	91.21	91.26	91.0	91.06	119500.0
2002-07-01 18:00:00	DIA	ETF	91.1	91.1	91.1	91.1	200.0

> showing 37 of 311 rows — these rows as CSV

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