PREVIEW / etf_1hour / 2003-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-14.parquet
  size:    17 KB
  rows:    405

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-14 08:00:00	SPY	ETF	99.3	99.34	99.03	99.05	57600.0
2003-08-14 09:00:00	SPY	ETF	99.03	99.153	98.509	98.72	3609700.0
2003-08-14 10:00:00	SPY	ETF	98.72	99.429	98.63	99.35	5683800.0
2003-08-14 11:00:00	SPY	ETF	99.36	99.5	99.24	99.39	2004700.0
2003-08-14 12:00:00	SPY	ETF	99.37	99.75	99.2	99.32	4968900.0
2003-08-14 13:00:00	SPY	ETF	99.32	99.47	99.23	99.41	1765900.0
2003-08-14 14:00:00	SPY	ETF	99.41	99.599	99.21	99.57	2981100.0
2003-08-14 15:00:00	SPY	ETF	99.55	99.62	99.26	99.54	4759000.0
2003-08-14 16:00:00	SPY	ETF	99.55	99.63	97.99	98.5	3885800.0
2003-08-14 18:00:00	SPY	ETF	98.72	98.94	98.67	98.79	110100.0
2003-08-14 19:00:00	SPY	ETF	98.79	98.87	98.7	98.87	5400.0
2003-08-14 08:00:00	QQQ	ETF	30.94	31.0	30.87	30.88	189900.0
2003-08-14 09:00:00	QQQ	ETF	30.89	30.94	30.67	30.76	5044900.0
2003-08-14 10:00:00	QQQ	ETF	30.748	31.01	30.69	30.979	6702800.0
2003-08-14 11:00:00	QQQ	ETF	30.979	31.03	30.91	30.98	4792700.0
2003-08-14 12:00:00	QQQ	ETF	30.98	31.19	30.97	31.056	7738900.0
2003-08-14 13:00:00	QQQ	ETF	31.06	31.11	30.98	31.05	3444700.0
2003-08-14 14:00:00	QQQ	ETF	31.065	31.164	30.99	31.163	4054900.0
2003-08-14 15:00:00	QQQ	ETF	31.159	31.18	31.02	31.14	7776400.0
2003-08-14 16:00:00	QQQ	ETF	31.13	31.17	30.35	30.67	4989500.0
2003-08-14 18:00:00	QQQ	ETF	30.73	30.82	30.71	30.75	297900.0
2003-08-14 19:00:00	QQQ	ETF	30.8	30.8	30.71	30.74	28700.0
2003-08-14 09:00:00	IWM	ETF	46.715	46.75	46.515	46.63	202600.0
2003-08-14 10:00:00	IWM	ETF	46.635	46.76	46.615	46.725	982600.0
2003-08-14 11:00:00	IWM	ETF	46.725	46.875	46.695	46.84	410200.0
2003-08-14 12:00:00	IWM	ETF	46.835	46.955	46.77	46.815	371800.0
2003-08-14 13:00:00	IWM	ETF	46.81	46.88	46.81	46.835	165400.0
2003-08-14 14:00:00	IWM	ETF	46.85	46.96	46.8	46.96	94200.0
2003-08-14 15:00:00	IWM	ETF	46.95	47.0	46.84	47.0	331000.0
2003-08-14 16:00:00	IWM	ETF	47.042	47.14	47.02	47.02	204400.0
2003-08-14 08:00:00	DIA	ETF	93.26	93.3	93.0	93.0	15100.0
2003-08-14 09:00:00	DIA	ETF	93.01	93.06	92.41	92.65	834200.0
2003-08-14 10:00:00	DIA	ETF	92.61	93.31	92.55	93.2	1090000.0
2003-08-14 11:00:00	DIA	ETF	93.2	93.39	93.12	93.28	607500.0
2003-08-14 12:00:00	DIA	ETF	93.29	93.58	93.08	93.23	832300.0
2003-08-14 13:00:00	DIA	ETF	93.2	93.35	93.14	93.28	226200.0
2003-08-14 14:00:00	DIA	ETF	93.3	93.39	93.07	93.39	566700.0
2003-08-14 15:00:00	DIA	ETF	93.36	93.4	93.08	93.31	827900.0
2003-08-14 16:00:00	DIA	ETF	93.31	93.41	92.46	92.46	330400.0
2003-08-14 18:00:00	DIA	ETF	92.8	92.95	92.8	92.95	1700.0
2003-08-14 19:00:00	DIA	ETF	92.86	92.86	92.8	92.8	300.0
2003-08-14 09:00:00	TLT	ETF	81.44	81.65	81.32	81.58	238500.0
2003-08-14 10:00:00	TLT	ETF	81.58	81.85	81.58	81.67	390300.0
2003-08-14 11:00:00	TLT	ETF	81.6	81.6	81.36	81.45	127400.0
2003-08-14 12:00:00	TLT	ETF	81.5	81.5	80.91	81.07	229100.0
2003-08-14 13:00:00	TLT	ETF	81.07	81.59	81.07	81.55	81500.0
2003-08-14 14:00:00	TLT	ETF	81.52	81.63	81.35	81.6	75900.0
2003-08-14 15:00:00	TLT	ETF	81.65	82.1	81.63	82.07	240600.0
2003-08-14 16:00:00	TLT	ETF	82.09	82.1	82.05	82.1	55800.0

> showing 49 of 405 rows — these rows as CSV

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