PREVIEW / etf_1hour / 2007-08-17

all etf 1-hour files

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

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-17 04:00:00	SPY	ETF	141.58	141.6	141.3	141.6	11100.0
2007-08-17 05:00:00	SPY	ETF	141.46	141.47	140.7	140.9	4800.0
2007-08-17 06:00:00	SPY	ETF	140.7	141.19	140.54	140.8	266200.0
2007-08-17 07:00:00	SPY	ETF	140.8	141.47	140.64	141.45	2457100.0
2007-08-17 08:00:00	SPY	ETF	141.44	163.61	140.7	144.67	40685900.0
2007-08-17 09:00:00	SPY	ETF	144.63	145.83	143.62	144.17	63662198.0
2007-08-17 10:00:00	SPY	ETF	144.16	145.53	142.32	143.1	73022426.0
2007-08-17 11:00:00	SPY	ETF	143.1	148.35	142.65	143.4	43181163.0
2007-08-17 12:00:00	SPY	ETF	143.39	144.17	143.03	143.65	26255728.0
2007-08-17 13:00:00	SPY	ETF	143.65	145.264	143.65	144.04	37706502.0
2007-08-17 14:00:00	SPY	ETF	144.04	145.2	142.6	144.12	22501645.0
2007-08-17 15:00:00	SPY	ETF	144.12	145.9	144.01	144.74	60927649.0
2007-08-17 16:00:00	SPY	ETF	144.63	145.75	141.6	141.6	8075200.0
2007-08-17 17:00:00	SPY	ETF	144.75	145.6	143.505	144.88	1009800.0
2007-08-17 18:00:00	SPY	ETF	144.8	144.99	144.7	144.85	79800.0
2007-08-17 19:00:00	SPY	ETF	144.8	144.8	144.7	144.8	37900.0
2007-08-17 04:00:00	QQQ	ETF	45.3	45.35	45.27	45.35	700.0
2007-08-17 05:00:00	QQQ	ETF	45.1	45.1	45.1	45.1	200.0
2007-08-17 06:00:00	QQQ	ETF	45.07	45.21	45.05	45.21	73200.0
2007-08-17 07:00:00	QQQ	ETF	45.13	45.26	44.99	45.24	1294316.0
2007-08-17 08:00:00	QQQ	ETF	45.24	47.14	45.22	46.13	20058938.0
2007-08-17 09:00:00	QQQ	ETF	46.14	46.5895	46.0	46.03	47164905.0
2007-08-17 10:00:00	QQQ	ETF	46.03	46.16	45.589	45.79	42447212.0
2007-08-17 11:00:00	QQQ	ETF	45.79	46.11	45.64	45.9	27463174.0
2007-08-17 12:00:00	QQQ	ETF	45.9099	46.0	45.71	45.89	15085457.0
2007-08-17 13:00:00	QQQ	ETF	45.89	46.26	45.88	46.08	14585494.0
2007-08-17 14:00:00	QQQ	ETF	46.08	46.19	45.97	46.176	11968678.0
2007-08-17 15:00:00	QQQ	ETF	46.17	46.49	46.13	46.42	30753930.0
2007-08-17 16:00:00	QQQ	ETF	46.42	46.5	46.25	46.34	4162531.0
2007-08-17 17:00:00	QQQ	ETF	46.34	46.35	45.9	46.34	301193.0
2007-08-17 18:00:00	QQQ	ETF	46.34	46.39	46.34	46.38	46350.0
2007-08-17 19:00:00	QQQ	ETF	46.38	46.4	46.38	46.39	6950.0
2007-08-17 06:00:00	IWM	ETF	75.69	75.88	75.69	75.88	4500.0
2007-08-17 07:00:00	IWM	ETF	75.9	76.4	75.8	76.4	410300.0
2007-08-17 08:00:00	IWM	ETF	76.4	85.95	76.03	79.17	13907900.0
2007-08-17 09:00:00	IWM	ETF	79.16	80.06	78.8	78.93	39778920.0
2007-08-17 10:00:00	IWM	ETF	78.93	79.2	77.22	77.86	42664360.0
2007-08-17 11:00:00	IWM	ETF	77.85	78.87	76.59	78.4	29807923.0
2007-08-17 12:00:00	IWM	ETF	78.4	78.52	77.99	78.17	14757509.0
2007-08-17 13:00:00	IWM	ETF	78.16	78.94	78.14	78.36	21625176.0
2007-08-17 14:00:00	IWM	ETF	78.37	78.65	78.12	78.56	12969031.0
2007-08-17 15:00:00	IWM	ETF	78.55	79.06	78.16	78.25	29769354.0
2007-08-17 16:00:00	IWM	ETF	78.25	79.8	78.19	78.45	2443800.0
2007-08-17 17:00:00	IWM	ETF	78.43	79.455	78.19	78.31	577900.0
2007-08-17 18:00:00	IWM	ETF	78.31	80.0	78.31	78.4	227400.0
2007-08-17 07:00:00	DIA	ETF	127.92	128.2	127.72	128.2	140400.0
2007-08-17 08:00:00	DIA	ETF	128.26	131.54	127.83	130.48	931200.0
2007-08-17 09:00:00	DIA	ETF	130.48	131.86	130.1	130.31	5959700.0
2007-08-17 10:00:00	DIA	ETF	130.31	130.71	128.95	129.48	7330800.0
2007-08-17 11:00:00	DIA	ETF	129.49	130.22	129.18	129.63	4161100.0

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

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