PREVIEW / etf_1hour / 2009-10-08

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-08.parquet
  size:    146 KB
  rows:    4,543

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
2009-10-08 04:00:00	SPY	ETF	106.96	106.96	106.79	106.79	1000.0
2009-10-08 05:00:00	SPY	ETF	106.7	106.73	106.69	106.73	4054.0
2009-10-08 06:00:00	SPY	ETF	106.78	106.84	106.74	106.79	36350.0
2009-10-08 07:00:00	SPY	ETF	106.71	106.8	106.66	106.67	261387.0
2009-10-08 08:00:00	SPY	ETF	106.71	107.02	106.59	106.8	4587199.0
2009-10-08 09:00:00	SPY	ETF	106.81	106.81	106.315	106.47	29157913.0
2009-10-08 10:00:00	SPY	ETF	106.47	106.75	106.15	106.67	28499698.0
2009-10-08 11:00:00	SPY	ETF	106.67	107.12	106.55	107.02	22237484.0
2009-10-08 12:00:00	SPY	ETF	107.02	107.17	106.65	107.06	13013330.0
2009-10-08 13:00:00	SPY	ETF	107.06	107.07	106.56	106.84	20099425.0
2009-10-08 14:00:00	SPY	ETF	106.85	106.87	106.5	106.72	15066079.0
2009-10-08 15:00:00	SPY	ETF	106.72	106.98	106.51	106.61	37126972.0
2009-10-08 16:00:00	SPY	ETF	106.6	107.03	106.29	106.89	8835217.0
2009-10-08 17:00:00	SPY	ETF	106.89	106.93	106.74	106.78	3879808.0
2009-10-08 18:00:00	SPY	ETF	106.79	106.92	106.79	106.87	83511.0
2009-10-08 19:00:00	SPY	ETF	106.87	106.92	106.77	106.92	40507.0
2009-10-08 04:00:00	QQQ	ETF	42.4	42.41	42.4	42.41	600.0
2009-10-08 06:00:00	QQQ	ETF	42.41	42.43	42.41	42.43	300.0
2009-10-08 07:00:00	QQQ	ETF	42.38	42.39	42.35	42.35	260700.0
2009-10-08 08:00:00	QQQ	ETF	42.39	42.45	42.32	42.4	2023849.0
2009-10-08 09:00:00	QQQ	ETF	42.4	42.46	42.24	42.32	15088105.0
2009-10-08 10:00:00	QQQ	ETF	42.32	42.41	42.14	42.375	17727301.0
2009-10-08 11:00:00	QQQ	ETF	42.37	42.5974	42.32	42.5379	15445838.0
2009-10-08 12:00:00	QQQ	ETF	42.5301	42.62	42.35	42.54	6943901.0
2009-10-08 13:00:00	QQQ	ETF	42.54	42.54	42.29	42.42	13401461.0
2009-10-08 14:00:00	QQQ	ETF	42.41	42.44	42.25	42.38	5774871.0
2009-10-08 15:00:00	QQQ	ETF	42.37	42.48	42.22	42.23	17943055.0
2009-10-08 16:00:00	QQQ	ETF	42.23	42.29	42.0763	42.19	10298886.0
2009-10-08 17:00:00	QQQ	ETF	42.19	42.2	42.15	42.16	533588.0
2009-10-08 18:00:00	QQQ	ETF	42.17	42.26	42.17	42.19	173098.0
2009-10-08 19:00:00	QQQ	ETF	42.2	42.22	42.16	42.22	20319.0
2009-10-08 07:00:00	IWM	ETF	60.85	60.85	60.78	60.78	6234.0
2009-10-08 08:00:00	IWM	ETF	60.92	61.05	60.75	60.9	839234.0
2009-10-08 09:00:00	IWM	ETF	60.9	60.9	60.5	60.58	6154423.0
2009-10-08 10:00:00	IWM	ETF	60.57	60.9	60.37	60.82	7544068.0
2009-10-08 11:00:00	IWM	ETF	60.81	61.23	60.74	61.171	5090396.0
2009-10-08 12:00:00	IWM	ETF	61.18	61.31	61.095	61.23	3076064.0
2009-10-08 13:00:00	IWM	ETF	61.22	61.23	60.82	60.96	4980584.0
2009-10-08 14:00:00	IWM	ETF	60.96	61.1	60.78	61.06	4755735.0
2009-10-08 15:00:00	IWM	ETF	61.06	61.23	60.7	60.72	10844033.0
2009-10-08 16:00:00	IWM	ETF	60.72	60.95	60.2266	60.93	3448618.0
2009-10-08 17:00:00	IWM	ETF	60.91	60.93	60.89	60.9	5576.0
2009-10-08 18:00:00	IWM	ETF	60.82	60.82	60.79	60.79	900.0
2009-10-08 19:00:00	IWM	ETF	60.85	60.85	60.85	60.85	300.0
2009-10-08 04:00:00	DIA	ETF	98.2	98.2	98.2	98.2	100.0
2009-10-08 07:00:00	DIA	ETF	98.08	98.11	98.05	98.05	1900.0
2009-10-08 08:00:00	DIA	ETF	98.04	98.23	97.97	98.11	44794.0
2009-10-08 09:00:00	DIA	ETF	98.08	98.14	97.75	97.8	1995180.0
2009-10-08 10:00:00	DIA	ETF	97.8	98.04	97.54	97.98	1452341.0
2009-10-08 11:00:00	DIA	ETF	97.96	98.38	97.84	98.28	1699301.0

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

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