PREVIEW / etf_1hour / 2007-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-08.parquet
  size:    87 KB
  rows:    2,934

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-08 04:00:00	SPY	ETF	147.99	147.99	147.99	147.99	2000.0
2007-08-08 06:00:00	SPY	ETF	148.2	148.2	148.2	148.2	10000.0
2007-08-08 07:00:00	SPY	ETF	148.2	148.77	148.2	148.65	1051800.0
2007-08-08 08:00:00	SPY	ETF	148.56	148.74	148.4	148.45	5366900.0
2007-08-08 09:00:00	SPY	ETF	148.45	149.04	148.35	148.84	31388326.0
2007-08-08 10:00:00	SPY	ETF	148.84	149.84	148.61	149.61	37136645.0
2007-08-08 11:00:00	SPY	ETF	149.61	149.66	148.83	149.18	27148341.0
2007-08-08 12:00:00	SPY	ETF	149.17	149.65	148.9	149.42	16587584.0
2007-08-08 13:00:00	SPY	ETF	149.41	150.14	149.38	149.97	17898592.0
2007-08-08 14:00:00	SPY	ETF	149.97	150.59	149.45	149.6	36542940.0
2007-08-08 15:00:00	SPY	ETF	149.59	149.9	147.34	149.87	86450854.0
2007-08-08 16:00:00	SPY	ETF	149.92	149.99	148.7604	149.82	6613100.0
2007-08-08 17:00:00	SPY	ETF	149.81	149.9	149.76	149.88	2328500.0
2007-08-08 18:00:00	SPY	ETF	149.85	149.98	149.81	149.98	231800.0
2007-08-08 19:00:00	SPY	ETF	149.96	149.96	149.92	149.93	2900.0
2007-08-08 06:00:00	QQQ	ETF	48.44	48.44	48.43	48.43	10000.0
2007-08-08 07:00:00	QQQ	ETF	48.47	48.64	48.47	48.62	251781.0
2007-08-08 08:00:00	QQQ	ETF	48.61	48.62	48.51	48.51	1007365.0
2007-08-08 09:00:00	QQQ	ETF	48.52	48.67	48.44	48.5899	20962576.0
2007-08-08 10:00:00	QQQ	ETF	48.59	48.83	48.56	48.74	26381619.0
2007-08-08 11:00:00	QQQ	ETF	48.7485	48.75	48.56	48.67	16122970.0
2007-08-08 12:00:00	QQQ	ETF	48.67	48.81	48.58	48.715	12257310.0
2007-08-08 13:00:00	QQQ	ETF	48.71	48.94	48.7	48.93	11239615.0
2007-08-08 14:00:00	QQQ	ETF	48.92	49.06	48.82	48.84	18725170.0
2007-08-08 15:00:00	QQQ	ETF	48.83	48.88	48.4	48.76	40040674.0
2007-08-08 16:00:00	QQQ	ETF	48.77	49.02	48.55	48.86	4727751.0
2007-08-08 17:00:00	QQQ	ETF	48.86	48.89	48.8	48.86	830165.0
2007-08-08 18:00:00	QQQ	ETF	48.85	48.88	48.81	48.83	449220.0
2007-08-08 19:00:00	QQQ	ETF	48.87	48.87	48.83	48.85	4400.0
2007-08-08 07:00:00	IWM	ETF	77.57	78.0	77.57	77.95	361900.0
2007-08-08 08:00:00	IWM	ETF	77.9	78.0	77.75	77.75	1143900.0
2007-08-08 09:00:00	IWM	ETF	77.74	79.14	77.71	78.88	44152430.0
2007-08-08 10:00:00	IWM	ETF	78.88	79.91	78.82	79.56	41440869.0
2007-08-08 11:00:00	IWM	ETF	79.56	79.8	79.04	79.35	24108876.0
2007-08-08 12:00:00	IWM	ETF	79.34	79.58	79.06	79.37	10746483.0
2007-08-08 13:00:00	IWM	ETF	79.38	79.85	79.3	79.84	15919723.0
2007-08-08 14:00:00	IWM	ETF	79.83	80.1	79.33	79.37	23974710.0
2007-08-08 15:00:00	IWM	ETF	79.37	79.52	77.96	79.24	59386412.0
2007-08-08 16:00:00	IWM	ETF	79.24	79.62	79.16	79.51	4869300.0
2007-08-08 17:00:00	IWM	ETF	79.48	79.5	79.46	79.5	350500.0
2007-08-08 18:00:00	IWM	ETF	79.49	79.55	79.47	79.54	197000.0
2007-08-08 19:00:00	IWM	ETF	79.55	79.55	79.55	79.55	400.0
2007-08-08 07:00:00	DIA	ETF	135.53	135.72	135.52	135.62	110600.0
2007-08-08 08:00:00	DIA	ETF	135.62	136.0	135.47	135.47	378700.0
2007-08-08 09:00:00	DIA	ETF	135.45	135.79	135.39	135.63	3028600.0
2007-08-08 10:00:00	DIA	ETF	135.64	136.22	135.53	136.08	4010900.0
2007-08-08 11:00:00	DIA	ETF	136.08	136.1	135.65	135.79	2790600.0
2007-08-08 12:00:00	DIA	ETF	135.8	136.22	135.59	135.98	1608300.0
2007-08-08 13:00:00	DIA	ETF	135.98	136.47	135.92	136.43	1819000.0
2007-08-08 14:00:00	DIA	ETF	136.43	136.96	135.99	136.13	4292500.0

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

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