PREVIEW / etf_1hour / 2007-10-08

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-08.parquet
  size:    83 KB
  rows:    2,837

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-08 05:00:00	SPY	ETF	155.39	155.44	155.39	155.44	1500.0
2007-10-08 06:00:00	SPY	ETF	155.44	155.44	155.37	155.42	25500.0
2007-10-08 07:00:00	SPY	ETF	155.39	155.54	155.26	155.49	450600.0
2007-10-08 08:00:00	SPY	ETF	155.44	155.47	155.34	155.4	1095700.0
2007-10-08 09:00:00	SPY	ETF	155.4	155.46	155.16	155.29	10993016.0
2007-10-08 10:00:00	SPY	ETF	155.3	155.49	155.19	155.23	10339200.0
2007-10-08 11:00:00	SPY	ETF	155.23	155.23	154.81	154.95	11939600.0
2007-10-08 12:00:00	SPY	ETF	154.95	155.06	154.8	155.03	6619400.0
2007-10-08 13:00:00	SPY	ETF	155.03	155.11	154.8	154.88	7778800.0
2007-10-08 14:00:00	SPY	ETF	154.87	155.12	154.77	154.92	7103600.0
2007-10-08 15:00:00	SPY	ETF	154.92	155.2	154.89	155.19	10443100.0
2007-10-08 16:00:00	SPY	ETF	155.18	155.31	155.0	155.1264	3334000.0
2007-10-08 17:00:00	SPY	ETF	155.14	155.2	155.12	155.2	37600.0
2007-10-08 18:00:00	SPY	ETF	155.2	155.26	155.19	155.19	94200.0
2007-10-08 19:00:00	SPY	ETF	155.23	155.24	155.22	155.22	3400.0
2007-10-08 05:00:00	QQQ	ETF	52.82	52.82	52.82	52.82	500.0
2007-10-08 06:00:00	QQQ	ETF	52.75	52.77	52.75	52.77	10215.0
2007-10-08 07:00:00	QQQ	ETF	52.73	52.76	52.69	52.75	267955.0
2007-10-08 08:00:00	QQQ	ETF	52.75	52.8	52.71	52.78	1164721.0
2007-10-08 09:00:00	QQQ	ETF	52.78	52.93	52.73	52.9	6400082.0
2007-10-08 10:00:00	QQQ	ETF	52.91	52.99	52.87	52.879	8162739.0
2007-10-08 11:00:00	QQQ	ETF	52.8799	52.88	52.71	52.8	6286111.0
2007-10-08 12:00:00	QQQ	ETF	52.79	52.91	52.71	52.89	4813116.0
2007-10-08 13:00:00	QQQ	ETF	52.89	52.95	52.81	52.84	3118150.0
2007-10-08 14:00:00	QQQ	ETF	52.84	53.01	52.79	52.94	7668314.0
2007-10-08 15:00:00	QQQ	ETF	52.94	53.16	52.91	53.15	14168305.0
2007-10-08 16:00:00	QQQ	ETF	53.16	53.1778	52.66	53.12	11261261.0
2007-10-08 17:00:00	QQQ	ETF	53.12	53.15	53.09	53.09	33185.0
2007-10-08 18:00:00	QQQ	ETF	53.12	53.14	53.11	53.11	58116.0
2007-10-08 19:00:00	QQQ	ETF	53.12	53.14	53.11	53.14	9590.0
2007-10-08 07:00:00	IWM	ETF	83.93	84.0	83.87	84.0	18700.0
2007-10-08 08:00:00	IWM	ETF	83.94	83.97	83.87	83.89	119200.0
2007-10-08 09:00:00	IWM	ETF	83.88	83.99	83.67	83.77	4337900.0
2007-10-08 10:00:00	IWM	ETF	83.77	84.18	83.75	83.79	5103900.0
2007-10-08 11:00:00	IWM	ETF	83.79	83.79	83.3	83.53	8034320.0
2007-10-08 12:00:00	IWM	ETF	83.53	83.67	83.41	83.63	2526500.0
2007-10-08 13:00:00	IWM	ETF	83.63	83.64	83.33	83.4	2586200.0
2007-10-08 14:00:00	IWM	ETF	83.39	83.6	83.25	83.36	4952700.0
2007-10-08 15:00:00	IWM	ETF	83.36	83.73	83.34	83.53	5420200.0
2007-10-08 16:00:00	IWM	ETF	83.53	83.61	83.41	83.58	1430200.0
2007-10-08 18:00:00	IWM	ETF	83.59	83.59	83.54	83.54	5500.0
2007-10-08 07:00:00	DIA	ETF	140.45	140.45	140.45	140.45	200.0
2007-10-08 08:00:00	DIA	ETF	140.59	140.6	140.57	140.57	3800.0
2007-10-08 09:00:00	DIA	ETF	140.57	140.58	140.37	140.48	1139400.0
2007-10-08 10:00:00	DIA	ETF	140.48	140.56	140.42	140.45	847000.0
2007-10-08 11:00:00	DIA	ETF	140.43	140.45	140.15	140.25	831400.0
2007-10-08 12:00:00	DIA	ETF	140.24	140.3	140.1	140.27	363300.0
2007-10-08 13:00:00	DIA	ETF	140.26	140.33	140.01	140.14	325700.0
2007-10-08 14:00:00	DIA	ETF	140.14	140.36	140.05	140.2	412800.0
2007-10-08 15:00:00	DIA	ETF	140.21	140.44	140.2	140.38	682800.0

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

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