PREVIEW / etf_1hour / 2007-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-02.parquet
  size:    71 KB
  rows:    2,294

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-05-02 04:00:00	SPY	ETF	148.71	149.23	148.71	149.14	13000.0
2007-05-02 05:00:00	SPY	ETF	149.14	149.14	149.1	149.1	13500.0
2007-05-02 06:00:00	SPY	ETF	149.04	149.04	149.04	149.04	1000.0
2007-05-02 07:00:00	SPY	ETF	149.02	149.05	148.97	149.0	21400.0
2007-05-02 08:00:00	SPY	ETF	149.12	149.26	148.84	148.89	1794500.0
2007-05-02 09:00:00	SPY	ETF	148.89	149.2	148.75	149.17	13377650.0
2007-05-02 10:00:00	SPY	ETF	149.17	149.79	149.17	149.72	22215787.0
2007-05-02 11:00:00	SPY	ETF	149.72	149.74	149.51	149.56	6985213.0
2007-05-02 12:00:00	SPY	ETF	149.56	149.77	149.53	149.64	6989535.0
2007-05-02 13:00:00	SPY	ETF	149.64	149.87	149.64	149.78	8096562.0
2007-05-02 14:00:00	SPY	ETF	149.78	149.95	149.71	149.78	9032261.0
2007-05-02 15:00:00	SPY	ETF	149.78	149.8	149.47	149.62	15063343.0
2007-05-02 16:00:00	SPY	ETF	149.62	149.67	149.52	149.54	1875600.0
2007-05-02 17:00:00	SPY	ETF	149.57	149.58	149.48	149.5	65200.0
2007-05-02 18:00:00	SPY	ETF	149.55	149.55	149.54	149.54	2000.0
2007-05-02 19:00:00	SPY	ETF	149.57	149.59	149.57	149.59	1400.0
2007-05-02 04:00:00	QQQ	ETF	46.06	46.23	46.06	46.23	27100.0
2007-05-02 05:00:00	QQQ	ETF	46.21	46.21	46.21	46.21	200.0
2007-05-02 06:00:00	QQQ	ETF	46.21	46.21	46.21	46.21	44147.0
2007-05-02 07:00:00	QQQ	ETF	46.17	46.18	46.15	46.17	36000.0
2007-05-02 08:00:00	QQQ	ETF	46.17	46.21	46.11	46.12	2261592.0
2007-05-02 09:00:00	QQQ	ETF	46.12	46.25	46.05	46.2	11976728.0
2007-05-02 10:00:00	QQQ	ETF	46.2	46.45	46.2	46.39	17930941.0
2007-05-02 11:00:00	QQQ	ETF	46.39	46.43	46.34	46.38	9060258.0
2007-05-02 12:00:00	QQQ	ETF	46.38	46.5	46.37	46.43	6324761.0
2007-05-02 13:00:00	QQQ	ETF	46.44	46.56	46.42	46.54	9568981.0
2007-05-02 14:00:00	QQQ	ETF	46.54	46.58	46.51	46.53	8813194.0
2007-05-02 15:00:00	QQQ	ETF	46.53	46.54	46.41	46.455	14611913.0
2007-05-02 16:00:00	QQQ	ETF	46.45	46.49	46.41	46.44	3314936.0
2007-05-02 17:00:00	QQQ	ETF	46.44	46.45	46.37	46.43	1164119.0
2007-05-02 18:00:00	QQQ	ETF	46.44	46.44	46.42	46.42	12170.0
2007-05-02 19:00:00	QQQ	ETF	46.43	46.44	46.42	46.44	8810.0
2007-05-02 07:00:00	IWM	ETF	81.11	81.26	81.11	81.24	2600.0
2007-05-02 08:00:00	IWM	ETF	81.31	81.31	81.04	81.04	437800.0
2007-05-02 09:00:00	IWM	ETF	81.12	81.4	80.92	81.38	4651443.0
2007-05-02 10:00:00	IWM	ETF	81.38	82.26	81.38	82.17	15135878.0
2007-05-02 11:00:00	IWM	ETF	82.17	82.22	82.07	82.1	5981492.0
2007-05-02 12:00:00	IWM	ETF	82.1	82.24	82.06	82.15	3174427.0
2007-05-02 13:00:00	IWM	ETF	82.15	82.43	82.14	82.39	4638554.0
2007-05-02 14:00:00	IWM	ETF	82.39	82.44	82.3	82.33	3059510.0
2007-05-02 15:00:00	IWM	ETF	82.34	82.36	82.12	82.23	7848333.0
2007-05-02 16:00:00	IWM	ETF	82.24	82.28	82.14	82.17	1091600.0
2007-05-02 17:00:00	IWM	ETF	82.17	82.17	82.17	82.17	589700.0
2007-05-02 08:00:00	DIA	ETF	131.61	131.61	131.47	131.48	26900.0
2007-05-02 09:00:00	DIA	ETF	131.5	131.78	131.36	131.75	1619300.0
2007-05-02 10:00:00	DIA	ETF	131.76	132.23	131.76	132.17	1777100.0
2007-05-02 11:00:00	DIA	ETF	132.15	132.17	132.0	132.01	750297.0
2007-05-02 12:00:00	DIA	ETF	132.02	132.2	131.95	132.1	675500.0
2007-05-02 13:00:00	DIA	ETF	132.1	132.37	132.1	132.33	1110922.0
2007-05-02 14:00:00	DIA	ETF	132.33	132.49	132.23	132.25	1000900.0

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

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