PREVIEW / etf_1hour / 2008-11-21

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-21.parquet
  size:    122 KB
  rows:    4,056

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-11-21 04:00:00	SPY	ETF	78.52	78.67	78.32	78.41	26883.0
2008-11-21 05:00:00	SPY	ETF	78.75	78.93	77.75	77.8	72910.0
2008-11-21 06:00:00	SPY	ETF	78.06	78.06	77.31	77.58	407070.0
2008-11-21 07:00:00	SPY	ETF	77.52	77.7	77.04	77.06	2657189.0
2008-11-21 08:00:00	SPY	ETF	77.44	78.5	76.4	77.42	6347559.0
2008-11-21 09:00:00	SPY	ETF	77.42	77.75	76.06	76.46	79478566.0
2008-11-21 10:00:00	SPY	ETF	76.45	76.93	75.0	75.16	104702726.0
2008-11-21 11:00:00	SPY	ETF	75.16	77.09	74.34	75.72	74074446.0
2008-11-21 12:00:00	SPY	ETF	75.72	77.25	75.37	76.51	57563365.0
2008-11-21 13:00:00	SPY	ETF	76.51	77.1	74.92	74.95	46743115.0
2008-11-21 14:00:00	SPY	ETF	74.95	76.5	74.58	75.21	88266776.0
2008-11-21 15:00:00	SPY	ETF	75.21	80.9	75.06	80.36	213860666.0
2008-11-21 16:00:00	SPY	ETF	80.29	80.6	75.45	79.73	36772971.0
2008-11-21 17:00:00	SPY	ETF	75.6037	80.4	74.79	79.75	4677861.0
2008-11-21 18:00:00	SPY	ETF	79.75	80.3	78.0	79.83	333999.0
2008-11-21 19:00:00	SPY	ETF	79.87	79.9	79.4	79.45	124004.0
2008-11-21 04:00:00	QQQ	ETF	26.75	26.75	26.54	26.57	23082.0
2008-11-21 05:00:00	QQQ	ETF	26.55	26.68	26.48	26.48	6700.0
2008-11-21 06:00:00	QQQ	ETF	26.5	26.54	26.41	26.41	6310.0
2008-11-21 07:00:00	QQQ	ETF	26.43	26.43	25.97	25.97	737348.0
2008-11-21 08:00:00	QQQ	ETF	25.98	26.65	25.9	26.07	4859090.0
2008-11-21 09:00:00	QQQ	ETF	26.09	26.24	25.79	25.99	34802003.0
2008-11-21 10:00:00	QQQ	ETF	25.98	26.1	25.35	25.4	43390817.0
2008-11-21 11:00:00	QQQ	ETF	25.41	25.96	25.21	25.69	24831106.0
2008-11-21 12:00:00	QQQ	ETF	25.69	26.06	25.58	25.77	22063693.0
2008-11-21 13:00:00	QQQ	ETF	25.77	25.8	25.21	25.21	19188568.0
2008-11-21 14:00:00	QQQ	ETF	25.22	25.63	25.05	25.24	37581515.0
2008-11-21 15:00:00	QQQ	ETF	25.23	26.68	25.23	26.68	85995359.0
2008-11-21 16:00:00	QQQ	ETF	26.68	26.88	25.54	26.65	7351842.0
2008-11-21 17:00:00	QQQ	ETF	26.61	26.67	25.22	25.83	71813.0
2008-11-21 18:00:00	QQQ	ETF	26.65	26.72	26.3	26.72	32527.0
2008-11-21 19:00:00	QQQ	ETF	26.65	26.72	26.6	26.64	3064.0
2008-11-21 04:00:00	IWM	ETF	40.37	40.37	40.37	40.37	275.0
2008-11-21 06:00:00	IWM	ETF	40.43	40.45	40.43	40.45	800.0
2008-11-21 07:00:00	IWM	ETF	40.06	40.18	39.71	39.72	137233.0
2008-11-21 08:00:00	IWM	ETF	40.55	40.76	38.53	39.69	632990.0
2008-11-21 09:00:00	IWM	ETF	39.67	39.71	37.99	38.18	15202376.0
2008-11-21 10:00:00	IWM	ETF	38.17	38.5	37.3	37.4	25221212.0
2008-11-21 11:00:00	IWM	ETF	37.42	38.43	37.12	38.04	11681591.0
2008-11-21 12:00:00	IWM	ETF	38.04	38.62	37.75	38.32	10957041.0
2008-11-21 13:00:00	IWM	ETF	38.35	38.43	37.47	37.5	9102727.0
2008-11-21 14:00:00	IWM	ETF	37.49	38.3	37.45	37.87	15635028.0
2008-11-21 15:00:00	IWM	ETF	37.87	40.85	37.83	40.72	47206633.0
2008-11-21 16:00:00	IWM	ETF	40.7	40.74	38.58	40.41	14328739.0
2008-11-21 17:00:00	IWM	ETF	40.48	40.5	37.74	38.94	7900.0
2008-11-21 18:00:00	IWM	ETF	39.91	40.58	39.78	40.4	5175.0
2008-11-21 19:00:00	IWM	ETF	40.45	40.45	40.45	40.45	1000.0
2008-11-21 05:00:00	DIA	ETF	78.02	78.02	78.02	78.02	100.0
2008-11-21 06:00:00	DIA	ETF	77.32	77.32	77.04	77.04	2959.0
2008-11-21 07:00:00	DIA	ETF	77.16	77.41	76.98	77.02	17408.0

> showing 50 of 4,056 rows — these rows as CSV

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