PREVIEW / etf_1hour / 2008-07-03

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-03.parquet
  size:    73 KB
  rows:    2,205

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-07-03 04:00:00	SPY	ETF	126.52	126.52	126.5	126.5	200.0
2008-07-03 05:00:00	SPY	ETF	126.66	126.67	126.4	126.4	800.0
2008-07-03 06:00:00	SPY	ETF	126.2	126.23	126.1	126.1	15200.0
2008-07-03 07:00:00	SPY	ETF	126.12	126.39	125.84	126.18	1030635.0
2008-07-03 08:00:00	SPY	ETF	126.6	127.11	125.91	127.0	25804276.0
2008-07-03 09:00:00	SPY	ETF	126.99	127.22	125.42	125.96	51617942.0
2008-07-03 10:00:00	SPY	ETF	125.97	126.88	124.99	126.55	76801596.0
2008-07-03 11:00:00	SPY	ETF	126.55	127.07	126.39	126.65	40892463.0
2008-07-03 12:00:00	SPY	ETF	126.64	126.68	125.98	126.14	37659346.0
2008-07-03 13:00:00	SPY	ETF	126.15	126.5	126.05	126.35	2278365.0
2008-07-03 14:00:00	SPY	ETF	126.35	126.4	126.32	126.4	22863.0
2008-07-03 15:00:00	SPY	ETF	126.4	126.44	126.35	126.38	11894.0
2008-07-03 16:00:00	SPY	ETF	126.4	126.43	126.18	126.25	17212.0
2008-07-03 04:00:00	QQQ	ETF	44.64	44.64	44.64	44.64	100.0
2008-07-03 05:00:00	QQQ	ETF	44.7	44.7	44.64	44.65	2700.0
2008-07-03 06:00:00	QQQ	ETF	44.58	44.58	44.57	44.57	17200.0
2008-07-03 07:00:00	QQQ	ETF	44.52	44.63	44.43	44.56	595859.0
2008-07-03 08:00:00	QQQ	ETF	44.55	44.94	44.42	44.88	7995868.0
2008-07-03 09:00:00	QQQ	ETF	44.87	44.99	44.41	44.62	23695165.0
2008-07-03 10:00:00	QQQ	ETF	44.62	45.08	44.28	44.9	39540186.0
2008-07-03 11:00:00	QQQ	ETF	44.9	45.05	44.82	44.865	18786453.0
2008-07-03 12:00:00	QQQ	ETF	44.86	44.88	44.56	44.65	26058620.0
2008-07-03 13:00:00	QQQ	ETF	44.66	44.8	44.6	44.6	3147185.0
2008-07-03 14:00:00	QQQ	ETF	44.61	44.61	44.55	44.58	23031.0
2008-07-03 15:00:00	QQQ	ETF	44.58	44.64	44.56	44.64	21238.0
2008-07-03 16:00:00	QQQ	ETF	44.67	44.75	44.64	44.64	5600.0
2008-07-03 07:00:00	IWM	ETF	66.81	66.95	66.7	66.7	56100.0
2008-07-03 08:00:00	IWM	ETF	67.2	67.3	66.18	67.15	2372450.0
2008-07-03 09:00:00	IWM	ETF	67.19	67.3	65.96	66.27	13678377.0
2008-07-03 10:00:00	IWM	ETF	66.26	66.92	65.77	66.77	26565361.0
2008-07-03 11:00:00	IWM	ETF	66.77	67.02	66.63	66.7	13973696.0
2008-07-03 12:00:00	IWM	ETF	66.7	66.7	66.28	66.38	12984888.0
2008-07-03 13:00:00	IWM	ETF	66.37	66.68	66.2	66.44	1040832.0
2008-07-03 15:00:00	IWM	ETF	66.44	66.44	66.29	66.29	900.0
2008-07-03 16:00:00	IWM	ETF	66.35	66.35	66.32	66.32	2800.0
2008-07-03 04:00:00	DIA	ETF	112.36	112.36	112.36	112.36	100.0
2008-07-03 05:00:00	DIA	ETF	112.34	112.34	112.34	112.34	200.0
2008-07-03 07:00:00	DIA	ETF	112.2	112.28	111.92	112.18	8592.0
2008-07-03 08:00:00	DIA	ETF	112.16	112.87	112.09	112.8	244353.0
2008-07-03 09:00:00	DIA	ETF	112.83	112.98	111.81	112.26	3452969.0
2008-07-03 10:00:00	DIA	ETF	112.26	113.14	111.48	112.77	5996096.0
2008-07-03 11:00:00	DIA	ETF	112.76	113.32	112.7	113.03	4280109.0
2008-07-03 12:00:00	DIA	ETF	113.03	113.06	112.55	112.81	5354261.0
2008-07-03 13:00:00	DIA	ETF	112.83	113.05	112.78	112.85	298327.0
2008-07-03 14:00:00	DIA	ETF	112.86	112.86	112.78	112.78	1326.0
2008-07-03 16:00:00	DIA	ETF	112.75	112.75	112.75	112.75	400.0
2008-07-03 07:00:00	GLD	ETF	93.07	93.32	92.96	93.13	28149.0
2008-07-03 08:00:00	GLD	ETF	93.15	93.24	91.43	91.92	904408.0
2008-07-03 09:00:00	GLD	ETF	91.92	92.26	91.54	92.12	2759843.0
2008-07-03 10:00:00	GLD	ETF	92.12	92.51	91.68	92.49	2789173.0

> showing 50 of 2,205 rows — these rows as CSV

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