PREVIEW / etf_1hour / 2007-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-10.parquet
  size:    90 KB
  rows:    2,950

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-08-10 04:00:00	SPY	ETF	144.85	145.4	144.85	145.4	8300.0
2007-08-10 05:00:00	SPY	ETF	145.15	145.15	144.71	144.71	2200.0
2007-08-10 06:00:00	SPY	ETF	144.51	144.61	144.0	144.08	220600.0
2007-08-10 07:00:00	SPY	ETF	144.11	144.13	142.93	143.0	4624400.0
2007-08-10 08:00:00	SPY	ETF	143.0	145.0	142.96	143.91	14319900.0
2007-08-10 09:00:00	SPY	ETF	143.93	150.2046	143.3	144.26	50142853.0
2007-08-10 10:00:00	SPY	ETF	144.26	144.5	143.12	143.7	62927390.0
2007-08-10 11:00:00	SPY	ETF	143.71	144.98	143.26	144.98	59747758.0
2007-08-10 12:00:00	SPY	ETF	144.98	146.5	144.68	144.73	70481586.0
2007-08-10 13:00:00	SPY	ETF	144.73	145.77	144.1	144.66	44633555.0
2007-08-10 14:00:00	SPY	ETF	144.65	145.33	144.14	144.41	26861187.0
2007-08-10 15:00:00	SPY	ETF	144.43	146.23	143.83	145.54	58001695.0
2007-08-10 16:00:00	SPY	ETF	145.54	145.6	143.92	144.8	10079400.0
2007-08-10 17:00:00	SPY	ETF	144.83	145.0	144.76	144.85	148800.0
2007-08-10 18:00:00	SPY	ETF	144.85	145.25	144.8	145.2	182400.0
2007-08-10 19:00:00	SPY	ETF	145.2	145.2	144.96	145.0	3400.0
2007-08-10 20:00:00	SPY	ETF	145.08	145.08	145.08	145.08	100.0
2007-08-10 04:00:00	QQQ	ETF	47.54	47.59	47.54	47.59	7500.0
2007-08-10 06:00:00	QQQ	ETF	47.27	47.32	47.19	47.19	90300.0
2007-08-10 07:00:00	QQQ	ETF	47.2	47.2	46.89	46.92	1129299.0
2007-08-10 08:00:00	QQQ	ETF	46.92	47.21	46.89	47.14	4381421.0
2007-08-10 09:00:00	QQQ	ETF	47.14	47.31	46.99	47.25	30398280.0
2007-08-10 10:00:00	QQQ	ETF	47.24	47.29	46.63	46.87	42681942.0
2007-08-10 11:00:00	QQQ	ETF	46.87	47.44	46.85	47.44	39512908.0
2007-08-10 12:00:00	QQQ	ETF	47.4301	47.83	47.15	47.17	42935205.0
2007-08-10 13:00:00	QQQ	ETF	47.17	47.59	47.05	47.21	22595158.0
2007-08-10 14:00:00	QQQ	ETF	47.21	47.39	47.0	47.04	19362694.0
2007-08-10 15:00:00	QQQ	ETF	47.04	47.59	47.02	47.38	28836433.0
2007-08-10 16:00:00	QQQ	ETF	47.37	47.3901	47.08	47.32	2809332.0
2007-08-10 17:00:00	QQQ	ETF	47.3	47.33	47.28	47.33	51980.0
2007-08-10 18:00:00	QQQ	ETF	47.33	47.33	47.27	47.33	21300.0
2007-08-10 19:00:00	QQQ	ETF	47.33	47.42	47.33	47.41	13866.0
2007-08-10 06:00:00	IWM	ETF	77.01	77.01	76.9	76.9	600.0
2007-08-10 07:00:00	IWM	ETF	76.76	76.85	76.08	76.1	1503000.0
2007-08-10 08:00:00	IWM	ETF	76.1	76.85	76.1	76.51	3845800.0
2007-08-10 09:00:00	IWM	ETF	76.53	77.34	76.51	77.31	19108950.0
2007-08-10 10:00:00	IWM	ETF	77.31	77.45	76.43	77.14	31501876.0
2007-08-10 11:00:00	IWM	ETF	77.14	78.96	77.14	78.95	56151961.0
2007-08-10 12:00:00	IWM	ETF	78.96	79.77	78.25	78.27	51434766.0
2007-08-10 13:00:00	IWM	ETF	78.27	78.93	77.78	78.17	19914278.0
2007-08-10 14:00:00	IWM	ETF	78.17	78.51	77.86	77.99	17126574.0
2007-08-10 15:00:00	IWM	ETF	78.0	78.86	77.89	78.48	34150808.0
2007-08-10 16:00:00	IWM	ETF	78.48	79.77	77.88	79.25	3558611.0
2007-08-10 17:00:00	IWM	ETF	78.21	78.25	78.1	78.25	17800.0
2007-08-10 18:00:00	IWM	ETF	78.35	78.35	78.35	78.35	12000.0
2007-08-10 19:00:00	IWM	ETF	78.15	78.15	78.15	78.15	100.0
2007-08-10 07:00:00	DIA	ETF	131.76	131.79	130.96	130.96	155400.0
2007-08-10 08:00:00	DIA	ETF	131.05	132.01	130.98	131.64	364100.0
2007-08-10 09:00:00	DIA	ETF	131.68	132.19	130.84	131.79	3034084.0
2007-08-10 10:00:00	DIA	ETF	131.77	131.95	130.64	131.03	5161300.0

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

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