PREVIEW / etf_1hour / 2004-09-15

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-15.parquet
  size:    24 KB
  rows:    684

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-15 08:00:00	SPY	ETF	113.33	113.4	113.27	113.4	78300.0
2004-09-15 09:00:00	SPY	ETF	113.37	113.41	113.05	113.09	4327200.0
2004-09-15 10:00:00	SPY	ETF	113.09	113.13	112.7	112.82	9614300.0
2004-09-15 11:00:00	SPY	ETF	112.83	112.97	112.74	112.88	4665100.0
2004-09-15 12:00:00	SPY	ETF	112.88	112.93	112.68	112.78	2334500.0
2004-09-15 13:00:00	SPY	ETF	112.78	113.09	112.77	113.07	3327200.0
2004-09-15 14:00:00	SPY	ETF	113.08	113.16	112.93	112.97	5195600.0
2004-09-15 15:00:00	SPY	ETF	112.97	113.06	112.71	112.74	5067800.0
2004-09-15 16:00:00	SPY	ETF	112.71	113.0	112.7	112.9	2096000.0
2004-09-15 17:00:00	SPY	ETF	112.88	112.88	112.78	112.85	215600.0
2004-09-15 18:00:00	SPY	ETF	112.85	112.86	112.85	112.85	2700.0
2004-09-15 19:00:00	SPY	ETF	112.84	112.84	112.8	112.8	2100.0
2004-09-15 08:00:00	QQQ	ETF	35.38	35.46	35.38	35.45	212500.0
2004-09-15 09:00:00	QQQ	ETF	35.44	35.45	35.28	35.305	17348500.0
2004-09-15 10:00:00	QQQ	ETF	35.3	35.37	35.21	35.268	15574900.0
2004-09-15 11:00:00	QQQ	ETF	35.27	35.34	35.21	35.23	8285900.0
2004-09-15 12:00:00	QQQ	ETF	35.23	35.27	35.12	35.16	10758600.0
2004-09-15 13:00:00	QQQ	ETF	35.16	35.31	35.15	35.3	7719100.0
2004-09-15 14:00:00	QQQ	ETF	35.3	35.36	35.24	35.28	9353800.0
2004-09-15 15:00:00	QQQ	ETF	35.28	35.31	35.18	35.206	13874000.0
2004-09-15 16:00:00	QQQ	ETF	35.19	35.32	35.19	35.29	2007300.0
2004-09-15 17:00:00	QQQ	ETF	35.29	35.3	35.2	35.27	355000.0
2004-09-15 18:00:00	QQQ	ETF	35.28	35.3	35.26	35.27	39800.0
2004-09-15 19:00:00	QQQ	ETF	35.26	35.26	35.25	35.26	22000.0
2004-09-15 08:00:00	IWM	ETF	56.79	56.89	56.77	56.85	13000.0
2004-09-15 09:00:00	IWM	ETF	56.82	56.87	56.63	56.695	1460600.0
2004-09-15 10:00:00	IWM	ETF	56.695	56.765	56.45	56.53	2954400.0
2004-09-15 11:00:00	IWM	ETF	56.53	56.63	56.485	56.61	1320600.0
2004-09-15 12:00:00	IWM	ETF	56.61	56.67	56.425	56.53	835400.0
2004-09-15 13:00:00	IWM	ETF	56.535	56.79	56.535	56.765	623400.0
2004-09-15 14:00:00	IWM	ETF	56.78	56.89	56.725	56.745	1015800.0
2004-09-15 15:00:00	IWM	ETF	56.76	56.79	56.525	56.625	1669400.0
2004-09-15 16:00:00	IWM	ETF	56.655	56.72	56.55	56.64	270400.0
2004-09-15 08:00:00	DIA	ETF	103.26	103.27	103.19	103.21	25500.0
2004-09-15 09:00:00	DIA	ETF	103.17	103.2	102.91	102.98	682900.0
2004-09-15 10:00:00	DIA	ETF	102.96	103.0	102.6	102.73	741400.0
2004-09-15 11:00:00	DIA	ETF	102.73	102.85	102.65	102.78	898200.0
2004-09-15 12:00:00	DIA	ETF	102.78	102.82	102.6	102.68	571000.0
2004-09-15 13:00:00	DIA	ETF	102.69	102.88	102.66	102.88	208800.0
2004-09-15 14:00:00	DIA	ETF	102.86	102.94	102.76	102.76	560800.0
2004-09-15 15:00:00	DIA	ETF	102.78	102.83	102.52	102.57	1205500.0
2004-09-15 16:00:00	DIA	ETF	102.56	102.72	102.53	102.67	347600.0
2004-09-15 17:00:00	DIA	ETF	102.55	102.55	102.55	102.55	100.0
2004-09-15 08:00:00	TLT	ETF	87.58	87.58	87.39	87.4	3600.0
2004-09-15 09:00:00	TLT	ETF	87.5	87.5	87.32	87.33	30000.0
2004-09-15 10:00:00	TLT	ETF	87.33	87.39	87.18	87.35	214200.0
2004-09-15 11:00:00	TLT	ETF	87.3	87.35	87.27	87.28	25200.0
2004-09-15 12:00:00	TLT	ETF	87.23	87.47	87.23	87.38	156600.0
2004-09-15 13:00:00	TLT	ETF	87.4	87.49	87.4	87.47	18600.0
2004-09-15 14:00:00	TLT	ETF	87.44	87.47	87.28	87.35	114800.0

> showing 50 of 684 rows — these rows as CSV

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