PREVIEW / etf_1hour / 2004-03-15

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-15.parquet
  size:    26 KB
  rows:    719

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-03-15 08:00:00	SPY	ETF	112.22	112.38	112.12	112.16	119900.0
2004-03-15 09:00:00	SPY	ETF	112.19	112.35	112.04	112.07	5466000.0
2004-03-15 10:00:00	SPY	ETF	112.07	112.19	111.42	111.45	9369500.0
2004-03-15 11:00:00	SPY	ETF	111.46	111.69	111.13	111.2	7545900.0
2004-03-15 12:00:00	SPY	ETF	111.2	111.73	111.1	111.7	7378400.0
2004-03-15 13:00:00	SPY	ETF	111.7	111.7	111.15	111.52	5203000.0
2004-03-15 14:00:00	SPY	ETF	111.52	111.76	111.22	111.35	6159600.0
2004-03-15 15:00:00	SPY	ETF	111.35	111.62	110.9	111.03	9737300.0
2004-03-15 16:00:00	SPY	ETF	111.08	111.35	111.02	111.31	1883800.0
2004-03-15 17:00:00	SPY	ETF	111.28	111.28	111.21	111.25	29300.0
2004-03-15 18:00:00	SPY	ETF	111.25	111.28	111.22	111.28	9800.0
2004-03-15 19:00:00	SPY	ETF	111.25	111.29	111.22	111.28	13800.0
2004-03-15 08:00:00	QQQ	ETF	35.3	35.4	35.3	35.35	208900.0
2004-03-15 09:00:00	QQQ	ETF	35.36	35.4	35.22	35.26	14213600.0
2004-03-15 10:00:00	QQQ	ETF	35.26	35.4	35.07	35.089	21285800.0
2004-03-15 11:00:00	QQQ	ETF	35.07	35.16	34.949	34.974	15149800.0
2004-03-15 12:00:00	QQQ	ETF	34.97	35.09	34.9	35.06	15122400.0
2004-03-15 13:00:00	QQQ	ETF	35.06	35.08	34.9	34.978	9104700.0
2004-03-15 14:00:00	QQQ	ETF	34.98	35.115	34.89	34.979	13109900.0
2004-03-15 15:00:00	QQQ	ETF	34.977	35.051	34.81	34.83	21590100.0
2004-03-15 16:00:00	QQQ	ETF	34.83	34.945	34.82	34.905	2253700.0
2004-03-15 17:00:00	QQQ	ETF	34.899	34.91	34.867	34.88	95200.0
2004-03-15 18:00:00	QQQ	ETF	34.883	34.93	34.88	34.92	28400.0
2004-03-15 19:00:00	QQQ	ETF	34.92	34.94	34.9	34.91	13500.0
2004-03-15 08:00:00	IWM	ETF	57.83	57.875	57.8	57.875	13000.0
2004-03-15 09:00:00	IWM	ETF	57.875	57.985	57.65	57.66	1903600.0
2004-03-15 10:00:00	IWM	ETF	57.65	57.92	57.18	57.235	3502000.0
2004-03-15 11:00:00	IWM	ETF	57.22	57.345	56.785	56.87	3396600.0
2004-03-15 12:00:00	IWM	ETF	56.875	57.2	56.785	57.19	2179600.0
2004-03-15 13:00:00	IWM	ETF	57.19	57.2	56.775	57.065	1593400.0
2004-03-15 14:00:00	IWM	ETF	57.055	57.25	56.915	56.97	1710000.0
2004-03-15 15:00:00	IWM	ETF	56.965	57.09	56.41	56.41	5712000.0
2004-03-15 16:00:00	IWM	ETF	56.46	56.755	56.455	56.65	847200.0
2004-03-15 18:00:00	IWM	ETF	56.6	56.6	56.59	56.59	2000.0
2004-03-15 19:00:00	IWM	ETF	56.64	56.64	56.64	56.64	1000.0
2004-03-15 08:00:00	DIA	ETF	102.2	102.26	102.12	102.12	15800.0
2004-03-15 09:00:00	DIA	ETF	102.12	102.35	102.09	102.19	786000.0
2004-03-15 10:00:00	DIA	ETF	102.2	102.3	101.62	101.65	1665800.0
2004-03-15 11:00:00	DIA	ETF	101.65	101.87	101.36	101.42	1451800.0
2004-03-15 12:00:00	DIA	ETF	101.42	101.92	101.36	101.85	946800.0
2004-03-15 13:00:00	DIA	ETF	101.85	101.86	101.4	101.68	998100.0
2004-03-15 14:00:00	DIA	ETF	101.71	101.93	101.47	101.58	983900.0
2004-03-15 15:00:00	DIA	ETF	101.58	101.8	101.13	101.21	1618800.0
2004-03-15 16:00:00	DIA	ETF	101.25	101.57	101.21	101.55	230500.0
2004-03-15 17:00:00	DIA	ETF	101.52	101.62	101.46	101.62	22400.0
2004-03-15 18:00:00	DIA	ETF	101.54	101.54	101.5	101.5	400.0
2004-03-15 19:00:00	DIA	ETF	101.65	101.65	101.65	101.65	100.0
2004-03-15 09:00:00	TLT	ETF	90.42	90.5	90.28	90.34	36200.0
2004-03-15 10:00:00	TLT	ETF	90.37	90.57	90.33	90.57	83000.0
2004-03-15 11:00:00	TLT	ETF	90.56	90.64	90.53	90.64	32100.0

> showing 50 of 719 rows — these rows as CSV

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