PREVIEW / etf_1hour / 2004-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-04.parquet
  size:    26 KB
  rows:    732

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-04 08:00:00	SPY	ETF	114.17	114.34	114.11	114.3	333500.0
2004-10-04 09:00:00	SPY	ETF	114.29	114.32	113.98	114.28	5817600.0
2004-10-04 10:00:00	SPY	ETF	114.3	114.44	114.1	114.14	5456500.0
2004-10-04 11:00:00	SPY	ETF	114.16	114.36	114.02	114.08	5482400.0
2004-10-04 12:00:00	SPY	ETF	114.08	114.14	113.96	113.99	2437700.0
2004-10-04 13:00:00	SPY	ETF	113.99	114.15	113.91	114.08	2152800.0
2004-10-04 14:00:00	SPY	ETF	114.08	114.28	113.99	114.02	2778100.0
2004-10-04 15:00:00	SPY	ETF	114.02	114.13	113.8	113.85	5582800.0
2004-10-04 16:00:00	SPY	ETF	113.85	113.9848	113.73	113.75	1144300.0
2004-10-04 17:00:00	SPY	ETF	113.73	113.75	113.71	113.75	260200.0
2004-10-04 18:00:00	SPY	ETF	113.73	113.73	113.73	113.73	250000.0
2004-10-04 19:00:00	SPY	ETF	113.73	113.75	113.73	113.73	800.0
2004-10-04 08:00:00	QQQ	ETF	36.42	36.49	36.38	36.48	865500.0
2004-10-04 09:00:00	QQQ	ETF	36.48	36.59	36.34	36.59	19891100.0
2004-10-04 10:00:00	QQQ	ETF	36.59	36.62	36.47	36.51	19348200.0
2004-10-04 11:00:00	QQQ	ETF	36.51	36.6	36.38	36.4	15195900.0
2004-10-04 12:00:00	QQQ	ETF	36.4	36.49	36.38	36.406	6410300.0
2004-10-04 13:00:00	QQQ	ETF	36.404	36.53	36.37	36.487	6521800.0
2004-10-04 14:00:00	QQQ	ETF	36.49	36.57	36.4	36.415	10337700.0
2004-10-04 15:00:00	QQQ	ETF	36.415	36.49	36.25	36.29	22109000.0
2004-10-04 16:00:00	QQQ	ETF	36.29	36.33	36.26	36.27	3445500.0
2004-10-04 17:00:00	QQQ	ETF	36.265	36.3	36.24	36.24	464700.0
2004-10-04 18:00:00	QQQ	ETF	36.25	36.27	36.22	36.25	115000.0
2004-10-04 19:00:00	QQQ	ETF	36.25	36.28	36.25	36.26	8000.0
2004-10-04 08:00:00	IWM	ETF	58.76	58.83	58.7	58.8	30600.0
2004-10-04 09:00:00	IWM	ETF	58.81	59.065	58.68	59.025	4148400.0
2004-10-04 10:00:00	IWM	ETF	59.03	59.09	58.825	58.87	1747800.0
2004-10-04 11:00:00	IWM	ETF	58.855	58.935	58.71	58.74	1125400.0
2004-10-04 12:00:00	IWM	ETF	58.75	58.78	58.62	58.68	975000.0
2004-10-04 13:00:00	IWM	ETF	58.665	58.825	58.6	58.785	1004800.0
2004-10-04 14:00:00	IWM	ETF	58.78	58.89	58.665	58.77	1328600.0
2004-10-04 15:00:00	IWM	ETF	58.77	58.805	58.61	58.69	2509400.0
2004-10-04 16:00:00	IWM	ETF	58.69	58.73	58.65	58.695	249000.0
2004-10-04 18:00:00	IWM	ETF	58.4	58.4	58.4	58.4	200.0
2004-10-04 08:00:00	DIA	ETF	102.75	102.86	102.68	102.84	12000.0
2004-10-04 09:00:00	DIA	ETF	102.85	102.85	102.57	102.74	1446800.0
2004-10-04 10:00:00	DIA	ETF	102.77	102.88	102.54	102.59	1336600.0
2004-10-04 11:00:00	DIA	ETF	102.58	102.73	102.5	102.52	335300.0
2004-10-04 12:00:00	DIA	ETF	102.54	102.6	102.39	102.42	259600.0
2004-10-04 13:00:00	DIA	ETF	102.44	102.56	102.39	102.48	214700.0
2004-10-04 14:00:00	DIA	ETF	102.5	102.63	102.41	102.45	457600.0
2004-10-04 15:00:00	DIA	ETF	102.44	102.54	102.26	102.28	1038500.0
2004-10-04 16:00:00	DIA	ETF	102.31	102.33	102.2	102.2	278000.0
2004-10-04 17:00:00	DIA	ETF	102.2	102.25	102.2	102.25	500.0
2004-10-04 18:00:00	DIA	ETF	102.3	102.3	102.3	102.3	400.0
2004-10-04 19:00:00	DIA	ETF	102.3	102.3	102.3	102.3	200.0
2004-10-04 08:00:00	TLT	ETF	87.2	87.2	87.0	87.0	5000.0
2004-10-04 09:00:00	TLT	ETF	87.05	87.16	87.0	87.11	206800.0
2004-10-04 10:00:00	TLT	ETF	87.1	87.28	87.07	87.26	215000.0
2004-10-04 11:00:00	TLT	ETF	87.28	87.33	87.21	87.32	91500.0

> showing 50 of 732 rows — these rows as CSV

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