PREVIEW / etf_1hour / 2007-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-14.parquet
  size:    90 KB
  rows:    3,001

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-11-14 04:00:00	SPY	ETF	148.27	148.47	148.27	148.34	6000.0
2007-11-14 05:00:00	SPY	ETF	148.34	148.49	148.34	148.42	64500.0
2007-11-14 06:00:00	SPY	ETF	148.07	148.07	147.91	147.91	80000.0
2007-11-14 07:00:00	SPY	ETF	147.94	148.15	147.58	148.15	1268300.0
2007-11-14 08:00:00	SPY	ETF	148.14	149.41	147.62	149.1	20107900.0
2007-11-14 09:00:00	SPY	ETF	149.09	149.4	148.51	148.66	32385639.0
2007-11-14 10:00:00	SPY	ETF	148.66	148.95	148.3	148.54	34306654.0
2007-11-14 11:00:00	SPY	ETF	148.54	148.91	148.15	148.78	21063221.0
2007-11-14 12:00:00	SPY	ETF	148.78	149.26	148.6	148.63	15573628.0
2007-11-14 13:00:00	SPY	ETF	148.63	149.12	148.39	148.4	12406346.0
2007-11-14 14:00:00	SPY	ETF	148.39	149.07	148.3	148.46	17341203.0
2007-11-14 15:00:00	SPY	ETF	148.44	148.86	146.78	147.1	56044571.0
2007-11-14 16:00:00	SPY	ETF	147.06	149.2	146.9	147.75	12446800.0
2007-11-14 17:00:00	SPY	ETF	147.75	147.79	147.25	147.4	2945100.0
2007-11-14 18:00:00	SPY	ETF	147.53	147.7	147.47	147.58	439200.0
2007-11-14 19:00:00	SPY	ETF	147.57	147.63	147.46	147.58	22900.0
2007-11-14 04:00:00	QQQ	ETF	50.66	50.66	50.66	50.66	800.0
2007-11-14 05:00:00	QQQ	ETF	50.67	50.76	50.67	50.76	52900.0
2007-11-14 06:00:00	QQQ	ETF	50.77	50.79	50.64	50.67	36810.0
2007-11-14 07:00:00	QQQ	ETF	50.62	50.64	50.5	50.63	333708.0
2007-11-14 08:00:00	QQQ	ETF	50.64	51.45	50.59	51.4	12576545.0
2007-11-14 09:00:00	QQQ	ETF	51.4	51.49	50.81	50.88	42895181.0
2007-11-14 10:00:00	QQQ	ETF	50.87	51.09	50.8	50.88	30781449.0
2007-11-14 11:00:00	QQQ	ETF	50.89	50.98	50.58	50.8514	28974992.0
2007-11-14 12:00:00	QQQ	ETF	50.86	51.15	50.83	50.88	22808101.0
2007-11-14 13:00:00	QQQ	ETF	50.88	51.11	50.71	50.72	20767342.0
2007-11-14 14:00:00	QQQ	ETF	50.73	50.95	50.6	50.6	27251906.0
2007-11-14 15:00:00	QQQ	ETF	50.6	50.73	49.9	50.08	59450172.0
2007-11-14 16:00:00	QQQ	ETF	50.08	50.8085	49.9436	50.31	14310627.0
2007-11-14 17:00:00	QQQ	ETF	50.29	50.31	49.98	50.03	712027.0
2007-11-14 18:00:00	QQQ	ETF	50.07	50.19	49.99	50.11	2273489.0
2007-11-14 19:00:00	QQQ	ETF	50.1	50.17	50.08	50.13	59292.0
2007-11-14 07:00:00	IWM	ETF	78.21	78.48	78.12	78.48	52700.0
2007-11-14 08:00:00	IWM	ETF	78.48	79.22	78.45	79.15	2214300.0
2007-11-14 09:00:00	IWM	ETF	79.12	79.23	78.65	78.73	12289152.0
2007-11-14 10:00:00	IWM	ETF	78.73	79.0	78.34	78.48	11863799.0
2007-11-14 11:00:00	IWM	ETF	78.48	78.59	78.1	78.52	8305595.0
2007-11-14 12:00:00	IWM	ETF	78.53	78.75	78.39	78.39	4832236.0
2007-11-14 13:00:00	IWM	ETF	78.4	78.72	78.24	78.26	6747990.0
2007-11-14 14:00:00	IWM	ETF	78.26	78.58	78.14	78.16	7686114.0
2007-11-14 15:00:00	IWM	ETF	78.16	78.44	77.6	77.82	20556161.0
2007-11-14 16:00:00	IWM	ETF	77.83	78.63	77.83	78.21	2647300.0
2007-11-14 17:00:00	IWM	ETF	78.24	78.25	77.89	77.9	14100.0
2007-11-14 18:00:00	IWM	ETF	78.0	78.1	77.75	77.9	137900.0
2007-11-14 07:00:00	DIA	ETF	133.14	133.26	133.14	133.26	9900.0
2007-11-14 08:00:00	DIA	ETF	133.26	134.16	133.19	133.97	301300.0
2007-11-14 09:00:00	DIA	ETF	133.9	134.0	133.29	133.4	2091986.0
2007-11-14 10:00:00	DIA	ETF	133.4	133.62	133.06	133.33	2071153.0
2007-11-14 11:00:00	DIA	ETF	133.34	133.57	133.02	133.5	1466410.0
2007-11-14 12:00:00	DIA	ETF	133.51	133.87	133.35	133.4	971000.0

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

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