PREVIEW / etf_1hour / 2007-10-22

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-22.parquet
  size:    92 KB
  rows:    3,060

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-10-22 04:00:00	SPY	ETF	149.25	149.25	149.0	149.0	32100.0
2007-10-22 05:00:00	SPY	ETF	148.88	148.88	148.76	148.76	13500.0
2007-10-22 06:00:00	SPY	ETF	148.75	148.81	148.5	148.6	169400.0
2007-10-22 07:00:00	SPY	ETF	148.61	148.83	148.51	148.55	1564700.0
2007-10-22 08:00:00	SPY	ETF	148.58	149.2	148.53	149.06	6790100.0
2007-10-22 09:00:00	SPY	ETF	149.08	149.94	148.66	149.64	54088055.0
2007-10-22 10:00:00	SPY	ETF	149.64	150.25	148.93	149.23	51416200.0
2007-10-22 11:00:00	SPY	ETF	149.23	150.002	149.03	149.91	27936900.0
2007-10-22 12:00:00	SPY	ETF	149.9	150.33	149.37	150.21	29336700.0
2007-10-22 13:00:00	SPY	ETF	150.21	150.76	150.13	150.15	30146586.0
2007-10-22 14:00:00	SPY	ETF	150.16	150.618	149.8	149.87	19080800.0
2007-10-22 15:00:00	SPY	ETF	149.86	150.63	149.47	150.59	31031900.0
2007-10-22 16:00:00	SPY	ETF	150.56	150.85	149.98	150.81	6745700.0
2007-10-22 17:00:00	SPY	ETF	150.76	150.96	149.7706	150.93	130200.0
2007-10-22 18:00:00	SPY	ETF	150.9	151.06	150.9	151.0	232400.0
2007-10-22 19:00:00	SPY	ETF	150.98	151.0	150.93	150.99	44100.0
2007-10-22 04:00:00	QQQ	ETF	52.21	52.21	52.1	52.1	600.0
2007-10-22 05:00:00	QQQ	ETF	52.08	52.09	52.07	52.08	46800.0
2007-10-22 06:00:00	QQQ	ETF	51.98	51.98	51.96	51.96	2100.0
2007-10-22 07:00:00	QQQ	ETF	51.98	52.09	51.95	52.0	1527315.0
2007-10-22 08:00:00	QQQ	ETF	52.0	52.26	51.99	52.19	2305677.0
2007-10-22 09:00:00	QQQ	ETF	52.19	52.74	52.02	52.6405	34837177.0
2007-10-22 10:00:00	QQQ	ETF	52.641	53.1185	52.46	52.58	43785501.0
2007-10-22 11:00:00	QQQ	ETF	52.58	52.85	52.47	52.85	19930900.0
2007-10-22 12:00:00	QQQ	ETF	52.8415	52.96	52.57	52.91	20652717.0
2007-10-22 13:00:00	QQQ	ETF	52.91	53.08	52.84	52.85	17096371.0
2007-10-22 14:00:00	QQQ	ETF	52.85	53.0	52.74	52.77	17462162.0
2007-10-22 15:00:00	QQQ	ETF	52.77	53.07	52.67	53.04	29962628.0
2007-10-22 16:00:00	QQQ	ETF	53.04	53.35	52.3847	53.3	19930849.0
2007-10-22 17:00:00	QQQ	ETF	53.3	53.41	53.27	53.37	991240.0
2007-10-22 18:00:00	QQQ	ETF	53.36	53.4	53.07	53.35	236217.0
2007-10-22 19:00:00	QQQ	ETF	53.36	53.4	53.36	53.4	24843.0
2007-10-22 04:00:00	IWM	ETF	78.65	78.65	78.65	78.65	100.0
2007-10-22 06:00:00	IWM	ETF	78.51	78.54	78.51	78.54	10000.0
2007-10-22 07:00:00	IWM	ETF	78.28	78.4	78.25	78.34	26800.0
2007-10-22 08:00:00	IWM	ETF	78.35	78.81	78.29	78.79	2647400.0
2007-10-22 09:00:00	IWM	ETF	78.78	79.65	78.35	79.45	23411753.0
2007-10-22 10:00:00	IWM	ETF	79.45	80.09	78.88	79.1	24430100.0
2007-10-22 11:00:00	IWM	ETF	79.1	79.93	78.94	79.92	14835500.0
2007-10-22 12:00:00	IWM	ETF	79.93	80.55	79.5	80.41	16775400.0
2007-10-22 13:00:00	IWM	ETF	80.42	80.8	80.31	80.32	21728300.0
2007-10-22 14:00:00	IWM	ETF	80.33	80.56	80.03	80.14	9700100.0
2007-10-22 15:00:00	IWM	ETF	80.13	80.94	79.92	80.78	18942000.0
2007-10-22 16:00:00	IWM	ETF	80.78	81.05	79.54	81.0	5808900.0
2007-10-22 17:00:00	IWM	ETF	80.91	81.1	80.91	81.1	26600.0
2007-10-22 18:00:00	IWM	ETF	81.09	81.11	81.02	81.02	53300.0
2007-10-22 19:00:00	IWM	ETF	81.03	81.06	81.02	81.03	4900.0
2007-10-22 07:00:00	DIA	ETF	133.94	134.01	133.7	133.7	51800.0
2007-10-22 08:00:00	DIA	ETF	133.78	134.32	133.75	134.28	51300.0
2007-10-22 09:00:00	DIA	ETF	134.27	134.86	133.92	134.64	2884734.0

> showing 50 of 3,060 rows — these rows as CSV

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