PREVIEW / etf_1hour / 2003-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-30.parquet
  size:    17 KB
  rows:    427

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-06-30 08:00:00	SPY	ETF	98.29	98.34	98.24	98.26	15000.0
2003-06-30 09:00:00	SPY	ETF	98.25	98.669	98.18	98.426	4106200.0
2003-06-30 10:00:00	SPY	ETF	98.442	98.58	97.82	98.07	4755800.0
2003-06-30 11:00:00	SPY	ETF	98.07	98.12	97.61	97.71	4932500.0
2003-06-30 12:00:00	SPY	ETF	97.7	98.09	97.59	98.05	1936400.0
2003-06-30 13:00:00	SPY	ETF	98.05	98.59	98.02	98.51	2593800.0
2003-06-30 14:00:00	SPY	ETF	98.52	98.6	98.093	98.21	3614300.0
2003-06-30 15:00:00	SPY	ETF	98.19	98.21	97.68	97.689	4682400.0
2003-06-30 16:00:00	SPY	ETF	97.697	97.93	97.47	97.64	3485500.0
2003-06-30 17:00:00	SPY	ETF	97.66	97.74	97.62	97.72	554600.0
2003-06-30 18:00:00	SPY	ETF	97.66	97.73	97.66	97.68	27700.0
2003-06-30 19:00:00	SPY	ETF	97.71	97.74	97.71	97.74	400.0
2003-06-30 08:00:00	QQQ	ETF	30.15	30.2	30.13	30.18	110800.0
2003-06-30 09:00:00	QQQ	ETF	30.16	30.34	30.12	30.154	9847400.0
2003-06-30 10:00:00	QQQ	ETF	30.15	30.25	29.91	30.044	11864200.0
2003-06-30 11:00:00	QQQ	ETF	30.03	30.11	29.88	29.9	6526100.0
2003-06-30 12:00:00	QQQ	ETF	29.89	30.02	29.8	29.99	7868400.0
2003-06-30 13:00:00	QQQ	ETF	29.98	30.16	29.96	30.1	5831600.0
2003-06-30 14:00:00	QQQ	ETF	30.097	30.13	29.92	29.98	5901600.0
2003-06-30 15:00:00	QQQ	ETF	29.98	30.01	29.84	29.85	13043700.0
2003-06-30 16:00:00	QQQ	ETF	29.85	29.97	29.82	29.92	2994200.0
2003-06-30 17:00:00	QQQ	ETF	29.92	29.93	29.91	29.91	54200.0
2003-06-30 18:00:00	QQQ	ETF	29.92	29.92	29.88	29.88	36100.0
2003-06-30 19:00:00	QQQ	ETF	29.9	29.9	29.86	29.9	9800.0
2003-06-30 08:00:00	IWM	ETF	44.87	44.88	44.87	44.88	3000.0
2003-06-30 09:00:00	IWM	ETF	44.845	45.155	44.745	44.94	624000.0
2003-06-30 10:00:00	IWM	ETF	44.93	44.93	44.535	44.58	809600.0
2003-06-30 11:00:00	IWM	ETF	44.615	44.655	44.505	44.51	737200.0
2003-06-30 12:00:00	IWM	ETF	44.505	44.665	44.475	44.595	508200.0
2003-06-30 13:00:00	IWM	ETF	44.595	44.745	44.595	44.69	559000.0
2003-06-30 14:00:00	IWM	ETF	44.725	44.735	44.5085	44.57	707600.0
2003-06-30 15:00:00	IWM	ETF	44.555	44.555	44.2	44.295	2733600.0
2003-06-30 16:00:00	IWM	ETF	44.295	44.64	44.15	44.45	1293600.0
2003-06-30 08:00:00	DIA	ETF	90.29	90.45	90.29	90.38	5300.0
2003-06-30 09:00:00	DIA	ETF	90.38	90.7	90.35	90.6	760600.0
2003-06-30 10:00:00	DIA	ETF	90.57	90.63	89.89	90.16	1133800.0
2003-06-30 11:00:00	DIA	ETF	90.15	90.24	89.8	89.9	416300.0
2003-06-30 12:00:00	DIA	ETF	89.89	90.34	89.79	90.32	397900.0
2003-06-30 13:00:00	DIA	ETF	90.3	90.78	90.3	90.67	802900.0
2003-06-30 14:00:00	DIA	ETF	90.76	90.78	90.35	90.5	649200.0
2003-06-30 15:00:00	DIA	ETF	90.45	90.46	89.97	89.97	738800.0
2003-06-30 16:00:00	DIA	ETF	89.99	90.0	89.8	89.9	173100.0
2003-06-30 17:00:00	DIA	ETF	89.94	89.94	89.86	89.87	1600.0
2003-06-30 18:00:00	DIA	ETF	89.93	89.93	89.93	89.93	500.0
2003-06-30 09:00:00	TLT	ETF	91.92	91.92	91.68	91.82	161000.0
2003-06-30 10:00:00	TLT	ETF	91.85	92.27	91.85	92.17	72300.0
2003-06-30 11:00:00	TLT	ETF	92.15	92.36	92.1	92.33	16200.0
2003-06-30 12:00:00	TLT	ETF	92.3	92.32	92.13	92.13	11200.0
2003-06-30 13:00:00	TLT	ETF	92.13	92.13	91.87	91.9	61500.0
2003-06-30 14:00:00	TLT	ETF	91.88	92.33	91.85	92.33	23800.0

> showing 50 of 427 rows — these rows as CSV

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