PREVIEW / etf_1hour / 2007-06-27

all etf 1-hour files

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

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-27 04:00:00	SPY	ETF	148.5	148.5	148.46	148.46	1400.0
2007-06-27 05:00:00	SPY	ETF	148.4	148.4	148.4	148.4	2000.0
2007-06-27 06:00:00	SPY	ETF	148.54	148.7	148.51	148.7	23500.0
2007-06-27 07:00:00	SPY	ETF	148.66	148.7	148.27	148.27	1162800.0
2007-06-27 08:00:00	SPY	ETF	148.28	148.3	147.81	148.06	18460200.0
2007-06-27 09:00:00	SPY	ETF	148.09	148.84	147.89	148.59	33694185.0
2007-06-27 10:00:00	SPY	ETF	148.6	149.19	148.38	148.81	35676296.0
2007-06-27 11:00:00	SPY	ETF	148.81	149.35	148.64	148.99	20401746.0
2007-06-27 12:00:00	SPY	ETF	148.98	149.52	148.98	149.36	14554559.0
2007-06-27 13:00:00	SPY	ETF	149.37	149.475	148.86	149.34	18794800.0
2007-06-27 14:00:00	SPY	ETF	149.34	150.07	149.34	149.9	24587297.0
2007-06-27 15:00:00	SPY	ETF	149.89	150.56	149.85	150.55	32127683.0
2007-06-27 16:00:00	SPY	ETF	150.56	150.57	148.7793	150.45	5869300.0
2007-06-27 17:00:00	SPY	ETF	150.44	150.46	150.21	150.34	459600.0
2007-06-27 18:00:00	SPY	ETF	150.35	150.47	150.35	150.47	4600200.0
2007-06-27 19:00:00	SPY	ETF	150.45	150.47	150.45	150.47	1200.0
2007-06-27 06:00:00	QQQ	ETF	46.86	46.88	46.86	46.88	15000.0
2007-06-27 07:00:00	QQQ	ETF	46.87	46.87	46.78	46.8	594892.0
2007-06-27 08:00:00	QQQ	ETF	46.8	46.95	46.62	46.72	3879988.0
2007-06-27 09:00:00	QQQ	ETF	46.72	47.03	46.66	46.97	19083187.0
2007-06-27 10:00:00	QQQ	ETF	46.96	47.11	46.88	46.9709	25061466.0
2007-06-27 11:00:00	QQQ	ETF	46.97	47.15	46.92	47.03	14524860.0
2007-06-27 12:00:00	QQQ	ETF	47.03	47.21	47.025	47.17	10623088.0
2007-06-27 13:00:00	QQQ	ETF	47.17	47.21	47.04	47.16	10888255.0
2007-06-27 14:00:00	QQQ	ETF	47.16	47.45	47.16	47.3792	20046172.0
2007-06-27 15:00:00	QQQ	ETF	47.38	47.56	47.36	47.55	25156041.0
2007-06-27 16:00:00	QQQ	ETF	47.54	47.56	47.47	47.5	3988468.0
2007-06-27 17:00:00	QQQ	ETF	47.5	47.52	47.46	47.52	264137.0
2007-06-27 18:00:00	QQQ	ETF	47.5	47.52	47.47	47.52	27716.0
2007-06-27 19:00:00	QQQ	ETF	47.52	47.53	47.51	47.51	9372.0
2007-06-27 07:00:00	IWM	ETF	81.99	81.99	81.73	81.73	193800.0
2007-06-27 08:00:00	IWM	ETF	81.73	81.83	81.44	81.65	2032900.0
2007-06-27 09:00:00	IWM	ETF	81.65	82.14	81.5	82.03	14333010.0
2007-06-27 10:00:00	IWM	ETF	82.05	82.45	81.87	82.25	15298817.0
2007-06-27 11:00:00	IWM	ETF	82.24	82.57	82.15	82.44	10235958.0
2007-06-27 12:00:00	IWM	ETF	82.44	82.9	82.43	82.79	12916280.0
2007-06-27 13:00:00	IWM	ETF	82.79	82.88	82.55	82.78	9298402.0
2007-06-27 14:00:00	IWM	ETF	82.77	83.31	82.77	83.15	19344162.0
2007-06-27 15:00:00	IWM	ETF	83.15	83.6	83.11	83.59	25606955.0
2007-06-27 16:00:00	IWM	ETF	83.6	83.65	83.48	83.58	2220300.0
2007-06-27 17:00:00	IWM	ETF	83.53	83.53	83.53	83.53	4000.0
2007-06-27 18:00:00	IWM	ETF	83.54	83.6	83.54	83.58	165900.0
2007-06-27 07:00:00	DIA	ETF	133.08	133.14	132.79	132.79	37600.0
2007-06-27 08:00:00	DIA	ETF	132.8	132.8	132.49	132.69	206300.0
2007-06-27 09:00:00	DIA	ETF	132.7	133.06	132.53	132.76	2274799.0
2007-06-27 10:00:00	DIA	ETF	132.77	133.17	132.61	132.84	3645856.0
2007-06-27 11:00:00	DIA	ETF	132.86	133.3	132.73	132.98	5139502.0
2007-06-27 12:00:00	DIA	ETF	132.99	133.35	132.99	133.16	1262326.0
2007-06-27 13:00:00	DIA	ETF	133.17	133.27	132.77	133.13	1338611.0
2007-06-27 14:00:00	DIA	ETF	133.13	133.73	133.13	133.59	4193851.0

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

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