PREVIEW / etf_1hour / 2008-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-25.parquet
  size:    108 KB
  rows:    3,504

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-07-25 04:00:00	SPY	ETF	125.59	125.59	125.48	125.48	400.0
2008-07-25 05:00:00	SPY	ETF	125.4	125.4	125.11	125.26	10500.0
2008-07-25 06:00:00	SPY	ETF	125.28	125.5	125.28	125.3	9300.0
2008-07-25 07:00:00	SPY	ETF	125.27	125.76	125.24	125.65	406199.0
2008-07-25 08:00:00	SPY	ETF	125.66	126.1	125.25	125.79	5609290.0
2008-07-25 09:00:00	SPY	ETF	125.8	126.06	125.28	125.99	30262949.0
2008-07-25 10:00:00	SPY	ETF	125.99	126.49	125.5	126.269	48246777.0
2008-07-25 11:00:00	SPY	ETF	126.27	126.3	125.76	125.87	21143787.0
2008-07-25 12:00:00	SPY	ETF	125.87	125.99	125.59	125.94	13696683.0
2008-07-25 13:00:00	SPY	ETF	125.94	126.1	125.17	125.51	30275761.0
2008-07-25 14:00:00	SPY	ETF	125.51	125.93	125.47	125.84	20494109.0
2008-07-25 15:00:00	SPY	ETF	125.84	125.9	125.27	125.71	32764894.0
2008-07-25 16:00:00	SPY	ETF	125.64	125.79	125.27	125.45	10530135.0
2008-07-25 17:00:00	SPY	ETF	125.45	125.54	125.44	125.45	80443.0
2008-07-25 18:00:00	SPY	ETF	125.5	125.5	125.4	125.4	10429.0
2008-07-25 19:00:00	SPY	ETF	125.45	125.45	125.4	125.44	2650.0
2008-07-25 04:00:00	QQQ	ETF	44.79	44.79	44.79	44.79	400.0
2008-07-25 07:00:00	QQQ	ETF	44.61	44.85	44.58	44.84	191426.0
2008-07-25 08:00:00	QQQ	ETF	44.84	44.99	44.78	44.9	2321045.0
2008-07-25 09:00:00	QQQ	ETF	44.9	45.1401	44.76	45.06	23200705.0
2008-07-25 10:00:00	QQQ	ETF	45.06	45.36	44.83	45.33	27960446.0
2008-07-25 11:00:00	QQQ	ETF	45.34	45.37	45.13	45.26	8907182.0
2008-07-25 12:00:00	QQQ	ETF	45.25	45.27	45.07	45.22	6278490.0
2008-07-25 13:00:00	QQQ	ETF	45.22	45.31	45.07	45.19	10419883.0
2008-07-25 14:00:00	QQQ	ETF	45.1895	45.48	45.16	45.46	11552487.0
2008-07-25 15:00:00	QQQ	ETF	45.45	45.48	45.24	45.34	16993962.0
2008-07-25 16:00:00	QQQ	ETF	45.39	45.39	45.13	45.22	2824449.0
2008-07-25 17:00:00	QQQ	ETF	45.22	45.28	45.2	45.26	37598.0
2008-07-25 18:00:00	QQQ	ETF	45.27	45.28	45.25	45.25	18648.0
2008-07-25 19:00:00	QQQ	ETF	45.25	45.35	45.25	45.34	29437.0
2008-07-25 07:00:00	IWM	ETF	70.31	70.57	70.31	70.55	7700.0
2008-07-25 08:00:00	IWM	ETF	70.53	70.8	69.75	70.61	829831.0
2008-07-25 09:00:00	IWM	ETF	70.62	70.93	70.21	70.87	9895154.0
2008-07-25 10:00:00	IWM	ETF	70.86	71.41	70.59	71.35	25120387.0
2008-07-25 11:00:00	IWM	ETF	71.35	71.41	71.02	71.15	9996300.0
2008-07-25 12:00:00	IWM	ETF	71.15	71.17	70.82	71.09	8475645.0
2008-07-25 13:00:00	IWM	ETF	71.1	71.19	70.63	70.82	14028862.0
2008-07-25 14:00:00	IWM	ETF	70.81	70.97	70.62	70.91	14100970.0
2008-07-25 15:00:00	IWM	ETF	70.9	70.93	70.56	70.83	14069170.0
2008-07-25 16:00:00	IWM	ETF	70.84	70.92	70.04	70.71	7315078.0
2008-07-25 17:00:00	IWM	ETF	70.68	70.68	70.68	70.68	100.0
2008-07-25 19:00:00	IWM	ETF	70.66	70.66	70.66	70.66	500.0
2008-07-25 07:00:00	DIA	ETF	113.72	113.76	113.7	113.71	5025.0
2008-07-25 08:00:00	DIA	ETF	113.7	114.03	113.58	113.85	133331.0
2008-07-25 09:00:00	DIA	ETF	113.8	114.08	113.4	114.03	2757232.0
2008-07-25 10:00:00	DIA	ETF	114.04	114.36	113.65	114.21	4651909.0
2008-07-25 11:00:00	DIA	ETF	114.23	114.26	113.71	113.77	2124176.0
2008-07-25 12:00:00	DIA	ETF	113.72	113.84	113.47	113.78	1521250.0
2008-07-25 13:00:00	DIA	ETF	113.79	113.94	113.15	113.44	2805715.0
2008-07-25 14:00:00	DIA	ETF	113.43	113.82	113.41	113.75	2173482.0

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

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