PREVIEW / etf_1hour / 2007-02-26

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-26.parquet
  size:    67 KB
  rows:    2,068

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-26 06:00:00	SPY	ETF	145.86	145.86	145.78	145.81	17500.0
2007-02-26 07:00:00	SPY	ETF	145.75	145.86	145.74	145.84	328330.0
2007-02-26 08:00:00	SPY	ETF	145.81	145.86	145.4	145.78	1147443.0
2007-02-26 09:00:00	SPY	ETF	145.78	145.95	145.64	145.64	8670282.0
2007-02-26 10:00:00	SPY	ETF	145.65	145.8774	145.31	145.56	11821203.0
2007-02-26 11:00:00	SPY	ETF	145.56	145.75	145.41	145.49	6890277.0
2007-02-26 12:00:00	SPY	ETF	145.49	145.5	144.75	144.82	11914617.0
2007-02-26 13:00:00	SPY	ETF	144.81	144.97	144.79	144.95	8794059.0
2007-02-26 14:00:00	SPY	ETF	144.95	145.945	144.76	145.13	8713881.0
2007-02-26 15:00:00	SPY	ETF	145.13	145.925	145.0	145.21	7745435.0
2007-02-26 16:00:00	SPY	ETF	145.22	145.25	145.14	145.18	983856.0
2007-02-26 17:00:00	SPY	ETF	145.21	145.25	145.2	145.25	207861.0
2007-02-26 18:00:00	SPY	ETF	145.22	145.24	145.2	145.24	768590.0
2007-02-26 19:00:00	SPY	ETF	145.23	145.23	145.2	145.2	10000.0
2007-02-26 05:00:00	QQQ	ETF	45.44	45.44	45.44	45.44	1000.0
2007-02-26 07:00:00	QQQ	ETF	45.43	45.49	45.41	45.47	532525.0
2007-02-26 08:00:00	QQQ	ETF	45.48	45.53	45.46	45.51	1185518.0
2007-02-26 09:00:00	QQQ	ETF	45.5	45.51	45.16	45.16	17831725.0
2007-02-26 10:00:00	QQQ	ETF	45.16	45.25	44.98	45.1	16998400.0
2007-02-26 11:00:00	QQQ	ETF	45.1	45.17	45.05	45.16	8032600.0
2007-02-26 12:00:00	QQQ	ETF	45.15	45.16	44.77	44.78	18294500.0
2007-02-26 13:00:00	QQQ	ETF	44.78	44.92	44.76	44.89	12049000.0
2007-02-26 14:00:00	QQQ	ETF	44.9	44.99	44.87	44.94	7647200.0
2007-02-26 15:00:00	QQQ	ETF	44.95	45.07	44.9	45.07	10195800.0
2007-02-26 16:00:00	QQQ	ETF	45.07	45.42	45.04	45.1	1844392.0
2007-02-26 17:00:00	QQQ	ETF	45.09	45.1	45.07	45.09	33616.0
2007-02-26 18:00:00	QQQ	ETF	45.08	45.36	45.07	45.08	606300.0
2007-02-26 19:00:00	QQQ	ETF	45.09	45.1	45.08	45.08	5450.0
2007-02-26 08:00:00	IWM	ETF	82.29	82.3	82.25	82.28	154110.0
2007-02-26 09:00:00	IWM	ETF	82.26	82.41	81.9	81.91	7188217.0
2007-02-26 10:00:00	IWM	ETF	81.91	82.15	81.69	81.86	8504566.0
2007-02-26 11:00:00	IWM	ETF	81.86	82.0385	81.75	81.79	4182682.0
2007-02-26 12:00:00	IWM	ETF	81.79	81.79	81.19	81.24	7010856.0
2007-02-26 13:00:00	IWM	ETF	81.23	82.38	81.21	81.55	25820386.0
2007-02-26 14:00:00	IWM	ETF	81.55	81.85	81.5	81.72	14991372.0
2007-02-26 15:00:00	IWM	ETF	81.73	81.975	81.57	81.77	8707812.0
2007-02-26 16:00:00	IWM	ETF	81.78	81.8	81.73	81.76	510502.0
2007-02-26 17:00:00	IWM	ETF	81.8	81.81	81.76	81.76	2300.0
2007-02-26 19:00:00	IWM	ETF	81.8	81.8	81.8	81.8	600.0
2007-02-26 07:00:00	DIA	ETF	126.79	126.89	126.79	126.89	33500.0
2007-02-26 08:00:00	DIA	ETF	126.84	126.93	126.84	126.89	532414.0
2007-02-26 09:00:00	DIA	ETF	126.88	127.0	126.49	126.49	1351068.0
2007-02-26 10:00:00	DIA	ETF	126.49	126.7022	126.39	126.57	1579005.0
2007-02-26 11:00:00	DIA	ETF	126.57	126.63	126.45	126.51	587778.0
2007-02-26 12:00:00	DIA	ETF	126.5	126.52	126.09	126.13	995364.0
2007-02-26 13:00:00	DIA	ETF	126.12	126.26	126.1	126.22	1099202.0
2007-02-26 14:00:00	DIA	ETF	126.23	126.36	126.17	126.29	460755.0
2007-02-26 15:00:00	DIA	ETF	126.31	126.38	126.19	126.37	931681.0
2007-02-26 16:00:00	DIA	ETF	126.3605	126.39	126.31	126.34	14000.0
2007-02-26 17:00:00	DIA	ETF	126.37	126.37	126.37	126.37	100.0

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

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