PREVIEW / etf_1hour / 2007-07-10

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-10.parquet
  size:    82 KB
  rows:    2,730

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-10 04:00:00	SPY	ETF	152.92	152.92	152.92	152.92	100.0
2007-07-10 06:00:00	SPY	ETF	152.78	152.83	152.78	152.8	19000.0
2007-07-10 07:00:00	SPY	ETF	152.84	152.84	152.56	152.6	860300.0
2007-07-10 08:00:00	SPY	ETF	152.6	152.83	152.35	152.35	2524000.0
2007-07-10 09:00:00	SPY	ETF	152.35	152.6	151.81	152.05	27276517.0
2007-07-10 10:00:00	SPY	ETF	152.05	152.36	151.89	152.16	25749833.0
2007-07-10 11:00:00	SPY	ETF	152.16	152.61	152.16	152.41	16383109.0
2007-07-10 12:00:00	SPY	ETF	152.41	152.52	152.11	152.3	5978413.0
2007-07-10 13:00:00	SPY	ETF	152.3	152.5	151.37	151.55	32018806.0
2007-07-10 14:00:00	SPY	ETF	151.55	151.82	151.27	151.51	26774593.0
2007-07-10 15:00:00	SPY	ETF	151.5	151.6	150.87	150.89	30595587.0
2007-07-10 16:00:00	SPY	ETF	150.89	152.714	150.75	150.86	6579600.0
2007-07-10 17:00:00	SPY	ETF	150.86	152.9	150.82	150.87	702000.0
2007-07-10 18:00:00	SPY	ETF	150.9	150.9	150.79	150.85	12200.0
2007-07-10 19:00:00	SPY	ETF	150.86	150.95	150.85	150.9	6100.0
2007-07-10 07:00:00	QQQ	ETF	48.77	48.77	48.7	48.7	1013593.0
2007-07-10 08:00:00	QQQ	ETF	48.71	48.72	48.64	48.67	1730811.0
2007-07-10 09:00:00	QQQ	ETF	48.66	48.8	48.61	48.76	14663569.0
2007-07-10 10:00:00	QQQ	ETF	48.76	48.88	48.72	48.78	17468429.0
2007-07-10 11:00:00	QQQ	ETF	48.79	48.9	48.79	48.84	8339560.0
2007-07-10 12:00:00	QQQ	ETF	48.84	48.8785	48.75	48.77	5869857.0
2007-07-10 13:00:00	QQQ	ETF	48.77	48.83	48.51	48.56	12666649.0
2007-07-10 14:00:00	QQQ	ETF	48.56	48.67	48.5	48.55	13556792.0
2007-07-10 15:00:00	QQQ	ETF	48.55	48.57	48.43	48.5	17922409.0
2007-07-10 16:00:00	QQQ	ETF	48.5	48.58	48.45	48.49	2442424.0
2007-07-10 17:00:00	QQQ	ETF	48.5	48.53	48.49	48.5	5072.0
2007-07-10 18:00:00	QQQ	ETF	48.5	48.52	48.47	48.48	14805.0
2007-07-10 19:00:00	QQQ	ETF	48.49	48.53	48.49	48.53	3213.0
2007-07-10 07:00:00	IWM	ETF	84.63	84.63	84.5	84.5	56600.0
2007-07-10 08:00:00	IWM	ETF	84.61	84.61	84.31	84.34	1936000.0
2007-07-10 09:00:00	IWM	ETF	84.37	84.37	83.85	84.04	18705766.0
2007-07-10 10:00:00	IWM	ETF	84.01	84.25	83.88	84.05	11367091.0
2007-07-10 11:00:00	IWM	ETF	84.05	84.21	83.95	84.14	10725183.0
2007-07-10 12:00:00	IWM	ETF	84.13	84.21	83.89	83.99	10177241.0
2007-07-10 13:00:00	IWM	ETF	84.0	84.1	83.35	83.6	12691344.0
2007-07-10 14:00:00	IWM	ETF	83.6	84.88	83.43	83.55	12221561.0
2007-07-10 15:00:00	IWM	ETF	83.54	84.14	83.25	83.26	13515027.0
2007-07-10 16:00:00	IWM	ETF	83.26	83.8564	83.21	83.29	4100400.0
2007-07-10 17:00:00	IWM	ETF	83.34	83.34	83.21	83.23	1552000.0
2007-07-10 18:00:00	IWM	ETF	83.29	83.29	83.28	83.28	200.0
2007-07-10 19:00:00	IWM	ETF	83.21	83.32	83.21	83.28	308000.0
2007-07-10 07:00:00	DIA	ETF	136.35	136.35	136.19	136.19	7200.0
2007-07-10 08:00:00	DIA	ETF	136.22	136.22	136.13	136.15	39400.0
2007-07-10 09:00:00	DIA	ETF	136.08	136.09	135.75	135.86	1217100.0
2007-07-10 10:00:00	DIA	ETF	135.86	136.04	135.66	135.97	1981300.0
2007-07-10 11:00:00	DIA	ETF	135.98	136.25	135.91	136.15	1247300.0
2007-07-10 12:00:00	DIA	ETF	136.14	136.22	135.92	136.09	585768.0
2007-07-10 13:00:00	DIA	ETF	136.1	136.23	135.28	135.48	2265147.0
2007-07-10 14:00:00	DIA	ETF	135.48	135.68	135.24	135.46	2022170.0
2007-07-10 15:00:00	DIA	ETF	135.45	135.55	134.92	134.92	2930708.0

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

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