PREVIEW / etf_1hour / 2007-08-27

all etf 1-hour files

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

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-08-27 04:00:00	SPY	ETF	147.85	147.85	147.85	147.85	100.0
2007-08-27 06:00:00	SPY	ETF	147.86	147.86	147.86	147.86	3100.0
2007-08-27 07:00:00	SPY	ETF	147.9	148.1	147.83	148.01	209100.0
2007-08-27 08:00:00	SPY	ETF	148.06	148.06	147.8	147.89	1190300.0
2007-08-27 09:00:00	SPY	ETF	147.89	147.94	147.46	147.72	11775827.0
2007-08-27 10:00:00	SPY	ETF	147.71	147.9	147.22	147.39	19391575.0
2007-08-27 11:00:00	SPY	ETF	147.39	147.42	146.97	147.27	11826281.0
2007-08-27 12:00:00	SPY	ETF	147.27	147.51	147.08	147.28	8390557.0
2007-08-27 13:00:00	SPY	ETF	147.2795	148.33	147.1	147.24	9894520.0
2007-08-27 14:00:00	SPY	ETF	147.25	147.78	147.19	147.35	12981251.0
2007-08-27 15:00:00	SPY	ETF	147.34	147.5	146.81	146.91	20267236.0
2007-08-27 16:00:00	SPY	ETF	146.98	148.207	146.73	146.91	12767800.0
2007-08-27 17:00:00	SPY	ETF	146.93	146.95	146.85	146.85	35600.0
2007-08-27 18:00:00	SPY	ETF	146.89	146.95	146.75	146.75	90000.0
2007-08-27 19:00:00	SPY	ETF	146.81	146.83	146.76	146.76	21100.0
2007-08-27 07:00:00	QQQ	ETF	48.13	48.18	48.13	48.18	25299.0
2007-08-27 08:00:00	QQQ	ETF	48.17	48.17	48.11	48.11	300920.0
2007-08-27 09:00:00	QQQ	ETF	48.12	48.17	48.0	48.14	9889395.0
2007-08-27 10:00:00	QQQ	ETF	48.14	48.2	47.96	48.03	8851497.0
2007-08-27 11:00:00	QQQ	ETF	48.03	48.03	47.84	47.92	7154838.0
2007-08-27 12:00:00	QQQ	ETF	47.926	48.09	47.85	48.03	7998726.0
2007-08-27 13:00:00	QQQ	ETF	48.04	48.17	47.98	48.0272	5143475.0
2007-08-27 14:00:00	QQQ	ETF	48.03	48.2	48.01	48.06	8386949.0
2007-08-27 15:00:00	QQQ	ETF	48.06	48.1	47.88	47.88	11064617.0
2007-08-27 16:00:00	QQQ	ETF	47.9	47.9	47.76	47.81	4040822.0
2007-08-27 17:00:00	QQQ	ETF	47.81	47.88	47.81	47.88	92999.0
2007-08-27 18:00:00	QQQ	ETF	47.87	47.87	47.79	47.79	11117.0
2007-08-27 19:00:00	QQQ	ETF	47.81	47.84	47.8	47.83	10500.0
2007-08-27 07:00:00	IWM	ETF	79.47	79.54	79.46	79.49	15400.0
2007-08-27 08:00:00	IWM	ETF	79.49	79.49	79.36	79.4	80100.0
2007-08-27 09:00:00	IWM	ETF	79.38	79.47	79.0	79.12	6682294.0
2007-08-27 10:00:00	IWM	ETF	79.12	79.27	78.71	78.88	10406991.0
2007-08-27 11:00:00	IWM	ETF	78.88	78.89	78.49	78.73	3676558.0
2007-08-27 12:00:00	IWM	ETF	78.72	78.89	78.56	78.76	2624505.0
2007-08-27 13:00:00	IWM	ETF	78.77	79.63	78.59	78.67	3133175.0
2007-08-27 14:00:00	IWM	ETF	78.67	79.22	78.63	79.0	4691067.0
2007-08-27 15:00:00	IWM	ETF	79.0	79.06	78.53	78.62	8635443.0
2007-08-27 16:00:00	IWM	ETF	78.62	78.67	78.53	78.58	10320800.0
2007-08-27 17:00:00	IWM	ETF	78.61	78.61	78.54	78.56	1502700.0
2007-08-27 18:00:00	IWM	ETF	78.56	78.56	78.56	78.56	1400.0
2007-08-27 19:00:00	IWM	ETF	78.56	78.56	78.56	78.56	400.0
2007-08-27 07:00:00	DIA	ETF	133.43	133.48	133.43	133.48	3200.0
2007-08-27 08:00:00	DIA	ETF	133.6	133.6	133.4	133.41	44200.0
2007-08-27 09:00:00	DIA	ETF	133.42	133.45	133.2	133.43	691700.0
2007-08-27 10:00:00	DIA	ETF	133.42	133.54	132.98	133.28	1587744.0
2007-08-27 11:00:00	DIA	ETF	133.28	133.29	133.02	133.27	650700.0
2007-08-27 12:00:00	DIA	ETF	133.27	133.55	133.16	133.43	557700.0
2007-08-27 13:00:00	DIA	ETF	133.44	133.73	133.27	133.4	1023140.0
2007-08-27 14:00:00	DIA	ETF	133.42	133.79	133.37	133.49	995610.0
2007-08-27 15:00:00	DIA	ETF	133.52	133.54	133.09	133.1	1473398.0

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

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