PREVIEW / etf_1hour / 2007-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-06.parquet
  size:    79 KB
  rows:    2,649

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-06 06:00:00	SPY	ETF	152.46	152.49	152.46	152.49	19500.0
2007-07-06 07:00:00	SPY	ETF	152.4	152.49	152.33	152.34	115000.0
2007-07-06 08:00:00	SPY	ETF	152.39	152.67	152.03	152.18	4583800.0
2007-07-06 09:00:00	SPY	ETF	152.24	152.44	151.93	152.08	12596704.0
2007-07-06 10:00:00	SPY	ETF	152.08	152.62	152.07	152.39	14656687.0
2007-07-06 11:00:00	SPY	ETF	152.4	152.89	152.35	152.69	9215600.0
2007-07-06 12:00:00	SPY	ETF	152.69	152.77	152.37	152.61	7308469.0
2007-07-06 13:00:00	SPY	ETF	152.62	152.77	152.51	152.7	4544419.0
2007-07-06 14:00:00	SPY	ETF	152.7	153.01	152.63	152.94	8920978.0
2007-07-06 15:00:00	SPY	ETF	152.93	153.17	152.78	152.95	11983099.0
2007-07-06 16:00:00	SPY	ETF	152.96	153.1	152.84	152.97	4318800.0
2007-07-06 17:00:00	SPY	ETF	152.97	152.97	152.9	152.96	320300.0
2007-07-06 18:00:00	SPY	ETF	152.96	152.96	152.96	152.96	500.0
2007-07-06 19:00:00	SPY	ETF	152.97	152.99	152.92	152.95	2000.0
2007-07-06 05:00:00	QQQ	ETF	48.66	48.66	48.66	48.66	500.0
2007-07-06 06:00:00	QQQ	ETF	48.66	48.66	48.66	48.66	1600.0
2007-07-06 07:00:00	QQQ	ETF	48.65	48.71	48.64	48.64	103726.0
2007-07-06 08:00:00	QQQ	ETF	48.65	48.76	48.6	48.69	2705566.0
2007-07-06 09:00:00	QQQ	ETF	48.69	48.76	48.5	48.56	11484831.0
2007-07-06 10:00:00	QQQ	ETF	48.56	48.74	48.54	48.68	12879104.0
2007-07-06 11:00:00	QQQ	ETF	48.68	48.84	48.66	48.78	7991059.0
2007-07-06 12:00:00	QQQ	ETF	48.78	48.8	48.65	48.74	8405782.0
2007-07-06 13:00:00	QQQ	ETF	48.73	48.81	48.7	48.79	4188405.0
2007-07-06 14:00:00	QQQ	ETF	48.7995	48.87	48.76	48.87	6970748.0
2007-07-06 15:00:00	QQQ	ETF	48.87	48.91	48.84	48.87	8337597.0
2007-07-06 16:00:00	QQQ	ETF	48.87	48.94	48.85	48.93	1503808.0
2007-07-06 17:00:00	QQQ	ETF	48.93	48.94	48.91	48.93	26200.0
2007-07-06 18:00:00	QQQ	ETF	48.92	48.94	48.92	48.94	5500.0
2007-07-06 19:00:00	QQQ	ETF	48.92	48.92	48.91	48.91	5050.0
2007-07-06 07:00:00	IWM	ETF	84.54	84.54	84.54	84.54	3400.0
2007-07-06 08:00:00	IWM	ETF	84.57	84.73	84.42	84.52	574300.0
2007-07-06 09:00:00	IWM	ETF	84.52	84.6	84.06	84.16	6056542.0
2007-07-06 10:00:00	IWM	ETF	84.16	84.55	84.14	84.44	5317503.0
2007-07-06 11:00:00	IWM	ETF	84.44	84.88	84.38	84.76	5209122.0
2007-07-06 12:00:00	IWM	ETF	84.77	84.8	84.56	84.72	3357749.0
2007-07-06 13:00:00	IWM	ETF	84.73	84.78	84.6	84.74	2576721.0
2007-07-06 14:00:00	IWM	ETF	84.73	84.91	84.68	84.87	3617935.0
2007-07-06 15:00:00	IWM	ETF	84.87	84.93	84.67	84.77	4535575.0
2007-07-06 16:00:00	IWM	ETF	84.77	84.95	84.7	84.78	7113400.0
2007-07-06 17:00:00	IWM	ETF	84.8	84.8	84.72	84.72	751000.0
2007-07-06 18:00:00	IWM	ETF	84.71	84.8	84.7	84.8	20600.0
2007-07-06 08:00:00	DIA	ETF	135.73	135.83	135.4	135.61	38600.0
2007-07-06 09:00:00	DIA	ETF	135.6	135.67	135.36	135.46	1153900.0
2007-07-06 10:00:00	DIA	ETF	135.47	135.96	135.46	135.8	1749134.0
2007-07-06 11:00:00	DIA	ETF	135.8	136.24	135.77	135.98	1065618.0
2007-07-06 12:00:00	DIA	ETF	135.97	136.06	135.7	135.97	1125400.0
2007-07-06 13:00:00	DIA	ETF	135.98	136.03	135.84	135.98	469300.0
2007-07-06 14:00:00	DIA	ETF	135.97	136.2	135.9	136.15	643400.0
2007-07-06 15:00:00	DIA	ETF	136.18	136.31	135.98	136.11	673308.0
2007-07-06 16:00:00	DIA	ETF	136.1	136.19	136.1	136.17	31100.0

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

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