PREVIEW / etf_1hour / 2007-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-31.parquet
  size:    90 KB
  rows:    3,000

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-07-31 05:00:00	SPY	ETF	147.89	147.89	147.89	147.89	5000.0
2007-07-31 06:00:00	SPY	ETF	147.88	148.2	147.88	148.2	303300.0
2007-07-31 07:00:00	SPY	ETF	148.22	148.7	148.22	148.55	3529500.0
2007-07-31 08:00:00	SPY	ETF	148.58	148.95	147.23	148.23	12412900.0
2007-07-31 09:00:00	SPY	ETF	148.23	149.32	147.22	148.47	26932923.0
2007-07-31 10:00:00	SPY	ETF	148.48	149.46	147.38	147.7	53685129.0
2007-07-31 11:00:00	SPY	ETF	147.69	148.73	147.53	148.2	30223921.0
2007-07-31 12:00:00	SPY	ETF	148.1901	148.39	148.0	148.19	14670691.0
2007-07-31 13:00:00	SPY	ETF	148.2	149.18	147.28	147.73	32322268.0
2007-07-31 14:00:00	SPY	ETF	147.73	147.92	146.37	146.79	55105093.0
2007-07-31 15:00:00	SPY	ETF	146.79	147.33	145.39	145.39	59874831.0
2007-07-31 16:00:00	SPY	ETF	145.33	147.3804	145.05	145.61	15869000.0
2007-07-31 17:00:00	SPY	ETF	145.62	145.7	145.48	145.5	2773100.0
2007-07-31 18:00:00	SPY	ETF	145.52	145.52	145.06	145.08	612600.0
2007-07-31 19:00:00	SPY	ETF	145.11	145.17	144.96	144.98	146700.0
2007-07-31 04:00:00	QQQ	ETF	48.69	48.73	48.69	48.73	400.0
2007-07-31 06:00:00	QQQ	ETF	48.92	48.92	48.92	48.92	50000.0
2007-07-31 07:00:00	QQQ	ETF	48.95	49.15	48.85	48.92	1296857.0
2007-07-31 08:00:00	QQQ	ETF	48.92	49.1	48.85	48.86	5969792.0
2007-07-31 09:00:00	QQQ	ETF	48.86	48.98	48.79	48.91	19538463.0
2007-07-31 10:00:00	QQQ	ETF	48.91	49.93	48.31	48.456	48943920.0
2007-07-31 11:00:00	QQQ	ETF	48.45	48.56	48.31	48.51	27593105.0
2007-07-31 12:00:00	QQQ	ETF	48.51	48.57	48.3705	48.41	21157246.0
2007-07-31 13:00:00	QQQ	ETF	48.41	48.5	48.08	48.27	17835088.0
2007-07-31 14:00:00	QQQ	ETF	48.27	48.79	47.77	47.9	48393916.0
2007-07-31 15:00:00	QQQ	ETF	47.89	48.19	47.45	47.45	47703664.0
2007-07-31 16:00:00	QQQ	ETF	47.46	48.87	47.43	47.62	4598252.0
2007-07-31 17:00:00	QQQ	ETF	47.62	47.67	47.57	47.6	4247467.0
2007-07-31 18:00:00	QQQ	ETF	47.6	47.61	47.43	47.43	235238.0
2007-07-31 19:00:00	QQQ	ETF	47.42	47.46	47.38	47.39	70391.0
2007-07-31 05:00:00	IWM	ETF	78.23	78.24	78.23	78.24	1300.0
2007-07-31 06:00:00	IWM	ETF	78.32	78.33	78.32	78.33	3000.0
2007-07-31 07:00:00	IWM	ETF	78.41	79.7	78.41	78.9	1229200.0
2007-07-31 08:00:00	IWM	ETF	78.87	79.12	78.8	78.83	3592800.0
2007-07-31 09:00:00	IWM	ETF	78.83	78.94	78.52	78.84	16202420.0
2007-07-31 10:00:00	IWM	ETF	78.84	79.15	77.94	78.18	34527210.0
2007-07-31 11:00:00	IWM	ETF	78.18	79.0	78.11	78.67	9832475.0
2007-07-31 12:00:00	IWM	ETF	78.67	78.8	78.56	78.75	6832161.0
2007-07-31 13:00:00	IWM	ETF	78.75	78.99	78.2	78.56	12147378.0
2007-07-31 14:00:00	IWM	ETF	78.57	78.68	77.57	77.95	35234948.0
2007-07-31 15:00:00	IWM	ETF	77.94	78.35	76.95	77.03	44433134.0
2007-07-31 16:00:00	IWM	ETF	77.03	77.2	76.74	77.02	4364700.0
2007-07-31 17:00:00	IWM	ETF	77.06	77.09	76.87	76.92	619600.0
2007-07-31 18:00:00	IWM	ETF	76.95	77.01	76.7	76.87	235300.0
2007-07-31 19:00:00	IWM	ETF	76.81	76.83	76.74	76.78	12200.0
2007-07-31 07:00:00	DIA	ETF	134.24	134.84	134.2	134.53	235200.0
2007-07-31 08:00:00	DIA	ETF	134.48	134.64	134.31	134.31	178100.0
2007-07-31 09:00:00	DIA	ETF	134.27	134.62	134.13	134.54	2177800.0
2007-07-31 10:00:00	DIA	ETF	134.55	134.83	133.68	133.89	4818500.0
2007-07-31 11:00:00	DIA	ETF	133.9	134.37	133.78	134.25	2054200.0

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

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