PREVIEW / etf_1hour / 2004-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-04.parquet
  size:    24 KB
  rows:    682

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-06-04 08:00:00	SPY	ETF	112.6	113.12	112.57	113.05	519400.0
2004-06-04 09:00:00	SPY	ETF	113.07	113.2	112.88	112.95	6042500.0
2004-06-04 10:00:00	SPY	ETF	112.95	113.23	112.79	113.02	5730100.0
2004-06-04 11:00:00	SPY	ETF	113.04	113.21	112.94	113.04	2331500.0
2004-06-04 12:00:00	SPY	ETF	113.04	113.58	113.02	113.45	4448400.0
2004-06-04 13:00:00	SPY	ETF	113.44	113.47	113.23	113.32	1875800.0
2004-06-04 14:00:00	SPY	ETF	113.34	113.36	113.01	113.18	2803300.0
2004-06-04 15:00:00	SPY	ETF	113.19	113.34	112.71	112.91	4899200.0
2004-06-04 16:00:00	SPY	ETF	112.91	112.98	112.79	112.95	1839600.0
2004-06-04 17:00:00	SPY	ETF	112.93	112.95	112.89	112.9	16300.0
2004-06-04 18:00:00	SPY	ETF	112.9	112.9	112.9	112.9	9000.0
2004-06-04 19:00:00	SPY	ETF	112.9	112.9	112.87	112.9	2100.0
2004-06-04 08:00:00	QQQ	ETF	36.12	36.35	36.12	36.32	1142600.0
2004-06-04 09:00:00	QQQ	ETF	36.32	36.41	36.25	36.341	13574300.0
2004-06-04 10:00:00	QQQ	ETF	36.34	36.44	36.221	36.365	16365300.0
2004-06-04 11:00:00	QQQ	ETF	36.37	36.43	36.31	36.38	6868400.0
2004-06-04 12:00:00	QQQ	ETF	36.37	36.62	36.37	36.558	17450200.0
2004-06-04 13:00:00	QQQ	ETF	36.558	36.59	36.433	36.49	8232200.0
2004-06-04 14:00:00	QQQ	ETF	36.49	36.49	36.36	36.43	8092500.0
2004-06-04 15:00:00	QQQ	ETF	36.43	36.48	36.18	36.22	15282000.0
2004-06-04 16:00:00	QQQ	ETF	36.224	36.29	36.14	36.28	2253600.0
2004-06-04 17:00:00	QQQ	ETF	36.27	36.28	36.25	36.27	97000.0
2004-06-04 18:00:00	QQQ	ETF	36.26	36.31	36.26	36.27	17100.0
2004-06-04 19:00:00	QQQ	ETF	36.24	36.27	36.23	36.26	8100.0
2004-06-04 08:00:00	IWM	ETF	56.325	56.6	56.325	56.575	95800.0
2004-06-04 09:00:00	IWM	ETF	56.575	56.695	56.4	56.48	2579000.0
2004-06-04 10:00:00	IWM	ETF	56.455	56.93	56.32	56.775	2044800.0
2004-06-04 11:00:00	IWM	ETF	56.825	56.85	56.65	56.65	886800.0
2004-06-04 12:00:00	IWM	ETF	56.705	57.05	56.69	57.0	965000.0
2004-06-04 13:00:00	IWM	ETF	57.0	57.0	56.855	56.9	569000.0
2004-06-04 14:00:00	IWM	ETF	56.91	56.925	56.74	56.855	853200.0
2004-06-04 15:00:00	IWM	ETF	56.86	56.955	56.53	56.615	2170000.0
2004-06-04 16:00:00	IWM	ETF	56.605	56.7	56.55	56.675	617400.0
2004-06-04 08:00:00	DIA	ETF	102.58	102.82	102.35	102.82	49800.0
2004-06-04 09:00:00	DIA	ETF	102.82	102.88	102.66	102.69	732400.0
2004-06-04 10:00:00	DIA	ETF	102.68	102.83	102.55	102.72	1044200.0
2004-06-04 11:00:00	DIA	ETF	102.72	102.83	102.65	102.7	293600.0
2004-06-04 12:00:00	DIA	ETF	102.7	103.2	102.68	103.09	616900.0
2004-06-04 13:00:00	DIA	ETF	103.07	103.09	102.85	102.98	390700.0
2004-06-04 14:00:00	DIA	ETF	102.97	102.97	102.68	102.84	357300.0
2004-06-04 15:00:00	DIA	ETF	102.83	102.96	102.41	102.62	798500.0
2004-06-04 16:00:00	DIA	ETF	102.59	102.74	102.54	102.68	53200.0
2004-06-04 17:00:00	DIA	ETF	102.68	102.68	102.68	102.68	600.0
2004-06-04 08:00:00	TLT	ETF	82.0	82.0	81.91	81.95	7500.0
2004-06-04 09:00:00	TLT	ETF	82.04	82.13	81.8	81.83	61900.0
2004-06-04 10:00:00	TLT	ETF	81.77	81.95	81.73	81.8	41500.0
2004-06-04 11:00:00	TLT	ETF	81.8	81.94	81.79	81.94	26300.0
2004-06-04 12:00:00	TLT	ETF	81.93	81.94	81.77	81.85	10700.0
2004-06-04 13:00:00	TLT	ETF	81.8	81.85	81.65	81.65	191000.0
2004-06-04 14:00:00	TLT	ETF	81.67	81.74	81.44	81.44	24600.0

> showing 50 of 682 rows — these rows as CSV

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