PREVIEW / etf_1hour / 2007-06-07

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-07.parquet
  size:    86 KB
  rows:    2,832

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-07 04:00:00	SPY	ETF	152.32	152.47	152.32	152.47	3100.0
2007-06-07 05:00:00	SPY	ETF	152.23	152.23	152.23	152.23	1000.0
2007-06-07 06:00:00	SPY	ETF	152.2	152.27	152.2	152.22	41000.0
2007-06-07 07:00:00	SPY	ETF	152.33	152.33	151.78	151.79	1138500.0
2007-06-07 08:00:00	SPY	ETF	151.81	152.5	151.49	151.65	2868700.0
2007-06-07 09:00:00	SPY	ETF	151.68	152.0	151.46	152.0	21019396.0
2007-06-07 10:00:00	SPY	ETF	152.0	152.06	151.25	151.38	31375572.0
2007-06-07 11:00:00	SPY	ETF	151.39	151.42	150.74	150.95	31545382.0
2007-06-07 12:00:00	SPY	ETF	150.95	152.5	150.27	150.6	30325883.0
2007-06-07 13:00:00	SPY	ETF	150.59	150.67	149.67	150.13	30299812.0
2007-06-07 14:00:00	SPY	ETF	150.135	150.48	149.66	150.25	28146996.0
2007-06-07 15:00:00	SPY	ETF	150.2499	150.65	149.25	149.36	40806519.0
2007-06-07 16:00:00	SPY	ETF	149.36	149.55	149.05	149.1	9737300.0
2007-06-07 17:00:00	SPY	ETF	149.26	149.8895	149.23	149.28	342000.0
2007-06-07 18:00:00	SPY	ETF	149.29	149.29	149.18	149.18	19800.0
2007-06-07 19:00:00	SPY	ETF	149.15	149.27	149.0	149.27	50500.0
2007-06-07 06:00:00	QQQ	ETF	47.09	47.09	47.09	47.09	3000.0
2007-06-07 07:00:00	QQQ	ETF	47.14	47.15	46.94	46.94	609006.0
2007-06-07 08:00:00	QQQ	ETF	46.96	47.01	46.88	46.91	2905119.0
2007-06-07 09:00:00	QQQ	ETF	46.93	47.21	46.89	47.15	27151913.0
2007-06-07 10:00:00	QQQ	ETF	47.15	47.21	46.99	47.08	34551431.0
2007-06-07 11:00:00	QQQ	ETF	47.08	47.09	46.79	46.87	33364547.0
2007-06-07 12:00:00	QQQ	ETF	46.87	46.97	46.71	46.81	23495643.0
2007-06-07 13:00:00	QQQ	ETF	46.82	46.85	46.38	46.54	32588215.0
2007-06-07 14:00:00	QQQ	ETF	46.54	46.62	46.32	46.5685	22560324.0
2007-06-07 15:00:00	QQQ	ETF	46.56	46.76	46.33	46.33	34755275.0
2007-06-07 16:00:00	QQQ	ETF	46.34	46.418	46.24	46.33	7407397.0
2007-06-07 17:00:00	QQQ	ETF	46.34	46.37	46.31	46.37	688195.0
2007-06-07 18:00:00	QQQ	ETF	46.36	46.36	46.29	46.29	120655.0
2007-06-07 19:00:00	QQQ	ETF	46.29	46.32	46.25	46.3	118703.0
2007-06-07 07:00:00	IWM	ETF	83.52	83.52	83.29	83.29	130500.0
2007-06-07 08:00:00	IWM	ETF	83.29	83.33	83.09	83.31	381700.0
2007-06-07 09:00:00	IWM	ETF	83.32	83.37	82.98	83.32	13830100.0
2007-06-07 10:00:00	IWM	ETF	83.33	83.45	82.9	83.0	15764932.0
2007-06-07 11:00:00	IWM	ETF	83.01	83.03	82.52	82.68	17649300.0
2007-06-07 12:00:00	IWM	ETF	82.67	82.86	82.27	82.44	11717439.0
2007-06-07 13:00:00	IWM	ETF	82.44	82.52	81.93	82.16	19861274.0
2007-06-07 14:00:00	IWM	ETF	82.15	82.43	81.93	82.34	12178615.0
2007-06-07 15:00:00	IWM	ETF	82.34	82.67	81.97	82.02	16898900.0
2007-06-07 16:00:00	IWM	ETF	82.01	82.1	81.4	81.8	2016300.0
2007-06-07 17:00:00	IWM	ETF	81.79	81.83	81.79	81.8	704000.0
2007-06-07 19:00:00	IWM	ETF	81.78	81.78	81.7	81.7	5100.0
2007-06-07 06:00:00	DIA	ETF	134.53	134.59	134.53	134.59	200.0
2007-06-07 07:00:00	DIA	ETF	134.62	134.7	134.54	134.55	35300.0
2007-06-07 08:00:00	DIA	ETF	134.46	134.53	134.2	134.33	114300.0
2007-06-07 09:00:00	DIA	ETF	134.34	134.79	134.25	134.71	1496100.0
2007-06-07 10:00:00	DIA	ETF	134.7	134.75	134.11	134.23	3736296.0
2007-06-07 11:00:00	DIA	ETF	134.22	134.25	133.61	133.82	3701200.0
2007-06-07 12:00:00	DIA	ETF	133.82	134.08	133.29	133.54	3260000.0
2007-06-07 13:00:00	DIA	ETF	133.54	133.56	132.79	133.18	3550990.0

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

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