PREVIEW / etf_1hour / 2007-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-25.parquet
  size:    73 KB
  rows:    2,277

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-25 04:00:00	SPY	ETF	148.25	148.56	148.25	148.5	24500.0
2007-04-25 06:00:00	SPY	ETF	148.58	148.59	148.52	148.52	10000.0
2007-04-25 07:00:00	SPY	ETF	148.51	148.58	148.47	148.47	490300.0
2007-04-25 08:00:00	SPY	ETF	148.53	148.84	148.45	148.77	4097700.0
2007-04-25 09:00:00	SPY	ETF	148.77	148.97	148.5	148.55	14218798.0
2007-04-25 10:00:00	SPY	ETF	148.55	148.64	148.16	148.37	22843007.0
2007-04-25 11:00:00	SPY	ETF	148.38	148.92	148.38	148.88	11254373.0
2007-04-25 12:00:00	SPY	ETF	148.88	148.9	148.71	148.8	5111806.0
2007-04-25 13:00:00	SPY	ETF	148.8	149.11	148.77	149.0585	11258628.0
2007-04-25 14:00:00	SPY	ETF	149.04	149.4	148.98	149.33	12636057.0
2007-04-25 15:00:00	SPY	ETF	149.33	149.66	148.97	149.46	20890865.0
2007-04-25 16:00:00	SPY	ETF	149.46	149.58	148.56	149.56	2623000.0
2007-04-25 17:00:00	SPY	ETF	149.56	149.57	149.41	149.52	766000.0
2007-04-25 18:00:00	SPY	ETF	149.53	149.58	149.51	149.52	11700.0
2007-04-25 19:00:00	SPY	ETF	149.52	149.57	149.51	149.57	12600.0
2007-04-25 04:00:00	QQQ	ETF	45.69	45.84	45.69	45.83	103000.0
2007-04-25 05:00:00	QQQ	ETF	45.84	45.84	45.84	45.84	500.0
2007-04-25 07:00:00	QQQ	ETF	45.81	45.86	45.79	45.8	753310.0
2007-04-25 08:00:00	QQQ	ETF	45.82	45.92	45.79	45.89	2478024.0
2007-04-25 09:00:00	QQQ	ETF	45.89	45.891	45.78	45.83	14392272.0
2007-04-25 10:00:00	QQQ	ETF	45.83	45.87	45.7	45.79	18507000.0
2007-04-25 11:00:00	QQQ	ETF	45.8	46.04	45.79	46.03	13955200.0
2007-04-25 12:00:00	QQQ	ETF	46.03	46.05	45.98	46.03	8731700.0
2007-04-25 13:00:00	QQQ	ETF	46.02	46.22	46.02	46.21	10116000.0
2007-04-25 14:00:00	QQQ	ETF	46.21	46.29	46.16	46.26	12289100.0
2007-04-25 15:00:00	QQQ	ETF	46.26	46.32	46.18	46.27	17086800.0
2007-04-25 16:00:00	QQQ	ETF	46.27	46.46	46.27	46.46	5111152.0
2007-04-25 17:00:00	QQQ	ETF	46.46	46.55	46.43	46.5	1213204.0
2007-04-25 18:00:00	QQQ	ETF	46.51	46.51	46.45	46.49	80973.0
2007-04-25 19:00:00	QQQ	ETF	46.49	46.53	46.48	46.5	36898.0
2007-04-25 07:00:00	IWM	ETF	82.1	82.41	82.1	82.37	1100.0
2007-04-25 08:00:00	IWM	ETF	82.4	82.67	82.38	82.62	510600.0
2007-04-25 09:00:00	IWM	ETF	82.59	82.72	82.24	82.3	4365025.0
2007-04-25 10:00:00	IWM	ETF	82.31	82.33	81.97	82.05	9257857.0
2007-04-25 11:00:00	IWM	ETF	82.06	82.6	82.03	82.48	4279854.0
2007-04-25 12:00:00	IWM	ETF	82.48	82.5	82.35	82.42	2509286.0
2007-04-25 13:00:00	IWM	ETF	82.43	82.62	82.35	82.6	4888687.0
2007-04-25 14:00:00	IWM	ETF	82.59	82.87	82.49	82.73	7807739.0
2007-04-25 15:00:00	IWM	ETF	82.72	82.93	82.45	82.56	15240961.0
2007-04-25 16:00:00	IWM	ETF	82.55	82.59	82.41	82.48	1910200.0
2007-04-25 17:00:00	IWM	ETF	82.55	82.55	82.51	82.53	1900.0
2007-04-25 18:00:00	IWM	ETF	82.5	82.55	82.5	82.5	957600.0
2007-04-25 19:00:00	IWM	ETF	82.55	82.58	82.55	82.58	3300.0
2007-04-25 07:00:00	DIA	ETF	129.81	129.81	129.81	129.81	100.0
2007-04-25 08:00:00	DIA	ETF	129.69	129.91	129.68	129.91	114500.0
2007-04-25 09:00:00	DIA	ETF	129.91	130.2	129.8	129.91	1947548.0
2007-04-25 10:00:00	DIA	ETF	129.91	129.95	129.56	129.77	1664430.0
2007-04-25 11:00:00	DIA	ETF	129.77	130.19	129.77	130.17	674680.0
2007-04-25 12:00:00	DIA	ETF	130.17	130.17	130.0	130.08	478200.0
2007-04-25 13:00:00	DIA	ETF	130.079	130.28	130.06	130.24	826300.0

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

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