PREVIEW / etf_1hour / 2007-03-30

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-30.parquet
  size:    68 KB
  rows:    2,144

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-03-30 06:00:00	SPY	ETF	141.98	142.04	141.98	142.04	6000.0
2007-03-30 07:00:00	SPY	ETF	142.01	142.24	142.01	142.2	292800.0
2007-03-30 08:00:00	SPY	ETF	142.04	142.49	141.91	142.31	3166400.0
2007-03-30 09:00:00	SPY	ETF	142.33	142.84	142.12	142.56	15818475.0
2007-03-30 10:00:00	SPY	ETF	142.57	142.77	142.19	142.37	14262895.0
2007-03-30 11:00:00	SPY	ETF	142.36	142.44	140.56	141.52	34764705.0
2007-03-30 12:00:00	SPY	ETF	141.48	141.73	141.28	141.48	16880925.0
2007-03-30 13:00:00	SPY	ETF	141.47	142.6	141.45	141.76	8396600.0
2007-03-30 14:00:00	SPY	ETF	141.76	142.24	141.7	142.06	10574566.0
2007-03-30 15:00:00	SPY	ETF	142.06	142.15	141.77	141.94	13200214.0
2007-03-30 16:00:00	SPY	ETF	141.93	142.11	141.9	142.0	5162000.0
2007-03-30 17:00:00	SPY	ETF	142.02	142.06	142.01	142.01	62200.0
2007-03-30 18:00:00	SPY	ETF	142.03	142.03	142.0	142.0	6300.0
2007-03-30 19:00:00	SPY	ETF	142.0	142.0	142.0	142.0	400.0
2007-03-30 06:00:00	QQQ	ETF	43.5	43.5	43.5	43.5	3327.0
2007-03-30 07:00:00	QQQ	ETF	43.5	43.56	43.45	43.54	324332.0
2007-03-30 08:00:00	QQQ	ETF	43.55	43.73	43.44	43.6	1907455.0
2007-03-30 09:00:00	QQQ	ETF	43.6	43.87	43.55	43.7	17470027.0
2007-03-30 10:00:00	QQQ	ETF	43.7	43.76	43.58	43.7	16072400.0
2007-03-30 11:00:00	QQQ	ETF	43.69	43.73	43.22	43.47	30219400.0
2007-03-30 12:00:00	QQQ	ETF	43.48	43.52	43.35	43.41	12849100.0
2007-03-30 13:00:00	QQQ	ETF	43.41	43.63	43.39	43.54	11507300.0
2007-03-30 14:00:00	QQQ	ETF	43.54	43.71	43.5	43.62	8412400.0
2007-03-30 15:00:00	QQQ	ETF	43.62	43.63	43.51	43.55	13900500.0
2007-03-30 16:00:00	QQQ	ETF	43.54	43.65	43.52	43.58	7034821.0
2007-03-30 17:00:00	QQQ	ETF	43.58	43.59	43.52	43.53	91323.0
2007-03-30 18:00:00	QQQ	ETF	43.57	43.59	43.54	43.54	11100.0
2007-03-30 19:00:00	QQQ	ETF	43.56	43.56	43.55	43.55	2200.0
2007-03-30 07:00:00	IWM	ETF	79.3	79.3	79.3	79.3	11000.0
2007-03-30 08:00:00	IWM	ETF	79.33	79.47	79.22	79.35	428500.0
2007-03-30 09:00:00	IWM	ETF	79.4	80.06	79.33	79.7	7020766.0
2007-03-30 10:00:00	IWM	ETF	79.7	79.87	79.47	79.62	6666282.0
2007-03-30 11:00:00	IWM	ETF	79.61	79.67	78.73	78.97	13600875.0
2007-03-30 12:00:00	IWM	ETF	78.96	79.12	78.79	79.03	6777172.0
2007-03-30 13:00:00	IWM	ETF	79.03	79.32	78.98	79.2501	4596800.0
2007-03-30 14:00:00	IWM	ETF	79.26	79.53	79.22	79.34	4746000.0
2007-03-30 15:00:00	IWM	ETF	79.34	79.4	79.03	79.35	7741100.0
2007-03-30 16:00:00	IWM	ETF	79.33	79.63	79.2985	79.51	1436500.0
2007-03-30 17:00:00	IWM	ETF	79.51	79.51	79.41	79.41	9000.0
2007-03-30 19:00:00	IWM	ETF	79.56	79.56	79.56	79.56	200.0
2007-03-30 07:00:00	DIA	ETF	123.35	123.35	123.35	123.35	100.0
2007-03-30 08:00:00	DIA	ETF	123.44	123.55	123.32	123.43	11000.0
2007-03-30 09:00:00	DIA	ETF	123.39	123.98	123.32	123.88	1375600.0
2007-03-30 10:00:00	DIA	ETF	123.88	124.06	123.56	123.72	1684100.0
2007-03-30 11:00:00	DIA	ETF	123.71	123.77	122.33	122.93	3044200.0
2007-03-30 12:00:00	DIA	ETF	122.9	123.19	122.72	122.99	1072173.0
2007-03-30 13:00:00	DIA	ETF	122.99	123.28	122.97	123.18	873025.0
2007-03-30 14:00:00	DIA	ETF	123.2	123.6	123.13	123.49	720800.0
2007-03-30 15:00:00	DIA	ETF	123.49	123.52	123.23	123.41	901539.0
2007-03-30 16:00:00	DIA	ETF	123.42	123.6	123.38	123.6	56900.0

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

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