PREVIEW / etf_1hour / 2008-01-14

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-14.parquet
  size:    95 KB
  rows:    3,225

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
2008-01-14 04:00:00	SPY	ETF	140.42	140.44	140.42	140.44	5000.0
2008-01-14 06:00:00	SPY	ETF	140.48	140.48	140.25	140.28	40100.0
2008-01-14 07:00:00	SPY	ETF	140.25	141.12	140.25	140.97	1545700.0
2008-01-14 08:00:00	SPY	ETF	140.5	141.19	140.27	141.13	4225000.0
2008-01-14 09:00:00	SPY	ETF	141.12	141.24	140.15	140.65	27680858.0
2008-01-14 10:00:00	SPY	ETF	140.6599	141.15	140.4	141.1	23119900.0
2008-01-14 11:00:00	SPY	ETF	141.09	141.35	140.81	140.81	16819155.0
2008-01-14 12:00:00	SPY	ETF	140.82	140.95	140.5	140.75	15937892.0
2008-01-14 13:00:00	SPY	ETF	140.75	141.28	140.63	141.17	13158627.0
2008-01-14 14:00:00	SPY	ETF	141.17	141.52	140.85	141.47	18237345.0
2008-01-14 15:00:00	SPY	ETF	141.48	141.86	141.09	141.46	34807923.0
2008-01-14 16:00:00	SPY	ETF	141.46	141.51	141.26	141.36	11988000.0
2008-01-14 17:00:00	SPY	ETF	141.37	141.78	141.31	141.61	274300.0
2008-01-14 18:00:00	SPY	ETF	141.57	141.6	141.4	141.4	87700.0
2008-01-14 19:00:00	SPY	ETF	141.39	141.39	141.18	141.25	61000.0
2008-01-14 20:00:00	SPY	ETF	141.25	141.25	141.25	141.25	900.0
2008-01-14 04:00:00	QQQ	ETF	47.18	47.18	47.18	47.18	100.0
2008-01-14 05:00:00	QQQ	ETF	47.14	47.23	47.14	47.21	10200.0
2008-01-14 06:00:00	QQQ	ETF	47.21	47.21	47.06	47.06	3275.0
2008-01-14 07:00:00	QQQ	ETF	47.06	47.65	47.06	47.61	2906151.0
2008-01-14 08:00:00	QQQ	ETF	47.57	47.87	47.2	47.62	4625148.0
2008-01-14 09:00:00	QQQ	ETF	47.62	47.82	47.31	47.5001	27685659.0
2008-01-14 10:00:00	QQQ	ETF	47.5	47.74	47.37	47.6801	28704968.0
2008-01-14 11:00:00	QQQ	ETF	47.6801	47.9	47.58	47.592	22562555.0
2008-01-14 12:00:00	QQQ	ETF	47.59	47.62	47.43	47.56	14524255.0
2008-01-14 13:00:00	QQQ	ETF	47.57	47.81	47.5	47.78	15892979.0
2008-01-14 14:00:00	QQQ	ETF	47.79	47.93	47.63	47.9	12315249.0
2008-01-14 15:00:00	QQQ	ETF	47.9	48.01	47.76	47.92	29402058.0
2008-01-14 16:00:00	QQQ	ETF	47.91	47.9656	47.6796	47.83	9724544.0
2008-01-14 17:00:00	QQQ	ETF	47.03	47.87	47.03	47.84	2158368.0
2008-01-14 18:00:00	QQQ	ETF	47.85	47.88	47.82	47.82	48949.0
2008-01-14 19:00:00	QQQ	ETF	47.81	47.86	47.77	47.85	85435.0
2008-01-14 20:00:00	QQQ	ETF	47.84	47.84	47.84	47.84	1000.0
2008-01-14 06:00:00	IWM	ETF	70.63	70.63	70.63	70.63	5000.0
2008-01-14 07:00:00	IWM	ETF	70.78	70.99	70.78	70.9	140800.0
2008-01-14 08:00:00	IWM	ETF	70.9	71.0	70.85	70.89	271800.0
2008-01-14 09:00:00	IWM	ETF	70.92	71.04	70.3	70.46	9705958.0
2008-01-14 10:00:00	IWM	ETF	70.45	70.81	70.34	70.74	11057683.0
2008-01-14 11:00:00	IWM	ETF	70.77	70.96	70.54	70.59	5758312.0
2008-01-14 12:00:00	IWM	ETF	70.59	70.64	70.26	70.4	4147431.0
2008-01-14 13:00:00	IWM	ETF	70.4	70.91	70.37	70.85	8394977.0
2008-01-14 14:00:00	IWM	ETF	70.85	71.18	70.61	71.07	11644440.0
2008-01-14 15:00:00	IWM	ETF	71.07	71.19	70.71	70.97	18647131.0
2008-01-14 16:00:00	IWM	ETF	70.97	71.1	70.7	70.78	1294403.0
2008-01-14 17:00:00	IWM	ETF	70.78	70.95	70.75	70.95	3900.0
2008-01-14 18:00:00	IWM	ETF	70.81	70.85	70.81	70.85	8400.0
2008-01-14 19:00:00	IWM	ETF	70.71	70.74	70.71	70.74	1100.0
2008-01-14 06:00:00	DIA	ETF	126.38	126.38	126.32	126.32	5000.0
2008-01-14 07:00:00	DIA	ETF	126.28	127.13	126.28	127.13	34300.0
2008-01-14 08:00:00	DIA	ETF	127.15	127.31	127.05	127.24	160300.0

> showing 50 of 3,225 rows — these rows as CSV

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