PREVIEW / etf_1hour / 2008-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-04.parquet
  size:    106 KB
  rows:    3,444

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-08-04 04:00:00	SPY	ETF	126.25	126.25	126.25	126.25	100.0
2008-08-04 05:00:00	SPY	ETF	126.2	126.2	125.87	125.87	300.0
2008-08-04 06:00:00	SPY	ETF	125.85	125.87	125.75	125.75	11300.0
2008-08-04 07:00:00	SPY	ETF	125.89	126.03	125.79	125.93	428194.0
2008-08-04 08:00:00	SPY	ETF	125.98	126.15	125.72	125.84	3463802.0
2008-08-04 09:00:00	SPY	ETF	125.84	126.12	125.25	125.48	18663735.0
2008-08-04 10:00:00	SPY	ETF	125.49	125.57	124.89	125.0675	28799503.0
2008-08-04 11:00:00	SPY	ETF	125.06	126.0	124.85	125.6	38429686.0
2008-08-04 12:00:00	SPY	ETF	125.6	125.82	125.28	125.31	17521704.0
2008-08-04 13:00:00	SPY	ETF	125.32	125.51	125.19	125.42	14474129.0
2008-08-04 14:00:00	SPY	ETF	125.41	126.14	125.33	125.94	23934367.0
2008-08-04 15:00:00	SPY	ETF	125.935	126.01	124.76	124.91	37206680.0
2008-08-04 16:00:00	SPY	ETF	124.99	125.9541	124.92	125.1	3129861.0
2008-08-04 17:00:00	SPY	ETF	125.09	125.13	125.01	125.06	167386.0
2008-08-04 18:00:00	SPY	ETF	125.08	125.14	125.03	125.05	21308.0
2008-08-04 19:00:00	SPY	ETF	125.04	125.13	125.04	125.13	12178.0
2008-08-04 04:00:00	QQQ	ETF	44.96	45.0	44.96	45.0	200.0
2008-08-04 07:00:00	QQQ	ETF	44.83	44.87	44.63	44.8	1058654.0
2008-08-04 08:00:00	QQQ	ETF	44.8	44.85	44.75	44.85	3556113.0
2008-08-04 09:00:00	QQQ	ETF	44.84	44.92	44.5	44.68	15533794.0
2008-08-04 10:00:00	QQQ	ETF	44.67	44.71	44.38	44.49	17721552.0
2008-08-04 11:00:00	QQQ	ETF	44.48	44.84	44.41	44.77	18707653.0
2008-08-04 12:00:00	QQQ	ETF	44.77	44.82	44.5901	44.6	6232343.0
2008-08-04 13:00:00	QQQ	ETF	44.6	44.69	44.51	44.62	6266536.0
2008-08-04 14:00:00	QQQ	ETF	44.61	44.825	44.57	44.7	11161175.0
2008-08-04 15:00:00	QQQ	ETF	44.69	44.73	44.3	44.39	21451372.0
2008-08-04 16:00:00	QQQ	ETF	44.4	44.9182	44.375	44.9182	3715912.0
2008-08-04 17:00:00	QQQ	ETF	44.9182	44.9182	44.52	44.57	6617123.0
2008-08-04 18:00:00	QQQ	ETF	44.57	44.64	44.52	44.54	67930.0
2008-08-04 19:00:00	QQQ	ETF	44.55	44.57	44.54	44.54	8846.0
2008-08-04 05:00:00	IWM	ETF	71.46	71.46	71.45	71.45	200.0
2008-08-04 06:00:00	IWM	ETF	71.45	71.46	71.45	71.46	200.0
2008-08-04 07:00:00	IWM	ETF	71.41	71.43	71.35	71.37	118500.0
2008-08-04 08:00:00	IWM	ETF	71.43	71.43	71.28	71.36	735423.0
2008-08-04 09:00:00	IWM	ETF	71.36	71.49	70.61	70.72	14053863.0
2008-08-04 10:00:00	IWM	ETF	70.73	70.75	70.01	70.06	13510731.0
2008-08-04 11:00:00	IWM	ETF	70.06	71.41	69.81	70.59	16970024.0
2008-08-04 12:00:00	IWM	ETF	70.59	70.71	70.32	70.33	7088153.0
2008-08-04 13:00:00	IWM	ETF	70.33	70.51	70.17	70.5	6999976.0
2008-08-04 14:00:00	IWM	ETF	70.49	71.0	70.44	70.91	10422373.0
2008-08-04 15:00:00	IWM	ETF	70.91	70.94	70.1	70.21	17639899.0
2008-08-04 16:00:00	IWM	ETF	70.2	70.75	70.19	70.2	9947261.0
2008-08-04 17:00:00	IWM	ETF	70.37	70.37	70.33	70.37	26774.0
2008-08-04 06:00:00	DIA	ETF	113.12	113.12	113.12	113.12	100.0
2008-08-04 07:00:00	DIA	ETF	112.95	113.06	112.95	113.06	1000.0
2008-08-04 08:00:00	DIA	ETF	113.08	113.16	112.91	113.01	62962.0
2008-08-04 09:00:00	DIA	ETF	113.0	113.2	112.48	112.7	1804398.0
2008-08-04 10:00:00	DIA	ETF	112.69	112.82	112.13	112.3	2557198.0
2008-08-04 11:00:00	DIA	ETF	112.29	113.33	112.17	113.15	2911008.0
2008-08-04 12:00:00	DIA	ETF	113.13	113.36	112.89	112.95	1347543.0

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

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