PREVIEW / etf_1hour / 2003-06-27

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-27.parquet
  size:    17 KB
  rows:    412

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-27 08:00:00	SPY	ETF	98.86	98.91	98.84	98.85	44200.0
2003-06-27 09:00:00	SPY	ETF	98.84	98.85	98.2	98.4	6190200.0
2003-06-27 10:00:00	SPY	ETF	98.4	99.15	98.312	99.126	6402200.0
2003-06-27 11:00:00	SPY	ETF	99.12	99.19	98.68	98.76	9165100.0
2003-06-27 12:00:00	SPY	ETF	98.76	98.89	98.64	98.7	1437100.0
2003-06-27 13:00:00	SPY	ETF	98.79	98.88	97.75	98.0	7739400.0
2003-06-27 14:00:00	SPY	ETF	98.02	98.18	97.9	98.12	4411100.0
2003-06-27 15:00:00	SPY	ETF	98.12	98.17	97.66	97.86	4161300.0
2003-06-27 16:00:00	SPY	ETF	97.85	97.892	97.58	97.67	1988900.0
2003-06-27 17:00:00	SPY	ETF	97.67	97.67	97.64	97.64	8800.0
2003-06-27 18:00:00	SPY	ETF	97.63	97.71	97.63	97.71	3500.0
2003-06-27 19:00:00	SPY	ETF	97.71	97.73	97.71	97.72	2500.0
2003-06-27 08:00:00	QQQ	ETF	30.28	30.3	30.25	30.29	122100.0
2003-06-27 09:00:00	QQQ	ETF	30.28	30.39	30.16	30.24	9002500.0
2003-06-27 10:00:00	QQQ	ETF	30.238	30.55	30.2	30.53	12514200.0
2003-06-27 11:00:00	QQQ	ETF	30.55	30.57	30.292	30.33	7661500.0
2003-06-27 12:00:00	QQQ	ETF	30.334	30.43	30.27	30.31	7968100.0
2003-06-27 13:00:00	QQQ	ETF	30.32	30.36	29.772	29.98	16421300.0
2003-06-27 14:00:00	QQQ	ETF	29.97	30.09	29.9	30.03	6700400.0
2003-06-27 15:00:00	QQQ	ETF	30.02	30.05	29.83	30.0	10735200.0
2003-06-27 16:00:00	QQQ	ETF	29.98	29.99	29.81	29.87	1678400.0
2003-06-27 17:00:00	QQQ	ETF	29.86	29.91	29.85	29.9	140100.0
2003-06-27 18:00:00	QQQ	ETF	29.9	29.93	29.88	29.9	79500.0
2003-06-27 19:00:00	QQQ	ETF	29.91	29.92	29.89	29.9	16100.0
2003-06-27 09:00:00	IWM	ETF	45.0	45.195	44.96	45.17	477200.0
2003-06-27 10:00:00	IWM	ETF	45.17	45.445	45.105	45.355	1306000.0
2003-06-27 11:00:00	IWM	ETF	45.35	45.39	45.075	45.095	697800.0
2003-06-27 12:00:00	IWM	ETF	45.075	45.14	45.05	45.085	365200.0
2003-06-27 13:00:00	IWM	ETF	45.08	45.11	44.825	44.87	1054000.0
2003-06-27 14:00:00	IWM	ETF	44.87	45.005	44.845	44.955	380400.0
2003-06-27 15:00:00	IWM	ETF	44.95	44.95	44.585	44.785	977200.0
2003-06-27 16:00:00	IWM	ETF	44.81	44.81	44.35	44.57	600800.0
2003-06-27 08:00:00	DIA	ETF	91.03	91.04	90.91	90.98	20100.0
2003-06-27 09:00:00	DIA	ETF	90.96	90.96	90.3	90.51	793600.0
2003-06-27 10:00:00	DIA	ETF	90.51	91.18	90.42	91.168	1684200.0
2003-06-27 11:00:00	DIA	ETF	91.17	91.2	90.84	90.89	581500.0
2003-06-27 12:00:00	DIA	ETF	90.85	91.0	90.77	90.91	447900.0
2003-06-27 13:00:00	DIA	ETF	90.92	90.99	89.98	90.19	1193900.0
2003-06-27 14:00:00	DIA	ETF	90.2	90.34	90.11	90.27	371500.0
2003-06-27 15:00:00	DIA	ETF	90.26	90.31	89.8	90.04	1267500.0
2003-06-27 16:00:00	DIA	ETF	90.03	90.03	89.8	89.89	104700.0
2003-06-27 17:00:00	DIA	ETF	89.87	89.89	89.87	89.89	300.0
2003-06-27 18:00:00	DIA	ETF	89.89	89.9	89.85	89.85	1100.0
2003-06-27 19:00:00	DIA	ETF	89.9	89.98	89.9	89.98	4500.0
2003-06-27 09:00:00	TLT	ETF	92.55	92.55	92.31	92.31	65700.0
2003-06-27 10:00:00	TLT	ETF	92.27	92.38	92.13	92.25	142800.0
2003-06-27 11:00:00	TLT	ETF	92.19	92.19	91.67	91.86	68400.0
2003-06-27 12:00:00	TLT	ETF	91.8	91.9	91.59	91.62	109100.0
2003-06-27 13:00:00	TLT	ETF	91.55	91.8	91.55	91.8	97300.0
2003-06-27 14:00:00	TLT	ETF	91.8	91.9	91.58	91.81	65000.0

> showing 50 of 412 rows — these rows as CSV

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