PREVIEW / etf_1hour / 2007-06-25

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-25.parquet
  size:    82 KB
  rows:    2,693

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-06-25 04:00:00	SPY	ETF	150.5	150.5	150.5	150.5	100.0
2007-06-25 05:00:00	SPY	ETF	150.65	150.65	150.65	150.65	300.0
2007-06-25 06:00:00	SPY	ETF	150.74	150.75	150.56	150.66	35600.0
2007-06-25 07:00:00	SPY	ETF	150.69	150.79	150.41	150.45	891200.0
2007-06-25 08:00:00	SPY	ETF	150.43	150.81	150.4	150.55	4351500.0
2007-06-25 09:00:00	SPY	ETF	150.56	150.56	149.55	149.97	32494989.0
2007-06-25 10:00:00	SPY	ETF	149.97	150.96	149.96	150.95	38326893.0
2007-06-25 11:00:00	SPY	ETF	150.95	151.19	150.71	150.86	19527682.0
2007-06-25 12:00:00	SPY	ETF	150.86	151.25	150.86	150.93	12622724.0
2007-06-25 13:00:00	SPY	ETF	150.93	151.05	150.67	150.68	14794464.0
2007-06-25 14:00:00	SPY	ETF	150.68	150.79	149.12	149.38	54111152.0
2007-06-25 15:00:00	SPY	ETF	149.37	150.415	149.02	149.61	45049261.0
2007-06-25 16:00:00	SPY	ETF	149.61	150.54	149.54	149.95	3004900.0
2007-06-25 17:00:00	SPY	ETF	149.96	150.09	149.96	150.06	79100.0
2007-06-25 18:00:00	SPY	ETF	150.05	150.05	149.97	150.01	46500.0
2007-06-25 19:00:00	SPY	ETF	149.98	150.0	149.95	149.98	8300.0
2007-06-25 07:00:00	QQQ	ETF	47.38	47.46	47.3	47.32	654431.0
2007-06-25 08:00:00	QQQ	ETF	47.32	47.45	47.32	47.42	1596858.0
2007-06-25 09:00:00	QQQ	ETF	47.4	47.4	47.0	47.16	24865332.0
2007-06-25 10:00:00	QQQ	ETF	47.1685	47.5	47.16	47.5	24717365.0
2007-06-25 11:00:00	QQQ	ETF	47.5	47.53	47.39	47.44	9308447.0
2007-06-25 12:00:00	QQQ	ETF	47.45	47.58	47.43	47.45	6203930.0
2007-06-25 13:00:00	QQQ	ETF	47.44	47.48	47.34	47.35	6509762.0
2007-06-25 14:00:00	QQQ	ETF	47.35	47.39	46.9	46.98	26163394.0
2007-06-25 15:00:00	QQQ	ETF	46.98	47.12	46.82	47.06	30552506.0
2007-06-25 16:00:00	QQQ	ETF	47.07	47.21	47.06	47.18	2402189.0
2007-06-25 17:00:00	QQQ	ETF	47.18	47.2	47.18	47.2	37559.0
2007-06-25 18:00:00	QQQ	ETF	47.17	47.19	47.17	47.19	6100.0
2007-06-25 19:00:00	QQQ	ETF	47.18	47.21	47.17	47.21	6325.0
2007-06-25 07:00:00	IWM	ETF	82.83	82.84	82.66	82.66	15100.0
2007-06-25 08:00:00	IWM	ETF	82.73	82.92	82.72	82.79	144000.0
2007-06-25 09:00:00	IWM	ETF	82.81	82.88	82.38	82.52	12735117.0
2007-06-25 10:00:00	IWM	ETF	82.51	83.29	82.51	83.18	15993835.0
2007-06-25 11:00:00	IWM	ETF	83.18	83.37	83.0	83.22	15192860.0
2007-06-25 12:00:00	IWM	ETF	83.22	83.45	83.05	83.23	7218300.0
2007-06-25 13:00:00	IWM	ETF	83.24	83.33	83.07	83.07	4486360.0
2007-06-25 14:00:00	IWM	ETF	83.08	83.17	82.11	82.27	17743558.0
2007-06-25 15:00:00	IWM	ETF	82.27	82.44	82.0	82.4	16926886.0
2007-06-25 16:00:00	IWM	ETF	82.39	82.66	82.23	82.6	6990600.0
2007-06-25 17:00:00	IWM	ETF	82.54	82.6	82.49	82.49	315300.0
2007-06-25 07:00:00	DIA	ETF	133.87	133.87	133.87	133.87	2000.0
2007-06-25 08:00:00	DIA	ETF	133.85	134.05	133.85	133.98	56100.0
2007-06-25 09:00:00	DIA	ETF	133.99	134.0	133.01	133.69	1951180.0
2007-06-25 10:00:00	DIA	ETF	133.71	134.52	133.67	134.47	3134213.0
2007-06-25 11:00:00	DIA	ETF	134.47	134.68	134.33	134.46	1346705.0
2007-06-25 12:00:00	DIA	ETF	134.45	134.77	134.43	134.48	962100.0
2007-06-25 13:00:00	DIA	ETF	134.48	134.59	134.27	134.28	1256409.0
2007-06-25 14:00:00	DIA	ETF	134.29	134.35	132.98	133.16	5906192.0
2007-06-25 15:00:00	DIA	ETF	133.16	133.7	132.89	133.45	4051620.0
2007-06-25 16:00:00	DIA	ETF	133.43	133.74	133.4	133.74	160200.0

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

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