PREVIEW / etf_1hour / 2008-02-04

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-04.parquet
  size:    98 KB
  rows:    3,311

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
2008-02-04 04:00:00	SPY	ETF	139.41	139.41	139.34	139.34	9600.0
2008-02-04 05:00:00	SPY	ETF	139.17	139.37	139.17	139.37	10100.0
2008-02-04 06:00:00	SPY	ETF	139.34	139.86	139.34	139.78	17500.0
2008-02-04 07:00:00	SPY	ETF	139.73	139.81	139.33	139.4	160600.0
2008-02-04 08:00:00	SPY	ETF	139.39	139.5	139.1	139.35	1267600.0
2008-02-04 09:00:00	SPY	ETF	139.35	139.58	138.43	138.65	19018624.0
2008-02-04 10:00:00	SPY	ETF	138.65	138.8	138.1	138.6	21907528.0
2008-02-04 11:00:00	SPY	ETF	138.6	138.94	138.46	138.63	14555769.0
2008-02-04 12:00:00	SPY	ETF	138.63	138.67	138.21	138.51	9167034.0
2008-02-04 13:00:00	SPY	ETF	138.51	138.8	138.05	138.5301	12394813.0
2008-02-04 14:00:00	SPY	ETF	138.53	138.55	137.91	138.22	14588245.0
2008-02-04 15:00:00	SPY	ETF	138.22	138.53	137.88	138.0	19247141.0
2008-02-04 16:00:00	SPY	ETF	138.032	138.2012	137.6	137.6	4326800.0
2008-02-04 17:00:00	SPY	ETF	137.82	137.82	137.57	137.68	1866900.0
2008-02-04 18:00:00	SPY	ETF	137.64	137.84	137.64	137.77	57100.0
2008-02-04 19:00:00	SPY	ETF	137.7	137.7	137.58	137.61	39500.0
2008-02-04 06:00:00	QQQ	ETF	45.78	45.82	45.78	45.82	300.0
2008-02-04 07:00:00	QQQ	ETF	45.8	45.8	45.63	45.65	92850.0
2008-02-04 08:00:00	QQQ	ETF	45.66	45.69	45.58	45.64	589467.0
2008-02-04 09:00:00	QQQ	ETF	45.65	45.67	45.38	45.5	15249296.0
2008-02-04 10:00:00	QQQ	ETF	45.5	45.53	45.1899	45.35	15663492.0
2008-02-04 11:00:00	QQQ	ETF	45.35	45.46	45.24	45.26	12778467.0
2008-02-04 12:00:00	QQQ	ETF	45.26	45.27	45.07	45.1699	9287005.0
2008-02-04 13:00:00	QQQ	ETF	45.17	45.19	45.0	45.17	10805055.0
2008-02-04 14:00:00	QQQ	ETF	45.16	45.17	44.94	45.081	13092762.0
2008-02-04 15:00:00	QQQ	ETF	45.08	45.16	44.95	44.97	14204411.0
2008-02-04 16:00:00	QQQ	ETF	44.95	45.0	44.7	44.74	8057242.0
2008-02-04 17:00:00	QQQ	ETF	44.74	44.76	44.72	44.74	278020.0
2008-02-04 18:00:00	QQQ	ETF	44.73	44.8	44.73	44.78	76455.0
2008-02-04 19:00:00	QQQ	ETF	44.76	44.78	44.73	44.75	35112.0
2008-02-04 05:00:00	IWM	ETF	72.61	72.61	72.61	72.61	400.0
2008-02-04 07:00:00	IWM	ETF	72.7	72.71	72.67	72.67	152100.0
2008-02-04 08:00:00	IWM	ETF	72.67	72.67	72.42	72.5	337000.0
2008-02-04 09:00:00	IWM	ETF	72.5	72.63	71.85	71.95	8093876.0
2008-02-04 10:00:00	IWM	ETF	71.94	72.32	71.68	72.17	9433106.0
2008-02-04 11:00:00	IWM	ETF	72.17	72.6	72.07	72.29	7911321.0
2008-02-04 12:00:00	IWM	ETF	72.29	72.38	72.11	72.25	3418631.0
2008-02-04 13:00:00	IWM	ETF	72.25	72.35	71.99	72.34	5356252.0
2008-02-04 14:00:00	IWM	ETF	72.34	72.35	71.93	72.07	5623833.0
2008-02-04 15:00:00	IWM	ETF	72.07	72.19	71.96	71.97	7412000.0
2008-02-04 16:00:00	IWM	ETF	71.97	72.14	71.58	71.97	6805400.0
2008-02-04 17:00:00	IWM	ETF	71.63	71.72	71.61	71.67	43100.0
2008-02-04 18:00:00	IWM	ETF	71.7	71.74	71.66	71.7	4600.0
2008-02-04 19:00:00	IWM	ETF	71.69	71.69	71.69	71.69	100.0
2008-02-04 07:00:00	DIA	ETF	127.52	127.52	127.48	127.48	1600.0
2008-02-04 08:00:00	DIA	ETF	127.38	127.4	127.2	127.36	41400.0
2008-02-04 09:00:00	DIA	ETF	127.32	127.32	126.62	126.71	1385021.0
2008-02-04 10:00:00	DIA	ETF	126.73	126.83	126.25	126.71	1682056.0
2008-02-04 11:00:00	DIA	ETF	126.72	126.98	126.6	126.71	1342350.0
2008-02-04 12:00:00	DIA	ETF	126.7	126.74	126.41	126.67	730936.0

> showing 50 of 3,311 rows — these rows as CSV

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