PREVIEW / etf_1hour / 2008-01-11

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-11.parquet
  size:    98 KB
  rows:    3,260

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-11 04:00:00	SPY	ETF	140.6	140.75	140.41	140.75	5100.0
2008-01-11 05:00:00	SPY	ETF	140.6	140.7	140.51	140.51	67200.0
2008-01-11 06:00:00	SPY	ETF	140.48	140.48	139.85	140.06	212600.0
2008-01-11 07:00:00	SPY	ETF	140.12	141.3	139.9	140.58	4080800.0
2008-01-11 08:00:00	SPY	ETF	140.58	140.85	139.9	140.68	6351305.0
2008-01-11 09:00:00	SPY	ETF	140.68	141.13	140.0	140.69	28351201.0
2008-01-11 10:00:00	SPY	ETF	140.68	141.35	140.2	141.01	36852115.0
2008-01-11 11:00:00	SPY	ETF	141.01	141.57	140.65	141.18	31885412.0
2008-01-11 12:00:00	SPY	ETF	141.18	141.8985	140.51	141.26	25567216.0
2008-01-11 13:00:00	SPY	ETF	141.26	141.31	139.93	140.14	45063831.0
2008-01-11 14:00:00	SPY	ETF	140.14	141.8978	139.77	140.19	24418753.0
2008-01-11 15:00:00	SPY	ETF	140.19	140.51	139.0	140.01	55783317.0
2008-01-11 16:00:00	SPY	ETF	140.098	140.3192	139.98	140.04	3919100.0
2008-01-11 17:00:00	SPY	ETF	140.04	140.16	140.03	140.16	157200.0
2008-01-11 18:00:00	SPY	ETF	140.16	140.21	140.1	140.21	36500.0
2008-01-11 19:00:00	SPY	ETF	140.22	140.29	140.2	140.26	18300.0
2008-01-11 06:00:00	QQQ	ETF	47.71	47.72	47.52	47.52	52700.0
2008-01-11 07:00:00	QQQ	ETF	47.58	47.73	47.44	47.66	975477.0
2008-01-11 08:00:00	QQQ	ETF	47.66	47.72	47.47	47.68	1532691.0
2008-01-11 09:00:00	QQQ	ETF	47.67	47.79	47.49	47.56	15567204.0
2008-01-11 10:00:00	QQQ	ETF	47.55	47.61	47.34	47.46	31152832.0
2008-01-11 11:00:00	QQQ	ETF	47.468	47.67	47.3	47.5	22656995.0
2008-01-11 12:00:00	QQQ	ETF	47.5	47.58	47.23	47.45	19609357.0
2008-01-11 13:00:00	QQQ	ETF	47.45	47.47	47.0	47.0	32293453.0
2008-01-11 14:00:00	QQQ	ETF	47.0	47.28	46.88	47.04	23342455.0
2008-01-11 15:00:00	QQQ	ETF	47.04	47.27	46.7	47.05	57809150.0
2008-01-11 16:00:00	QQQ	ETF	47.03	48.0347	46.99	47.05	11834336.0
2008-01-11 17:00:00	QQQ	ETF	47.03	47.06	47.02	47.06	21510.0
2008-01-11 18:00:00	QQQ	ETF	47.06	47.06	47.04	47.05	24940.0
2008-01-11 19:00:00	QQQ	ETF	47.05	47.08	47.04	47.04	12523.0
2008-01-11 06:00:00	IWM	ETF	71.07	71.07	71.07	71.07	100.0
2008-01-11 07:00:00	IWM	ETF	70.91	71.09	70.78	71.09	271200.0
2008-01-11 08:00:00	IWM	ETF	71.04	71.29	70.99	71.16	616400.0
2008-01-11 09:00:00	IWM	ETF	71.25	71.34	70.8	71.0	9001911.0
2008-01-11 10:00:00	IWM	ETF	70.99	71.34	70.62	71.07	18857401.0
2008-01-11 11:00:00	IWM	ETF	71.07	71.38	70.77	71.16	12489783.0
2008-01-11 12:00:00	IWM	ETF	71.15	71.4	70.74	71.39	12899686.0
2008-01-11 13:00:00	IWM	ETF	71.38	71.5	70.66	70.68	13319832.0
2008-01-11 14:00:00	IWM	ETF	70.67	71.09	70.29	70.56	15483298.0
2008-01-11 15:00:00	IWM	ETF	70.57	70.57	69.91	70.2	28771973.0
2008-01-11 16:00:00	IWM	ETF	70.19	71.7	70.17	70.47	8749537.0
2008-01-11 17:00:00	IWM	ETF	70.3	70.32	70.3	70.32	9300.0
2008-01-11 19:00:00	IWM	ETF	70.4	70.4	70.4	70.4	1000.0
2008-01-11 07:00:00	DIA	ETF	127.04	127.25	126.85	127.06	11500.0
2008-01-11 08:00:00	DIA	ETF	127.38	127.59	127.26	127.43	53300.0
2008-01-11 09:00:00	DIA	ETF	127.44	127.66	126.93	127.05	3126720.0
2008-01-11 10:00:00	DIA	ETF	127.05	127.27	126.62	127.1	4250588.0
2008-01-11 11:00:00	DIA	ETF	127.12	127.43	126.75	127.08	2357863.0
2008-01-11 12:00:00	DIA	ETF	127.06	127.15	126.49	127.08	2096867.0
2008-01-11 13:00:00	DIA	ETF	127.09	127.14	125.93	126.08	3328338.0

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

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