PREVIEW / etf_1hour / 2004-09-08

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-08.parquet
  size:    24 KB
  rows:    685

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-09-08 08:00:00	SPY	ETF	112.71	112.75	112.66	112.67	92500.0
2004-09-08 09:00:00	SPY	ETF	112.71	112.82	112.54	112.64	4231900.0
2004-09-08 10:00:00	SPY	ETF	112.62	113.06	112.54	112.64	7384200.0
2004-09-08 11:00:00	SPY	ETF	112.64	112.82	112.56	112.63	2810300.0
2004-09-08 12:00:00	SPY	ETF	112.63	112.74	112.36	112.47	3081200.0
2004-09-08 13:00:00	SPY	ETF	112.47	112.77	112.46	112.69	3569200.0
2004-09-08 14:00:00	SPY	ETF	112.68	112.82	112.4	112.48	2878500.0
2004-09-08 15:00:00	SPY	ETF	112.47	112.61	112.31	112.35	6023200.0
2004-09-08 16:00:00	SPY	ETF	112.35	112.6	112.3	112.55	1034700.0
2004-09-08 17:00:00	SPY	ETF	112.54	112.59	112.52	112.57	39700.0
2004-09-08 18:00:00	SPY	ETF	112.56	112.57	112.55	112.55	2600.0
2004-09-08 19:00:00	SPY	ETF	112.56	112.57	112.56	112.57	7600.0
2004-09-08 08:00:00	QQQ	ETF	34.34	34.39	34.32	34.32	157400.0
2004-09-08 09:00:00	QQQ	ETF	34.32	34.46	34.29	34.37	12622800.0
2004-09-08 10:00:00	QQQ	ETF	34.37	34.68	34.35	34.444	19974300.0
2004-09-08 11:00:00	QQQ	ETF	34.445	34.55	34.37	34.4	9222900.0
2004-09-08 12:00:00	QQQ	ETF	34.401	34.45	34.182	34.25	13268700.0
2004-09-08 13:00:00	QQQ	ETF	34.26	34.4	34.25	34.37	8909800.0
2004-09-08 14:00:00	QQQ	ETF	34.369	34.44	34.25	34.27	9950700.0
2004-09-08 15:00:00	QQQ	ETF	34.26	34.35	34.18	34.23	16895700.0
2004-09-08 16:00:00	QQQ	ETF	34.23	34.396	34.2	34.36	3162800.0
2004-09-08 17:00:00	QQQ	ETF	34.36	34.38	34.34	34.34	327200.0
2004-09-08 18:00:00	QQQ	ETF	34.37	34.37	34.34	34.36	27400.0
2004-09-08 19:00:00	QQQ	ETF	34.35	34.35	34.34	34.34	6300.0
2004-09-08 09:00:00	IWM	ETF	56.04	56.26	56.02	56.125	849400.0
2004-09-08 10:00:00	IWM	ETF	56.125	56.535	56.075	56.17	3084000.0
2004-09-08 11:00:00	IWM	ETF	56.165	56.265	56.105	56.15	604400.0
2004-09-08 12:00:00	IWM	ETF	56.16	56.23	55.775	55.86	1669600.0
2004-09-08 13:00:00	IWM	ETF	55.86	56.09	55.86	56.035	600200.0
2004-09-08 14:00:00	IWM	ETF	56.025	56.09	55.8	55.87	827200.0
2004-09-08 15:00:00	IWM	ETF	55.86	55.865	55.56	55.59	2489600.0
2004-09-08 16:00:00	IWM	ETF	55.61	55.875	55.61	55.865	191600.0
2004-09-08 17:00:00	IWM	ETF	55.78	55.875	55.78	55.875	20200.0
2004-09-08 08:00:00	DIA	ETF	103.47	103.47	103.47	103.47	100.0
2004-09-08 09:00:00	DIA	ETF	103.43	103.58	103.32	103.45	543400.0
2004-09-08 10:00:00	DIA	ETF	103.44	103.77	103.35	103.44	1301700.0
2004-09-08 11:00:00	DIA	ETF	103.45	103.63	103.39	103.46	328000.0
2004-09-08 12:00:00	DIA	ETF	103.45	103.53	103.26	103.33	705500.0
2004-09-08 13:00:00	DIA	ETF	103.33	103.63	103.33	103.58	347400.0
2004-09-08 14:00:00	DIA	ETF	103.56	103.67	103.29	103.33	351300.0
2004-09-08 15:00:00	DIA	ETF	103.32	103.47	103.22	103.3	867000.0
2004-09-08 16:00:00	DIA	ETF	103.3	103.49	103.28	103.49	195800.0
2004-09-08 17:00:00	DIA	ETF	103.5	103.5	103.48	103.5	1200.0
2004-09-08 08:00:00	TLT	ETF	86.47	86.47	86.47	86.47	100.0
2004-09-08 09:00:00	TLT	ETF	86.26	86.28	86.2	86.22	32400.0
2004-09-08 10:00:00	TLT	ETF	86.27	86.53	86.18	86.5	66200.0
2004-09-08 11:00:00	TLT	ETF	86.45	86.62	86.44	86.62	76600.0
2004-09-08 12:00:00	TLT	ETF	86.57	86.8	86.54	86.8	124600.0
2004-09-08 13:00:00	TLT	ETF	86.85	86.93	86.76	86.87	36900.0
2004-09-08 14:00:00	TLT	ETF	86.85	87.32	86.79	87.29	70200.0

> showing 50 of 685 rows — these rows as CSV

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