PREVIEW / etf_1hour / 2003-11-12

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-12.parquet
  size:    19 KB
  rows:    481

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-11-12 08:00:00	SPY	ETF	105.27	105.32	105.25	105.27	20000.0
2003-11-12 09:00:00	SPY	ETF	105.27	105.5	105.16	105.41	2946500.0
2003-11-12 10:00:00	SPY	ETF	105.41	105.62	105.36	105.44	3105300.0
2003-11-12 11:00:00	SPY	ETF	105.44	105.84	105.41	105.81	3159200.0
2003-11-12 12:00:00	SPY	ETF	105.75	105.91	105.74	105.77	3345800.0
2003-11-12 13:00:00	SPY	ETF	105.77	106.0	105.75	105.87	1652900.0
2003-11-12 14:00:00	SPY	ETF	105.86	106.45	105.84	106.4	4120300.0
2003-11-12 15:00:00	SPY	ETF	106.45	106.47	106.18	106.38	4993500.0
2003-11-12 16:00:00	SPY	ETF	106.38	106.45	106.21	106.45	1827200.0
2003-11-12 17:00:00	SPY	ETF	106.48	106.55	106.45	106.48	45100.0
2003-11-12 18:00:00	SPY	ETF	106.48	106.49	106.4	106.4	20700.0
2003-11-12 08:00:00	QQQ	ETF	35.19	35.19	35.13	35.14	88300.0
2003-11-12 09:00:00	QQQ	ETF	35.14	35.371	35.13	35.3	12243500.0
2003-11-12 10:00:00	QQQ	ETF	35.3	35.41	35.26	35.31	12389200.0
2003-11-12 11:00:00	QQQ	ETF	35.3	35.49	35.257	35.485	9534900.0
2003-11-12 12:00:00	QQQ	ETF	35.485	35.56	35.46	35.47	6462400.0
2003-11-12 13:00:00	QQQ	ETF	35.48	35.68	35.47	35.6	5946200.0
2003-11-12 14:00:00	QQQ	ETF	35.59	35.87	35.57	35.84	9938100.0
2003-11-12 15:00:00	QQQ	ETF	35.84	35.881	35.7	35.83	11595100.0
2003-11-12 16:00:00	QQQ	ETF	35.84	36.02	35.62	36.01	6550000.0
2003-11-12 17:00:00	QQQ	ETF	36.01	36.1	35.992	36.012	1317400.0
2003-11-12 18:00:00	QQQ	ETF	36.02	36.036	35.98	35.99	63400.0
2003-11-12 19:00:00	QQQ	ETF	35.99	35.99	35.96	35.97	38000.0
2003-11-12 09:00:00	IWM	ETF	52.84	53.35	52.84	53.28	1522200.0
2003-11-12 10:00:00	IWM	ETF	53.29	53.444	53.155	53.325	1027800.0
2003-11-12 11:00:00	IWM	ETF	53.355	53.56	53.325	53.55	1035800.0
2003-11-12 12:00:00	IWM	ETF	53.535	53.675	53.535	53.56	1083600.0
2003-11-12 13:00:00	IWM	ETF	53.56	53.675	53.558	53.58	319600.0
2003-11-12 14:00:00	IWM	ETF	53.58	53.82	53.55	53.82	524600.0
2003-11-12 15:00:00	IWM	ETF	53.83	53.95	53.59	53.935	1099400.0
2003-11-12 16:00:00	IWM	ETF	53.95	54.02	53.85	54.02	548600.0
2003-11-12 17:00:00	IWM	ETF	53.952	53.952	53.94	53.94	7000.0
2003-11-12 08:00:00	DIA	ETF	97.69	97.76	97.68	97.76	1900.0
2003-11-12 09:00:00	DIA	ETF	97.72	97.97	97.66	97.9	975300.0
2003-11-12 10:00:00	DIA	ETF	97.92	98.012	97.81	97.87	509000.0
2003-11-12 11:00:00	DIA	ETF	97.92	98.37	97.87	98.37	816600.0
2003-11-12 12:00:00	DIA	ETF	98.3	98.43	98.27	98.29	835100.0
2003-11-12 13:00:00	DIA	ETF	98.32	98.48	98.28	98.34	513000.0
2003-11-12 14:00:00	DIA	ETF	98.36	98.94	98.34	98.93	760700.0
2003-11-12 15:00:00	DIA	ETF	98.93	98.95	98.72	98.85	1082800.0
2003-11-12 16:00:00	DIA	ETF	98.86	98.95	98.78	98.95	136900.0
2003-11-12 17:00:00	DIA	ETF	98.96	98.98	98.96	98.98	1600.0
2003-11-12 18:00:00	DIA	ETF	98.95	98.98	98.95	98.98	300.0
2003-11-12 19:00:00	DIA	ETF	98.99	98.99	98.99	98.99	400.0
2003-11-12 09:00:00	TLT	ETF	83.86	83.93	83.79	83.9	78100.0
2003-11-12 10:00:00	TLT	ETF	83.9	84.0	83.87	83.94	58100.0
2003-11-12 11:00:00	TLT	ETF	83.92	83.95	83.83	83.9	30400.0
2003-11-12 12:00:00	TLT	ETF	83.95	84.1	83.93	84.06	36300.0
2003-11-12 13:00:00	TLT	ETF	84.08	84.15	84.0	84.05	13700.0
2003-11-12 14:00:00	TLT	ETF	83.98	84.06	83.87	83.95	21600.0

> showing 50 of 481 rows — these rows as CSV

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