PREVIEW / etf_1hour / 2007-02-28

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-28.parquet
  size:    69 KB
  rows:    2,183

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-02-28 04:00:00	SPY	ETF	140.92	141.0	140.8	141.0	2100.0
2007-02-28 05:00:00	SPY	ETF	141.02	141.03	140.92	140.92	118500.0
2007-02-28 06:00:00	SPY	ETF	140.83	141.18	140.62	140.64	163200.0
2007-02-28 07:00:00	SPY	ETF	140.65	140.88	140.32	140.78	1869700.0
2007-02-28 08:00:00	SPY	ETF	140.77	141.1	139.8	140.49	8281000.0
2007-02-28 09:00:00	SPY	ETF	140.49	141.08	139.8	140.68	39187900.0
2007-02-28 10:00:00	SPY	ETF	140.69	141.98	140.27	141.5	48412900.0
2007-02-28 11:00:00	SPY	ETF	141.58	141.75	140.94	140.98	22732800.0
2007-02-28 12:00:00	SPY	ETF	140.98	141.55	140.72	141.42	12732300.0
2007-02-28 13:00:00	SPY	ETF	141.42	141.57	140.83	140.96	9099400.0
2007-02-28 14:00:00	SPY	ETF	141.01	141.29	140.71	141.0	11585200.0
2007-02-28 15:00:00	SPY	ETF	141.0	141.5	140.88	140.91	16084200.0
2007-02-28 16:00:00	SPY	ETF	140.96	141.09	140.56	140.82	1959100.0
2007-02-28 17:00:00	SPY	ETF	140.82	140.89	140.8	140.88	28900.0
2007-02-28 18:00:00	SPY	ETF	140.88	141.0	140.88	140.9	13500.0
2007-02-28 19:00:00	SPY	ETF	140.86	140.86	140.78	140.81	24200.0
2007-02-28 04:00:00	QQQ	ETF	43.28	43.3	43.28	43.3	500.0
2007-02-28 05:00:00	QQQ	ETF	43.41	43.41	43.36	43.36	4100.0
2007-02-28 06:00:00	QQQ	ETF	43.35	43.42	43.3	43.33	93630.0
2007-02-28 07:00:00	QQQ	ETF	43.31	43.35	43.17	43.33	2161440.0
2007-02-28 08:00:00	QQQ	ETF	43.33	43.5	43.22	43.3	6399986.0
2007-02-28 09:00:00	QQQ	ETF	43.29	43.41	42.93	43.19	47049253.0
2007-02-28 10:00:00	QQQ	ETF	43.19	43.76	43.04	43.59	59571400.0
2007-02-28 11:00:00	QQQ	ETF	43.59	43.67	43.3	43.35	21302900.0
2007-02-28 12:00:00	QQQ	ETF	43.35	43.58	43.25	43.54	15841900.0
2007-02-28 13:00:00	QQQ	ETF	43.54	43.6	43.2	43.43	16158900.0
2007-02-28 14:00:00	QQQ	ETF	43.43	43.49	43.3	43.37	16180000.0
2007-02-28 15:00:00	QQQ	ETF	43.38	43.55	43.3	43.32	24614100.0
2007-02-28 16:00:00	QQQ	ETF	43.33	43.41	43.3	43.33	3148107.0
2007-02-28 17:00:00	QQQ	ETF	43.32	43.35	43.3	43.32	80124.0
2007-02-28 18:00:00	QQQ	ETF	43.31	43.35	43.29	43.32	2548140.0
2007-02-28 19:00:00	QQQ	ETF	43.31	43.32	43.29	43.32	32400.0
2007-02-28 07:00:00	IWM	ETF	78.49	78.85	78.25	78.8	194400.0
2007-02-28 08:00:00	IWM	ETF	78.85	78.9	78.48	78.55	1512300.0
2007-02-28 09:00:00	IWM	ETF	78.55	78.72	77.51	78.33	17445400.0
2007-02-28 10:00:00	IWM	ETF	78.3218	79.22	77.92	78.96	20578700.0
2007-02-28 11:00:00	IWM	ETF	79.0	79.2	78.6	78.83	14570900.0
2007-02-28 12:00:00	IWM	ETF	78.69	79.03	78.55	78.97	6841900.0
2007-02-28 13:00:00	IWM	ETF	78.98	79.19	78.81	78.9	4520100.0
2007-02-28 14:00:00	IWM	ETF	78.96	79.11	78.79	78.89	8235100.0
2007-02-28 15:00:00	IWM	ETF	78.89	79.2	78.58	78.63	17950100.0
2007-02-28 16:00:00	IWM	ETF	78.76	79.0	78.62	78.8	980000.0
2007-02-28 17:00:00	IWM	ETF	78.77	78.78	78.77	78.77	1300.0
2007-02-28 18:00:00	IWM	ETF	78.77	78.77	78.77	78.77	470900.0
2007-02-28 07:00:00	DIA	ETF	122.55	122.86	122.26	122.85	141100.0
2007-02-28 08:00:00	DIA	ETF	122.81	122.81	122.3	122.41	803500.0
2007-02-28 09:00:00	DIA	ETF	122.4	122.93	121.5	122.53	3375300.0
2007-02-28 10:00:00	DIA	ETF	122.51	123.47	122.09	123.07	5035100.0
2007-02-28 11:00:00	DIA	ETF	123.18	123.47	122.12	122.68	2880700.0
2007-02-28 12:00:00	DIA	ETF	122.86	123.13	122.47	123.06	1783200.0

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

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