PREVIEW / etf_1hour / 2007-04-10

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-10.parquet
  size:    68 KB
  rows:    2,187

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-10 06:00:00	SPY	ETF	144.48	144.48	144.48	144.48	6000.0
2007-04-10 07:00:00	SPY	ETF	144.52	144.52	144.37	144.43	41200.0
2007-04-10 08:00:00	SPY	ETF	144.36	144.47	144.19	144.3	384300.0
2007-04-10 09:00:00	SPY	ETF	144.3	144.72	144.25	144.71	8535808.0
2007-04-10 10:00:00	SPY	ETF	144.72	144.85	144.56	144.65	11548717.0
2007-04-10 11:00:00	SPY	ETF	144.65	144.719	144.39	144.42	10322952.0
2007-04-10 12:00:00	SPY	ETF	144.42	144.57	144.38	144.43	4933626.0
2007-04-10 13:00:00	SPY	ETF	144.44	144.72	144.43	144.62	5197344.0
2007-04-10 14:00:00	SPY	ETF	144.63	144.75	144.59	144.71	5184958.0
2007-04-10 15:00:00	SPY	ETF	144.72	144.83	144.66	144.8	7424661.0
2007-04-10 16:00:00	SPY	ETF	144.8	144.82	144.6	144.6	2157000.0
2007-04-10 17:00:00	SPY	ETF	144.61	144.64	144.59	144.63	26200.0
2007-04-10 18:00:00	SPY	ETF	144.62	144.63	144.61	144.61	3300.0
2007-04-10 19:00:00	SPY	ETF	144.61	144.62	144.6	144.61	8800.0
2007-04-10 07:00:00	QQQ	ETF	44.52	44.53	44.43	44.49	566914.0
2007-04-10 08:00:00	QQQ	ETF	44.49	44.5	44.43	44.45	2201556.0
2007-04-10 09:00:00	QQQ	ETF	44.44	44.62	44.41	44.59	12924202.0
2007-04-10 10:00:00	QQQ	ETF	44.59	44.67	44.53	44.54	9263500.0
2007-04-10 11:00:00	QQQ	ETF	44.54	44.54	44.47	44.49	9333100.0
2007-04-10 12:00:00	QQQ	ETF	44.49	44.56	44.45	44.46	6242200.0
2007-04-10 13:00:00	QQQ	ETF	44.45	44.57	44.45	44.52	6212500.0
2007-04-10 14:00:00	QQQ	ETF	44.52	44.57	44.51	44.55	3800600.0
2007-04-10 15:00:00	QQQ	ETF	44.55	44.68	44.55	44.67	10130400.0
2007-04-10 16:00:00	QQQ	ETF	44.67	44.68	44.59	44.64	15029006.0
2007-04-10 17:00:00	QQQ	ETF	44.65	44.67	44.62	44.67	98700.0
2007-04-10 18:00:00	QQQ	ETF	44.65	44.65	44.63	44.64	48614.0
2007-04-10 19:00:00	QQQ	ETF	44.63	44.64	44.63	44.63	16849.0
2007-04-10 07:00:00	IWM	ETF	80.55	80.55	80.55	80.55	1900.0
2007-04-10 08:00:00	IWM	ETF	80.57	80.65	80.47	80.49	408100.0
2007-04-10 09:00:00	IWM	ETF	80.51	80.82	80.38	80.78	4384631.0
2007-04-10 10:00:00	IWM	ETF	80.79	81.06	80.71	80.95	6470188.0
2007-04-10 11:00:00	IWM	ETF	80.958	80.98	80.79	80.8185	5152811.0
2007-04-10 12:00:00	IWM	ETF	80.82	80.9	80.7	80.71	2844707.0
2007-04-10 13:00:00	IWM	ETF	80.72	80.88	80.5629	80.79	5877552.0
2007-04-10 14:00:00	IWM	ETF	80.78	80.85	80.72	80.79	5866318.0
2007-04-10 15:00:00	IWM	ETF	80.78	80.94	80.75	80.85	8611300.0
2007-04-10 16:00:00	IWM	ETF	80.86	80.86	80.5629	80.84	8096400.0
2007-04-10 17:00:00	IWM	ETF	80.81	80.82	80.79	80.82	2500.0
2007-04-10 19:00:00	IWM	ETF	80.8	80.8	80.8	80.8	1000.0
2007-04-10 08:00:00	DIA	ETF	125.7	125.73	125.61	125.61	5700.0
2007-04-10 09:00:00	DIA	ETF	125.65	125.84	125.57	125.81	538300.0
2007-04-10 10:00:00	DIA	ETF	125.82	125.86	125.66	125.681	926942.0
2007-04-10 11:00:00	DIA	ETF	125.69	125.7	125.47	125.4985	1169210.0
2007-04-10 12:00:00	DIA	ETF	125.49	125.63	125.47	125.5	283400.0
2007-04-10 13:00:00	DIA	ETF	125.51	125.72	125.51	125.62	1036302.0
2007-04-10 14:00:00	DIA	ETF	125.63	125.74	125.61	125.67	901735.0
2007-04-10 15:00:00	DIA	ETF	125.68	125.76	125.64	125.69	643304.0
2007-04-10 16:00:00	DIA	ETF	125.69	125.7	125.57	125.66	128700.0
2007-04-10 17:00:00	DIA	ETF	125.7	125.75	125.7	125.75	800.0
2007-04-10 19:00:00	DIA	ETF	125.73	125.73	125.73	125.73	1000.0

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

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