PREVIEW / etf_1hour / 2003-08-13

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-13.parquet
  size:    17 KB
  rows:    404

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-08-13 08:00:00	SPY	ETF	99.56	99.86	99.5	99.81	66700.0
2003-08-13 09:00:00	SPY	ETF	99.84	99.88	99.21	99.32	5161100.0
2003-08-13 10:00:00	SPY	ETF	99.33	99.52	98.93	98.949	6490400.0
2003-08-13 11:00:00	SPY	ETF	98.93	99.08	98.74	98.808	4742000.0
2003-08-13 12:00:00	SPY	ETF	98.81	99.15	98.75	99.09	2659300.0
2003-08-13 13:00:00	SPY	ETF	99.09	99.25	99.03	99.07	3629800.0
2003-08-13 14:00:00	SPY	ETF	99.08	99.35	98.99	99.11	2638700.0
2003-08-13 15:00:00	SPY	ETF	99.11	99.15	98.53	98.89	5625000.0
2003-08-13 16:00:00	SPY	ETF	98.89	99.1	98.87	98.989	2175200.0
2003-08-13 17:00:00	SPY	ETF	98.99	98.99	98.97	98.98	10200.0
2003-08-13 18:00:00	SPY	ETF	98.97	99.0	98.95	99.0	2200.0
2003-08-13 19:00:00	SPY	ETF	99.03	99.03	99.0	99.01	1500.0
2003-08-13 08:00:00	QQQ	ETF	30.83	31.03	30.83	31.01	220900.0
2003-08-13 09:00:00	QQQ	ETF	31.0	31.04	30.78	30.85	7775900.0
2003-08-13 10:00:00	QQQ	ETF	30.851	31.03	30.76	30.78	10347900.0
2003-08-13 11:00:00	QQQ	ETF	30.782	30.82	30.65	30.69	7596900.0
2003-08-13 12:00:00	QQQ	ETF	30.68	30.84	30.67	30.83	4009300.0
2003-08-13 13:00:00	QQQ	ETF	30.82	30.95	30.78	30.838	5757200.0
2003-08-13 14:00:00	QQQ	ETF	30.85	31.066	30.81	30.97	7143400.0
2003-08-13 15:00:00	QQQ	ETF	30.967	30.98	30.68	30.82	8961300.0
2003-08-13 16:00:00	QQQ	ETF	30.82	30.92	30.81	30.87	1025500.0
2003-08-13 17:00:00	QQQ	ETF	30.87	30.884	30.82	30.83	478400.0
2003-08-13 18:00:00	QQQ	ETF	30.83	30.85	30.82	30.85	8500.0
2003-08-13 19:00:00	QQQ	ETF	30.86	30.86	30.84	30.85	3500.0
2003-08-13 09:00:00	IWM	ETF	46.65	46.705	46.57	46.595	640200.0
2003-08-13 10:00:00	IWM	ETF	46.6	46.74	46.515	46.515	2140000.0
2003-08-13 11:00:00	IWM	ETF	46.51	46.595	46.47	46.48	1173000.0
2003-08-13 12:00:00	IWM	ETF	46.485	46.59	46.4	46.585	630600.0
2003-08-13 13:00:00	IWM	ETF	46.57	46.675	46.55	46.645	678400.0
2003-08-13 14:00:00	IWM	ETF	46.64	46.775	46.625	46.755	448400.0
2003-08-13 15:00:00	IWM	ETF	46.75	46.75	46.53	46.57	1280200.0
2003-08-13 16:00:00	IWM	ETF	46.6	46.84	46.6	46.815	241600.0
2003-08-13 08:00:00	DIA	ETF	93.24	93.52	93.16	93.44	10800.0
2003-08-13 09:00:00	DIA	ETF	93.5	93.65	92.99	93.1	1315100.0
2003-08-13 10:00:00	DIA	ETF	93.07	93.23	92.76	92.76	1625200.0
2003-08-13 11:00:00	DIA	ETF	92.78	92.95	92.68	92.76	1071300.0
2003-08-13 12:00:00	DIA	ETF	92.76	93.04	92.68	92.99	390000.0
2003-08-13 13:00:00	DIA	ETF	92.98	93.15	92.95	93.01	350000.0
2003-08-13 14:00:00	DIA	ETF	92.98	93.24	92.93	93.05	430700.0
2003-08-13 15:00:00	DIA	ETF	93.031	93.05	92.55	92.89	1195500.0
2003-08-13 16:00:00	DIA	ETF	92.88	93.08	92.86	92.99	159300.0
2003-08-13 17:00:00	DIA	ETF	93.0	93.02	93.0	93.02	300.0
2003-08-13 18:00:00	DIA	ETF	92.95	92.95	92.87	92.93	1900.0
2003-08-13 09:00:00	TLT	ETF	82.2	82.35	82.1	82.29	350700.0
2003-08-13 10:00:00	TLT	ETF	82.297	82.3	81.56	81.75	546300.0
2003-08-13 11:00:00	TLT	ETF	81.75	81.75	81.25	81.3	464200.0
2003-08-13 12:00:00	TLT	ETF	81.32	81.66	81.2	81.59	285500.0
2003-08-13 13:00:00	TLT	ETF	81.6	81.79	81.56	81.78	140400.0
2003-08-13 14:00:00	TLT	ETF	81.75	81.75	81.3	81.37	90900.0
2003-08-13 15:00:00	TLT	ETF	81.37	81.38	81.19	81.3	191700.0

> showing 50 of 404 rows — these rows as CSV

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