PREVIEW / etf_1hour / 2008-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-07.parquet
  size:    116 KB
  rows:    3,809

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-10-07 04:00:00	SPY	ETF	105.07	105.07	105.07	105.07	200.0
2008-10-07 05:00:00	SPY	ETF	104.86	104.92	104.75	104.75	14100.0
2008-10-07 06:00:00	SPY	ETF	105.07	106.15	105.07	106.15	114900.0
2008-10-07 07:00:00	SPY	ETF	106.13	106.2	105.58	106.08	993200.0
2008-10-07 08:00:00	SPY	ETF	106.07	106.832	104.03	104.46	9613002.0
2008-10-07 09:00:00	SPY	ETF	104.46	107.33	104.46	105.69	79424060.0
2008-10-07 10:00:00	SPY	ETF	105.69	106.41	104.69	105.64	64773164.0
2008-10-07 11:00:00	SPY	ETF	105.65	105.79	104.43	105.16	46634488.0
2008-10-07 12:00:00	SPY	ETF	105.17	105.25	103.07	103.49	46060133.0
2008-10-07 13:00:00	SPY	ETF	103.48	104.44	101.43	101.55	83027241.0
2008-10-07 14:00:00	SPY	ETF	101.54	103.85	101.25	102.17	86548817.0
2008-10-07 15:00:00	SPY	ETF	102.17	102.4	99.65	99.79	96239167.0
2008-10-07 16:00:00	SPY	ETF	99.81	105.6276	99.57	100.1	21438611.0
2008-10-07 17:00:00	SPY	ETF	100.05	100.19	99.57	100.07	2432913.0
2008-10-07 18:00:00	SPY	ETF	100.07	100.43	100.05	100.2	152990.0
2008-10-07 19:00:00	SPY	ETF	100.25	100.25	99.56	99.7	100845.0
2008-10-07 20:00:00	SPY	ETF	99.71	99.71	99.71	99.71	100.0
2008-10-07 04:00:00	QQQ	ETF	34.27	34.48	34.27	34.48	3090.0
2008-10-07 05:00:00	QQQ	ETF	34.42	34.55	34.4	34.4	12200.0
2008-10-07 06:00:00	QQQ	ETF	34.4	34.82	34.4	34.82	9192.0
2008-10-07 07:00:00	QQQ	ETF	34.78	34.95	34.66	34.84	1259659.0
2008-10-07 08:00:00	QQQ	ETF	34.84	34.89	34.04	34.26	4256654.0
2008-10-07 09:00:00	QQQ	ETF	34.27	35.23	34.27	34.49	50749391.0
2008-10-07 10:00:00	QQQ	ETF	34.5	35.1	34.16	34.6	45285568.0
2008-10-07 11:00:00	QQQ	ETF	34.6	34.7	34.23	34.52	21463805.0
2008-10-07 12:00:00	QQQ	ETF	34.52	34.5201	33.73	33.94	26294105.0
2008-10-07 13:00:00	QQQ	ETF	33.94	34.33	32.27	33.19	44474894.0
2008-10-07 14:00:00	QQQ	ETF	33.18	34.32	33.1	33.41	48256748.0
2008-10-07 15:00:00	QQQ	ETF	33.42	33.5	32.72	32.81	64123846.0
2008-10-07 16:00:00	QQQ	ETF	32.8	33.1816	32.65	32.73	12522484.0
2008-10-07 17:00:00	QQQ	ETF	32.75	32.83	32.69	32.72	426119.0
2008-10-07 18:00:00	QQQ	ETF	32.72	32.8	32.65	32.75	107891.0
2008-10-07 19:00:00	QQQ	ETF	32.76	32.77	32.51	32.58	110029.0
2008-10-07 07:00:00	IWM	ETF	59.9	60.18	59.7	60.18	9800.0
2008-10-07 08:00:00	IWM	ETF	60.25	60.25	58.69	58.91	1702345.0
2008-10-07 09:00:00	IWM	ETF	58.91	60.43	58.73	59.27	18887344.0
2008-10-07 10:00:00	IWM	ETF	59.27	60.0	58.73	59.5	18057793.0
2008-10-07 11:00:00	IWM	ETF	59.5	59.65	58.6	59.14	13577877.0
2008-10-07 12:00:00	IWM	ETF	59.15	59.16	57.99	58.27	10307708.0
2008-10-07 13:00:00	IWM	ETF	58.28	58.72	56.95	56.97	18164368.0
2008-10-07 14:00:00	IWM	ETF	56.97	58.25	56.72	57.19	20303193.0
2008-10-07 15:00:00	IWM	ETF	57.17	57.46	55.63	55.87	30875601.0
2008-10-07 16:00:00	IWM	ETF	55.81	59.5	55.36	59.5	16157093.0
2008-10-07 17:00:00	IWM	ETF	55.67	55.9	55.67	55.9	23995.0
2008-10-07 18:00:00	IWM	ETF	55.83	55.83	55.65	55.65	4600.0
2008-10-07 19:00:00	IWM	ETF	55.61	55.61	55.3	55.35	4050.0
2008-10-07 07:00:00	DIA	ETF	99.92	100.0	99.48	99.93	9350.0
2008-10-07 08:00:00	DIA	ETF	100.02	100.5	98.55	98.75	129142.0
2008-10-07 09:00:00	DIA	ETF	98.93	101.21	98.93	99.76	3818090.0
2008-10-07 10:00:00	DIA	ETF	99.77	100.3	98.85	99.67	3878961.0

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

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