PREVIEW / etf_1hour / 2007-06-12

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-12.parquet
  size:    80 KB
  rows:    2,660

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-12 06:00:00	SPY	ETF	150.88	151.78	150.88	151.12	34900.0
2007-06-12 07:00:00	SPY	ETF	151.1	151.1	150.74	150.95	964000.0
2007-06-12 08:00:00	SPY	ETF	150.98	151.17	150.7	150.74	4416800.0
2007-06-12 09:00:00	SPY	ETF	150.73	151.02	150.56	150.65	14298520.0
2007-06-12 10:00:00	SPY	ETF	150.65	150.76	150.13	150.28	31770459.0
2007-06-12 11:00:00	SPY	ETF	150.28	150.96	150.07	150.85	25451289.0
2007-06-12 12:00:00	SPY	ETF	150.85	150.85	150.525	150.57	9766205.0
2007-06-12 13:00:00	SPY	ETF	150.56	151.31	150.42	151.27	25976558.0
2007-06-12 14:00:00	SPY	ETF	151.27	151.54	150.34	150.71	39566984.0
2007-06-12 15:00:00	SPY	ETF	150.71	151.26	149.67	149.67	58997661.0
2007-06-12 16:00:00	SPY	ETF	149.69	149.85	149.36	149.4	17433500.0
2007-06-12 17:00:00	SPY	ETF	149.41	149.48	149.38	149.4	1918400.0
2007-06-12 18:00:00	SPY	ETF	149.4	149.52	149.35	149.47	39900.0
2007-06-12 19:00:00	SPY	ETF	149.48	149.48	149.29	149.29	39900.0
2007-06-12 04:00:00	QQQ	ETF	46.82	46.87	46.82	46.87	700.0
2007-06-12 06:00:00	QQQ	ETF	46.77	46.8	46.75	46.78	17200.0
2007-06-12 07:00:00	QQQ	ETF	46.76	46.76	46.57	46.63	718629.0
2007-06-12 08:00:00	QQQ	ETF	46.65	46.73	46.6	46.6	1328121.0
2007-06-12 09:00:00	QQQ	ETF	46.61	46.74	46.5	46.58	12776741.0
2007-06-12 10:00:00	QQQ	ETF	46.59	46.7	46.47	46.555	21791692.0
2007-06-12 11:00:00	QQQ	ETF	46.54	46.77	46.45	46.76	22659071.0
2007-06-12 12:00:00	QQQ	ETF	46.7515	46.8	46.63	46.65	9931764.0
2007-06-12 13:00:00	QQQ	ETF	46.65	46.96	46.6	46.95	28030633.0
2007-06-12 14:00:00	QQQ	ETF	46.95	47.04	46.7	46.81	19444184.0
2007-06-12 15:00:00	QQQ	ETF	46.82	46.86	46.49	46.55	31097488.0
2007-06-12 16:00:00	QQQ	ETF	46.55	46.97	46.46	46.46	2231442.0
2007-06-12 17:00:00	QQQ	ETF	46.45	46.5	46.44	46.49	47449.0
2007-06-12 18:00:00	QQQ	ETF	46.45	46.49	46.44	46.46	61271.0
2007-06-12 19:00:00	QQQ	ETF	46.46	46.49	46.44	46.45	72102.0
2007-06-12 06:00:00	IWM	ETF	82.79	83.24	82.7	82.7	4900.0
2007-06-12 07:00:00	IWM	ETF	82.8	82.8	82.46	82.5	38100.0
2007-06-12 08:00:00	IWM	ETF	82.56	82.72	82.34	82.39	316600.0
2007-06-12 09:00:00	IWM	ETF	82.4	82.49	82.18	82.19	7354700.0
2007-06-12 10:00:00	IWM	ETF	82.18	82.23	81.69	81.94	19458989.0
2007-06-12 11:00:00	IWM	ETF	81.93	82.2	81.74	82.13	8523587.0
2007-06-12 12:00:00	IWM	ETF	82.13	82.15	81.9	81.95	7206000.0
2007-06-12 13:00:00	IWM	ETF	81.95	82.5	81.83	82.49	9743400.0
2007-06-12 14:00:00	IWM	ETF	82.49	82.83	81.94	82.15	17282700.0
2007-06-12 15:00:00	IWM	ETF	82.16	82.2	81.0	81.57	27955700.0
2007-06-12 16:00:00	IWM	ETF	81.58	82.8184	81.33	81.33	7006200.0
2007-06-12 17:00:00	IWM	ETF	81.39	81.51	81.34	81.34	2146500.0
2007-06-12 19:00:00	IWM	ETF	81.34	81.35	81.33	81.34	8000.0
2007-06-12 07:00:00	DIA	ETF	133.96	134.0	133.87	134.0	6100.0
2007-06-12 08:00:00	DIA	ETF	134.01	134.16	133.64	133.64	267900.0
2007-06-12 09:00:00	DIA	ETF	133.69	134.08	133.59	133.84	1673601.0
2007-06-12 10:00:00	DIA	ETF	133.83	133.87	133.26	133.36	2640301.0
2007-06-12 11:00:00	DIA	ETF	133.37	133.9	133.16	133.83	2857400.0
2007-06-12 12:00:00	DIA	ETF	133.83	133.83	133.58	133.6	1196500.0
2007-06-12 13:00:00	DIA	ETF	133.6	134.31	133.49	134.27	2710189.0
2007-06-12 14:00:00	DIA	ETF	134.28	134.46	133.55	133.8	3073388.0

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

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