PREVIEW / etf_1hour / 2004-12-02

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-02.parquet
  size:    28 KB
  rows:    785

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-12-02 08:00:00	SPY	ETF	119.4	119.48	119.1	119.14	326500.0
2004-12-02 09:00:00	SPY	ETF	119.12	119.34	119.01	119.23	6821100.0
2004-12-02 10:00:00	SPY	ETF	119.23	119.74	119.13	119.63	10381500.0
2004-12-02 11:00:00	SPY	ETF	119.63	119.87	119.58	119.7	9972200.0
2004-12-02 12:00:00	SPY	ETF	119.69	119.73	119.29	119.35	7489000.0
2004-12-02 13:00:00	SPY	ETF	119.36	119.44	119.11	119.26	7725000.0
2004-12-02 14:00:00	SPY	ETF	119.26	119.57	119.17	119.48	4992300.0
2004-12-02 15:00:00	SPY	ETF	119.47	119.54	119.2	119.39	7120000.0
2004-12-02 16:00:00	SPY	ETF	119.39	119.95	119.32	119.89	3354800.0
2004-12-02 17:00:00	SPY	ETF	119.89	119.91	119.39	119.9	60600.0
2004-12-02 18:00:00	SPY	ETF	119.86	119.93	119.86	119.9	43100.0
2004-12-02 19:00:00	SPY	ETF	119.92	119.92	119.84	119.84	12800.0
2004-12-02 08:00:00	QQQ	ETF	39.94	39.95	39.73	39.78	1832171.0
2004-12-02 09:00:00	QQQ	ETF	39.78	40.0	39.76	39.95	11718715.0
2004-12-02 10:00:00	QQQ	ETF	39.95	40.29	39.899	40.24	25787768.0
2004-12-02 11:00:00	QQQ	ETF	40.235	40.39	40.22	40.24	23534166.0
2004-12-02 12:00:00	QQQ	ETF	40.23	40.25	40.01	40.053	12450826.0
2004-12-02 13:00:00	QQQ	ETF	40.05	40.13	39.95	40.05	11730313.0
2004-12-02 14:00:00	QQQ	ETF	40.05	40.184	40.01	40.16	9510485.0
2004-12-02 15:00:00	QQQ	ETF	40.159	40.176	40.018	40.08	11955204.0
2004-12-02 16:00:00	QQQ	ETF	40.08	40.53	40.049	40.53	6481220.0
2004-12-02 17:00:00	QQQ	ETF	40.52	40.54	40.35	40.51	738007.0
2004-12-02 18:00:00	QQQ	ETF	40.51	40.51	40.47	40.49	120443.0
2004-12-02 08:00:00	IWM	ETF	64.175	64.175	63.935	63.975	23800.0
2004-12-02 09:00:00	IWM	ETF	63.98	64.35	63.98	64.21	2439000.0
2004-12-02 10:00:00	IWM	ETF	64.235	64.335	64.065	64.24	1758600.0
2004-12-02 11:00:00	IWM	ETF	64.245	64.405	64.215	64.265	1285600.0
2004-12-02 12:00:00	IWM	ETF	64.265	64.275	63.95	63.98	1180800.0
2004-12-02 13:00:00	IWM	ETF	64.01	64.09	63.775	63.905	1639200.0
2004-12-02 14:00:00	IWM	ETF	63.91	64.225	63.86	64.215	1667400.0
2004-12-02 15:00:00	IWM	ETF	64.215	64.28	63.975	63.975	1881000.0
2004-12-02 16:00:00	IWM	ETF	63.965	64.285	63.925	64.285	505400.0
2004-12-02 17:00:00	IWM	ETF	64.3	64.31	64.26	64.31	4600.0
2004-12-02 19:00:00	IWM	ETF	64.275	64.275	64.275	64.275	1000.0
2004-12-02 08:00:00	DIA	ETF	105.79	105.85	105.77	105.83	6400.0
2004-12-02 09:00:00	DIA	ETF	105.62	105.76	105.36	105.67	1791700.0
2004-12-02 10:00:00	DIA	ETF	105.65	106.2	105.56	106.1	1866900.0
2004-12-02 11:00:00	DIA	ETF	106.1	106.27	105.94	106.03	914400.0
2004-12-02 12:00:00	DIA	ETF	106.03	106.08	105.71	105.79	749400.0
2004-12-02 13:00:00	DIA	ETF	105.8	105.85	105.56	105.69	580400.0
2004-12-02 14:00:00	DIA	ETF	105.7	105.93	105.59	105.86	685400.0
2004-12-02 15:00:00	DIA	ETF	105.86	105.91	105.63	105.79	696900.0
2004-12-02 16:00:00	DIA	ETF	105.79	106.19	105.78	106.19	203700.0
2004-12-02 17:00:00	DIA	ETF	106.19	106.19	106.15	106.18	9100.0
2004-12-02 18:00:00	DIA	ETF	106.18	106.19	106.15	106.19	1300.0
2004-12-02 19:00:00	DIA	ETF	106.28	106.28	106.28	106.28	400.0
2004-12-02 09:00:00	GLD	ETF	45.55	45.57	45.44	45.51	2013300.0
2004-12-02 10:00:00	GLD	ETF	45.51	45.52	44.95	45.08	1346100.0
2004-12-02 11:00:00	GLD	ETF	45.09	45.09	44.68	44.98	1349800.0
2004-12-02 12:00:00	GLD	ETF	44.99	45.05	44.87	44.88	653000.0

> showing 50 of 785 rows — these rows as CSV

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