PREVIEW / etf_1hour / 2004-01-12

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-12.parquet
  size:    24 KB
  rows:    655

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-01-12 08:00:00	SPY	ETF	112.62	112.66	112.6	112.66	43600.0
2004-01-12 09:00:00	SPY	ETF	112.64	112.81	112.42	112.53	7198400.0
2004-01-12 10:00:00	SPY	ETF	112.55	112.84	112.36	112.62	5837100.0
2004-01-12 11:00:00	SPY	ETF	112.62	112.82	112.46	112.73	2008200.0
2004-01-12 12:00:00	SPY	ETF	112.73	112.82	112.54	112.6	1722500.0
2004-01-12 13:00:00	SPY	ETF	112.6	112.85	112.49	112.83	2379700.0
2004-01-12 14:00:00	SPY	ETF	112.83	112.95	112.63	112.95	2388800.0
2004-01-12 15:00:00	SPY	ETF	112.94	113.12	112.84	113.09	6483500.0
2004-01-12 16:00:00	SPY	ETF	113.1	113.27	113.01	113.25	1680100.0
2004-01-12 17:00:00	SPY	ETF	113.28	113.34	113.01	113.01	2045200.0
2004-01-12 18:00:00	SPY	ETF	113.26	113.28	113.26	113.28	2900.0
2004-01-12 19:00:00	SPY	ETF	113.28	113.28	113.21	113.23	1700.0
2004-01-12 08:00:00	QQQ	ETF	37.82	37.85	37.8	37.84	42800.0
2004-01-12 09:00:00	QQQ	ETF	37.84	37.96	37.735	37.805	11038700.0
2004-01-12 10:00:00	QQQ	ETF	37.809	37.98	37.68	37.879	12542100.0
2004-01-12 11:00:00	QQQ	ETF	37.88	38.04	37.84	38.0	8795300.0
2004-01-12 12:00:00	QQQ	ETF	38.01	38.1	37.92	37.99	7013900.0
2004-01-12 13:00:00	QQQ	ETF	37.98	38.084	37.86	38.07	6227000.0
2004-01-12 14:00:00	QQQ	ETF	38.08	38.134	37.99	38.12	7509600.0
2004-01-12 15:00:00	QQQ	ETF	38.13	38.319	38.09	38.31	15220400.0
2004-01-12 16:00:00	QQQ	ETF	38.3	38.4	38.28	38.39	4872900.0
2004-01-12 17:00:00	QQQ	ETF	38.391	38.41	38.36	38.39	115500.0
2004-01-12 18:00:00	QQQ	ETF	38.39	38.42	38.38	38.4	31500.0
2004-01-12 19:00:00	QQQ	ETF	38.4	38.41	38.4	38.4	15300.0
2004-01-12 09:00:00	IWM	ETF	57.44	57.795	57.3155	57.415	636200.0
2004-01-12 10:00:00	IWM	ETF	57.41	57.685	57.25	57.568	944600.0
2004-01-12 11:00:00	IWM	ETF	57.6	57.75	57.45	57.71	591800.0
2004-01-12 12:00:00	IWM	ETF	57.72	57.785	57.64	57.6905	692000.0
2004-01-12 13:00:00	IWM	ETF	57.7	57.81	57.6195	57.76	478400.0
2004-01-12 14:00:00	IWM	ETF	57.755	57.855	57.7165	57.85	782800.0
2004-01-12 15:00:00	IWM	ETF	57.84	58.125	57.7705	58.075	1000400.0
2004-01-12 16:00:00	IWM	ETF	58.11	58.25	58.065	58.175	331400.0
2004-01-12 18:00:00	IWM	ETF	58.245	58.245	58.245	58.245	400.0
2004-01-12 08:00:00	DIA	ETF	104.95	104.95	104.89	104.93	6300.0
2004-01-12 09:00:00	DIA	ETF	104.93	105.03	104.68	104.77	1109000.0
2004-01-12 10:00:00	DIA	ETF	104.76	104.97	104.6	104.83	1350500.0
2004-01-12 11:00:00	DIA	ETF	104.83	104.98	104.69	104.91	521700.0
2004-01-12 12:00:00	DIA	ETF	104.904	104.95	104.71	104.76	353300.0
2004-01-12 13:00:00	DIA	ETF	104.77	104.91	104.66	104.9	488500.0
2004-01-12 14:00:00	DIA	ETF	104.893	105.0	104.74	104.96	1378200.0
2004-01-12 15:00:00	DIA	ETF	104.95	105.12	104.87	105.09	1779400.0
2004-01-12 16:00:00	DIA	ETF	105.12	105.267	105.09	105.24	441400.0
2004-01-12 17:00:00	DIA	ETF	105.19	105.3	105.19	105.2	2700.0
2004-01-12 18:00:00	DIA	ETF	105.21	105.21	105.2	105.21	500.0
2004-01-12 19:00:00	DIA	ETF	105.22	105.24	105.22	105.24	900.0
2004-01-12 09:00:00	TLT	ETF	86.6	86.94	86.6	86.9	58600.0
2004-01-12 10:00:00	TLT	ETF	86.9	87.38	86.9	87.21	191200.0
2004-01-12 11:00:00	TLT	ETF	87.22	87.37	87.19	87.36	135400.0
2004-01-12 12:00:00	TLT	ETF	87.36	87.36	87.19	87.3	174600.0
2004-01-12 13:00:00	TLT	ETF	87.24	87.29	87.15	87.25	54500.0

> showing 50 of 655 rows — these rows as CSV

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