PREVIEW / etf_1hour / 2007-04-13

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-13.parquet
  size:    69 KB
  rows:    2,193

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
2007-04-13 06:00:00	SPY	ETF	144.66	144.66	144.62	144.62	10500.0
2007-04-13 07:00:00	SPY	ETF	144.59	144.6	144.52	144.6	141800.0
2007-04-13 08:00:00	SPY	ETF	144.6	145.08	144.54	144.81	3790200.0
2007-04-13 09:00:00	SPY	ETF	144.85	145.0	144.67	144.88	8138510.0
2007-04-13 10:00:00	SPY	ETF	144.88	144.92	144.36	144.78	26107917.0
2007-04-13 11:00:00	SPY	ETF	144.77	145.0	144.74	144.91	8338982.0
2007-04-13 12:00:00	SPY	ETF	144.91	145.02	144.76	144.94	5790417.0
2007-04-13 13:00:00	SPY	ETF	144.94	145.12	144.79	145.1	8035057.0
2007-04-13 14:00:00	SPY	ETF	145.09	145.28	144.94	145.19	9230932.0
2007-04-13 15:00:00	SPY	ETF	145.19	145.29	145.12	145.25	8427525.0
2007-04-13 16:00:00	SPY	ETF	145.26	145.3	145.21	145.3	4604000.0
2007-04-13 17:00:00	SPY	ETF	145.3	145.32	145.25	145.26	887300.0
2007-04-13 18:00:00	SPY	ETF	145.25	145.27	145.2	145.27	8000.0
2007-04-13 19:00:00	SPY	ETF	145.24	145.24	145.24	145.24	100.0
2007-04-13 05:00:00	QQQ	ETF	44.5	44.5	44.5	44.5	100.0
2007-04-13 07:00:00	QQQ	ETF	44.47	44.5	44.46	44.48	76838.0
2007-04-13 08:00:00	QQQ	ETF	44.49	44.7	44.45	44.58	2807604.0
2007-04-13 09:00:00	QQQ	ETF	44.59	44.62	44.44	44.47	10386043.0
2007-04-13 10:00:00	QQQ	ETF	44.48	44.52	44.29	44.43	19921600.0
2007-04-13 11:00:00	QQQ	ETF	44.44	44.51	44.41	44.49	7410900.0
2007-04-13 12:00:00	QQQ	ETF	44.49	44.5	44.38	44.43	6232800.0
2007-04-13 13:00:00	QQQ	ETF	44.43	44.51	44.38	44.5	3662200.0
2007-04-13 14:00:00	QQQ	ETF	44.49	44.7	44.42	44.63	20152300.0
2007-04-13 15:00:00	QQQ	ETF	44.64	44.72	44.61	44.67	19768500.0
2007-04-13 16:00:00	QQQ	ETF	44.67	44.76	44.45	44.69	3120030.0
2007-04-13 17:00:00	QQQ	ETF	44.69	44.72	44.68	44.69	272590.0
2007-04-13 18:00:00	QQQ	ETF	44.7	44.7	44.65	44.68	38525.0
2007-04-13 19:00:00	QQQ	ETF	44.68	44.7	44.68	44.68	4546.0
2007-04-13 07:00:00	IWM	ETF	80.72	80.72	80.72	80.72	300.0
2007-04-13 08:00:00	IWM	ETF	80.72	81.06	80.68	80.92	1053800.0
2007-04-13 09:00:00	IWM	ETF	80.93	81.05	80.66	80.73	3936590.0
2007-04-13 10:00:00	IWM	ETF	80.73	80.86	80.53	80.79	6015898.0
2007-04-13 11:00:00	IWM	ETF	80.79	80.95	80.76	80.94	3480898.0
2007-04-13 12:00:00	IWM	ETF	80.94	80.99	80.84	80.89	3717624.0
2007-04-13 13:00:00	IWM	ETF	80.9	81.0	80.83	80.99	1696924.0
2007-04-13 14:00:00	IWM	ETF	80.99	81.19	80.88	81.12	4101836.0
2007-04-13 15:00:00	IWM	ETF	81.13	81.33	81.09	81.33	5271416.0
2007-04-13 16:00:00	IWM	ETF	81.33	81.4	81.11	81.35	859200.0
2007-04-13 17:00:00	IWM	ETF	81.3	81.3	81.3	81.3	10000.0
2007-04-13 08:00:00	DIA	ETF	125.49	126.4	125.45	125.75	325400.0
2007-04-13 09:00:00	DIA	ETF	125.78	125.86	125.63	125.74	633051.0
2007-04-13 10:00:00	DIA	ETF	125.74	125.74	125.2	125.61	2089219.0
2007-04-13 11:00:00	DIA	ETF	125.61	125.82	125.58	125.76	586800.0
2007-04-13 12:00:00	DIA	ETF	125.76	125.88	125.66	125.83	382046.0
2007-04-13 13:00:00	DIA	ETF	125.82	126.04	125.77	125.97	540833.0
2007-04-13 14:00:00	DIA	ETF	125.97	126.06	125.86	126.0	591500.0
2007-04-13 15:00:00	DIA	ETF	126.01	126.11	125.97	126.1	735250.0
2007-04-13 16:00:00	DIA	ETF	126.1	126.22	126.07	126.22	23800.0
2007-04-13 17:00:00	DIA	ETF	126.17	126.17	126.09	126.09	64900.0
2007-04-13 19:00:00	DIA	ETF	126.17	126.17	126.17	126.17	100.0

> showing 50 of 2,193 rows — these rows as CSV

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