PREVIEW / etf_1hour / 2005-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-11-14.parquet
  size:    33 KB
  rows:    1,016

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
2005-11-14 07:00:00	SPY	ETF	123.74	123.74	123.69	123.69	107900.0
2005-11-14 08:00:00	SPY	ETF	123.69	123.75	123.65	123.7	516700.0
2005-11-14 09:00:00	SPY	ETF	123.72	123.9	123.63	123.78	7179100.0
2005-11-14 10:00:00	SPY	ETF	123.79	124.02	123.67	123.69	9226600.0
2005-11-14 11:00:00	SPY	ETF	123.67	123.8	123.54	123.66	6158700.0
2005-11-14 12:00:00	SPY	ETF	123.63	123.68	123.44	123.49	2852500.0
2005-11-14 13:00:00	SPY	ETF	123.47	123.71	123.41	123.71	7586100.0
2005-11-14 14:00:00	SPY	ETF	123.71	123.77	123.53	123.58	3164200.0
2005-11-14 15:00:00	SPY	ETF	123.58	123.74	123.45	123.67	4129900.0
2005-11-14 16:00:00	SPY	ETF	123.68	123.78	123.62	123.65	1031800.0
2005-11-14 17:00:00	SPY	ETF	123.67	123.7	123.63	123.7	120800.0
2005-11-14 18:00:00	SPY	ETF	123.62	123.63	123.6	123.6	6300.0
2005-11-14 19:00:00	SPY	ETF	123.56	123.59	123.56	123.59	1500.0
2005-11-14 09:00:00	QQQ	ETF	40.77	40.83	40.71	40.78	7361900.0
2005-11-14 10:00:00	QQQ	ETF	40.78	40.86	40.7	40.7	9696000.0
2005-11-14 11:00:00	QQQ	ETF	40.71	40.79	40.67	40.71	8474800.0
2005-11-14 12:00:00	QQQ	ETF	40.71	40.76	40.62	40.63	4744900.0
2005-11-14 13:00:00	QQQ	ETF	40.63	40.75	40.6	40.75	5337700.0
2005-11-14 14:00:00	QQQ	ETF	40.75	40.75	40.69	40.71	3935000.0
2005-11-14 15:00:00	QQQ	ETF	40.71	40.75	40.67	40.72	6671100.0
2005-11-14 08:00:00	IWM	ETF	66.33	66.33	66.29	66.29	5000.0
2005-11-14 09:00:00	IWM	ETF	66.37	66.55	66.25	66.28	3140300.0
2005-11-14 10:00:00	IWM	ETF	66.31	66.43	66.09	66.15	3330700.0
2005-11-14 11:00:00	IWM	ETF	66.15	66.21	65.91	66.0	5219200.0
2005-11-14 12:00:00	IWM	ETF	66.0	66.15	65.94	65.94	3729200.0
2005-11-14 13:00:00	IWM	ETF	65.94	66.3409	65.85	66.06	1663100.0
2005-11-14 14:00:00	IWM	ETF	66.06	66.25	65.84	65.93	2577200.0
2005-11-14 15:00:00	IWM	ETF	65.93	66.09	65.75	66.09	3825200.0
2005-11-14 16:00:00	IWM	ETF	66.1	66.21	66.07	66.15	179400.0
2005-11-14 17:00:00	IWM	ETF	66.15	66.15	66.06	66.06	1100.0
2005-11-14 18:00:00	IWM	ETF	66.1	66.1	66.1	66.1	300.0
2005-11-14 08:00:00	DIA	ETF	106.9	106.97	106.9	106.93	18400.0
2005-11-14 09:00:00	DIA	ETF	106.99	107.07	106.89	107.05	328100.0
2005-11-14 10:00:00	DIA	ETF	107.02	107.24	106.94	106.96	884300.0
2005-11-14 11:00:00	DIA	ETF	106.96	107.09	106.94	107.03	313900.0
2005-11-14 12:00:00	DIA	ETF	107.03	107.09	106.95	106.96	615900.0
2005-11-14 13:00:00	DIA	ETF	106.97	107.17	106.9	107.17	402500.0
2005-11-14 14:00:00	DIA	ETF	107.13	107.18	106.99	107.02	357800.0
2005-11-14 15:00:00	DIA	ETF	107.04	107.16	106.94	107.15	642300.0
2005-11-14 16:00:00	DIA	ETF	107.15	107.2	107.14	107.2	21100.0
2005-11-14 17:00:00	DIA	ETF	107.11	107.11	107.11	107.11	300.0
2005-11-14 08:00:00	GLD	ETF	46.82	46.82	46.55	46.61	5700.0
2005-11-14 09:00:00	GLD	ETF	46.6	46.62	46.51	46.51	236000.0
2005-11-14 10:00:00	GLD	ETF	46.52	46.65	46.51	46.59	177100.0
2005-11-14 11:00:00	GLD	ETF	46.62	46.81	46.54	46.6601	75300.0
2005-11-14 12:00:00	GLD	ETF	46.68	46.759	46.61	46.7	72100.0
2005-11-14 13:00:00	GLD	ETF	46.7	46.72	46.63	46.66	30300.0
2005-11-14 14:00:00	GLD	ETF	46.65	46.67	46.62	46.64	43300.0
2005-11-14 15:00:00	GLD	ETF	46.63	46.65	46.57	46.59	64100.0
2005-11-14 16:00:00	GLD	ETF	46.59	46.62	46.59	46.62	800.0

> showing 50 of 1,016 rows — these rows as CSV

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