PREVIEW / etf_1hour / 2007-12-14

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-14.parquet
  size:    93 KB
  rows:    3,102

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-12-14 04:00:00	SPY	ETF	148.99	148.99	148.86	148.86	1500.0
2007-12-14 05:00:00	SPY	ETF	148.97	148.98	148.79	148.79	18000.0
2007-12-14 06:00:00	SPY	ETF	148.73	148.73	148.37	148.54	31700.0
2007-12-14 07:00:00	SPY	ETF	148.6	148.81	148.19	148.79	695200.0
2007-12-14 08:00:00	SPY	ETF	148.75	149.04	147.87	148.02	10877700.0
2007-12-14 09:00:00	SPY	ETF	148.02	148.36	147.9	148.13	16239128.0
2007-12-14 10:00:00	SPY	ETF	148.13	149.0	148.11	148.97	23792654.0
2007-12-14 11:00:00	SPY	ETF	148.97	149.1	148.29	148.3999	15232795.0
2007-12-14 12:00:00	SPY	ETF	148.4	148.6	148.01	148.5	13007975.0
2007-12-14 13:00:00	SPY	ETF	148.51	148.64	148.13	148.28	8113455.0
2007-12-14 14:00:00	SPY	ETF	148.27	148.3	147.63	147.64	17173965.0
2007-12-14 15:00:00	SPY	ETF	147.64	147.99	147.17	147.18	41115630.0
2007-12-14 16:00:00	SPY	ETF	147.22	148.7	147.08	147.25	7721900.0
2007-12-14 17:00:00	SPY	ETF	147.25	147.28	147.1	147.1	57000.0
2007-12-14 18:00:00	SPY	ETF	147.1	147.23	146.9	147.23	40300.0
2007-12-14 19:00:00	SPY	ETF	147.07	147.17	147.02	147.16	7700.0
2007-12-14 07:00:00	QQQ	ETF	51.34	51.47	51.24	51.44	407003.0
2007-12-14 08:00:00	QQQ	ETF	51.45	51.53	50.95	51.11	11021487.0
2007-12-14 09:00:00	QQQ	ETF	51.12	51.29	51.07	51.17	13759982.0
2007-12-14 10:00:00	QQQ	ETF	51.17	51.59	51.16	51.57	20029118.0
2007-12-14 11:00:00	QQQ	ETF	51.57	51.6	51.27	51.3	18908684.0
2007-12-14 12:00:00	QQQ	ETF	51.3	51.39	51.15	51.28	8496811.0
2007-12-14 13:00:00	QQQ	ETF	51.28	51.4	51.23	51.32	6651868.0
2007-12-14 14:00:00	QQQ	ETF	51.31	51.39	51.14	51.1494	12157697.0
2007-12-14 15:00:00	QQQ	ETF	51.14	51.2	50.92	51.0	36356476.0
2007-12-14 16:00:00	QQQ	ETF	51.01	51.3875	50.9	50.96	3813527.0
2007-12-14 17:00:00	QQQ	ETF	50.96	50.99	50.93	50.97	18730.0
2007-12-14 18:00:00	QQQ	ETF	50.96	50.97	50.94	50.94	12613.0
2007-12-14 19:00:00	QQQ	ETF	50.96	51.01	50.94	50.94	23939.0
2007-12-14 07:00:00	IWM	ETF	76.03	76.24	76.03	76.19	17100.0
2007-12-14 08:00:00	IWM	ETF	76.1	76.3	75.72	75.74	692100.0
2007-12-14 09:00:00	IWM	ETF	75.74	76.05	75.66	75.78	8500995.0
2007-12-14 10:00:00	IWM	ETF	75.78	76.71	75.75	76.7	11370996.0
2007-12-14 11:00:00	IWM	ETF	76.7	76.87	76.16	76.17	6324344.0
2007-12-14 12:00:00	IWM	ETF	76.17	76.3	75.79	76.11	9250371.0
2007-12-14 13:00:00	IWM	ETF	76.11	76.17	75.85	75.94	5029110.0
2007-12-14 14:00:00	IWM	ETF	75.94	75.94	75.29	75.35	12199157.0
2007-12-14 15:00:00	IWM	ETF	75.35	75.72	75.09	75.16	19424377.0
2007-12-14 16:00:00	IWM	ETF	75.18	76.76	75.0	75.1	3306600.0
2007-12-14 17:00:00	IWM	ETF	75.11	75.2	75.11	75.18	7700.0
2007-12-14 18:00:00	IWM	ETF	75.18	75.19	75.07	75.18	4100.0
2007-12-14 07:00:00	DIA	ETF	134.58	134.85	134.51	134.85	4400.0
2007-12-14 08:00:00	DIA	ETF	134.77	134.92	134.28	134.3	123400.0
2007-12-14 09:00:00	DIA	ETF	134.3	134.42	134.13	134.2	1245735.0
2007-12-14 10:00:00	DIA	ETF	134.21	135.0	134.21	134.98	3499100.0
2007-12-14 11:00:00	DIA	ETF	135.0	135.13	134.37	134.4	1329000.0
2007-12-14 12:00:00	DIA	ETF	134.4	134.58	134.13	134.53	995256.0
2007-12-14 13:00:00	DIA	ETF	134.52	134.63	134.19	134.27	724015.0
2007-12-14 14:00:00	DIA	ETF	134.27	134.38	133.8	133.8	1059120.0
2007-12-14 15:00:00	DIA	ETF	133.79	134.14	133.42	133.47	3173992.0

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

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