PREVIEW / etf_1hour / 2004-10-08

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-08.parquet
  size:    26 KB
  rows:    728

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
2004-10-08 08:00:00	SPY	ETF	113.7	113.83	113.04	113.1	1022400.0
2004-10-08 09:00:00	SPY	ETF	113.07	113.69	113.02	113.68	7759000.0
2004-10-08 10:00:00	SPY	ETF	113.68	113.69	113.05	113.13	10540100.0
2004-10-08 11:00:00	SPY	ETF	113.13	113.23	112.87	113.06	7926400.0
2004-10-08 12:00:00	SPY	ETF	113.06	113.2	112.98	113.17	2855200.0
2004-10-08 13:00:00	SPY	ETF	113.17	113.2	112.87	112.9	2860300.0
2004-10-08 14:00:00	SPY	ETF	112.91	112.94	112.38	112.4384	7597100.0
2004-10-08 15:00:00	SPY	ETF	112.45	112.7	112.35	112.58	7578600.0
2004-10-08 16:00:00	SPY	ETF	112.58	113.5	112.45	112.6	1659300.0
2004-10-08 17:00:00	SPY	ETF	112.6	112.63	112.57	112.57	10400.0
2004-10-08 18:00:00	SPY	ETF	112.62	112.64	112.62	112.64	1000.0
2004-10-08 19:00:00	SPY	ETF	112.63	112.63	112.63	112.63	700.0
2004-10-08 08:00:00	QQQ	ETF	36.34	36.39	36.03	36.05	1653500.0
2004-10-08 09:00:00	QQQ	ETF	36.04	36.24	35.99	36.209	17359600.0
2004-10-08 10:00:00	QQQ	ETF	36.21	36.22	35.86	35.91	21345100.0
2004-10-08 11:00:00	QQQ	ETF	35.91	35.97	35.829	35.85	16045900.0
2004-10-08 12:00:00	QQQ	ETF	35.852	35.9	35.8	35.897	10563000.0
2004-10-08 13:00:00	QQQ	ETF	35.9	35.93	35.78	35.794	7100200.0
2004-10-08 14:00:00	QQQ	ETF	35.8	35.8	35.52	35.562	18239100.0
2004-10-08 15:00:00	QQQ	ETF	35.57	35.68	35.5	35.616	16234800.0
2004-10-08 16:00:00	QQQ	ETF	35.616	35.63	35.55	35.61	2655800.0
2004-10-08 17:00:00	QQQ	ETF	35.59	35.6	35.58	35.58	32800.0
2004-10-08 18:00:00	QQQ	ETF	35.58	35.6	35.58	35.59	22100.0
2004-10-08 19:00:00	QQQ	ETF	35.59	35.59	35.58	35.58	2600.0
2004-10-08 08:00:00	IWM	ETF	58.215	58.25	57.825	57.825	88200.0
2004-10-08 09:00:00	IWM	ETF	57.74	58.185	57.69	58.17	3181000.0
2004-10-08 10:00:00	IWM	ETF	58.165	58.18	57.8	57.81	3605800.0
2004-10-08 11:00:00	IWM	ETF	57.845	57.91	57.685	57.79	1258200.0
2004-10-08 12:00:00	IWM	ETF	57.8	57.895	57.755	57.895	530000.0
2004-10-08 13:00:00	IWM	ETF	57.895	58.0	57.75	57.76	769600.0
2004-10-08 14:00:00	IWM	ETF	57.76	57.78	57.48	57.535	1579200.0
2004-10-08 15:00:00	IWM	ETF	57.54	57.545	57.325	57.35	2701800.0
2004-10-08 16:00:00	IWM	ETF	57.37	57.42	57.295	57.3	419000.0
2004-10-08 08:00:00	DIA	ETF	101.7	101.78	101.09	101.13	96400.0
2004-10-08 09:00:00	DIA	ETF	101.07	101.67	101.07	101.66	977100.0
2004-10-08 10:00:00	DIA	ETF	101.66	101.73	101.22	101.29	1322100.0
2004-10-08 11:00:00	DIA	ETF	101.29	101.33	101.06	101.18	681900.0
2004-10-08 12:00:00	DIA	ETF	101.19	101.28	101.08	101.24	503400.0
2004-10-08 13:00:00	DIA	ETF	101.24	101.31	100.94	101.02	908600.0
2004-10-08 14:00:00	DIA	ETF	100.99	101.02	100.6	100.64	1039300.0
2004-10-08 15:00:00	DIA	ETF	100.63	100.95	100.59	100.77	884200.0
2004-10-08 16:00:00	DIA	ETF	100.76	100.78	100.65	100.71	97400.0
2004-10-08 17:00:00	DIA	ETF	100.75	100.75	100.75	100.75	500.0
2004-10-08 18:00:00	DIA	ETF	100.75	100.75	100.75	100.75	500.0
2004-10-08 08:00:00	TLT	ETF	86.91	88.74	86.82	87.94	87400.0
2004-10-08 09:00:00	TLT	ETF	87.94	88.09	87.75	87.79	759600.0
2004-10-08 10:00:00	TLT	ETF	87.85	87.99	87.81	87.96	179300.0
2004-10-08 11:00:00	TLT	ETF	87.97	87.98	87.88	87.89	86900.0
2004-10-08 12:00:00	TLT	ETF	87.9	88.02	87.9	87.96	79100.0
2004-10-08 13:00:00	TLT	ETF	87.96	87.96	87.83	87.92	76600.0

> showing 50 of 728 rows — these rows as CSV

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