PREVIEW / etf_1hour / 2008-07-11

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-11.parquet
  size:    113 KB
  rows:    3,588

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-11 04:00:00	SPY	ETF	124.99	125.32	124.99	125.16	2700.0
2008-07-11 05:00:00	SPY	ETF	125.07	125.07	124.85	124.85	42200.0
2008-07-11 06:00:00	SPY	ETF	124.86	125.04	124.3	124.66	550600.0
2008-07-11 07:00:00	SPY	ETF	124.63	124.7	123.74	124.1	3811326.0
2008-07-11 08:00:00	SPY	ETF	124.1	126.0	123.63	123.83	7557376.0
2008-07-11 09:00:00	SPY	ETF	123.82	124.45	123.29	124.32	60342817.0
2008-07-11 10:00:00	SPY	ETF	124.32	125.3154	123.14	123.66	82311582.0
2008-07-11 11:00:00	SPY	ETF	123.66	123.87	122.64	123.51	52452610.0
2008-07-11 12:00:00	SPY	ETF	123.51	123.53	122.53	122.79	30994493.0
2008-07-11 13:00:00	SPY	ETF	122.79	123.76	122.49	123.48	48956383.0
2008-07-11 14:00:00	SPY	ETF	123.47	125.3	122.96	124.9	74543878.0
2008-07-11 15:00:00	SPY	ETF	124.9	125.9	123.21	124.02	102649318.0
2008-07-11 16:00:00	SPY	ETF	124.0299	124.25	123.27	123.91	9523829.0
2008-07-11 17:00:00	SPY	ETF	123.85	124.2	123.85	124.1	178899.0
2008-07-11 18:00:00	SPY	ETF	124.12	124.26	123.96	124.18	125460.0
2008-07-11 19:00:00	SPY	ETF	124.02	124.2	123.8	123.87	21953.0
2008-07-11 04:00:00	QQQ	ETF	45.14	45.14	45.14	45.14	400.0
2008-07-11 05:00:00	QQQ	ETF	45.18	45.18	45.12	45.12	700.0
2008-07-11 06:00:00	QQQ	ETF	45.08	45.11	44.94	44.96	72800.0
2008-07-11 07:00:00	QQQ	ETF	45.02	45.04	44.69	44.84	1093921.0
2008-07-11 08:00:00	QQQ	ETF	44.83	44.92	44.64	44.76	3457752.0
2008-07-11 09:00:00	QQQ	ETF	44.75	44.95	44.41	44.84	35020958.0
2008-07-11 10:00:00	QQQ	ETF	44.83	44.92	44.39	44.65	32065921.0
2008-07-11 11:00:00	QQQ	ETF	44.64	44.7	44.19	44.55	32559342.0
2008-07-11 12:00:00	QQQ	ETF	44.55	44.58	43.85	43.98	25240678.0
2008-07-11 13:00:00	QQQ	ETF	43.97	44.45	43.9	44.35	25386942.0
2008-07-11 14:00:00	QQQ	ETF	44.35	44.93	44.11	44.8799	38116187.0
2008-07-11 15:00:00	QQQ	ETF	44.88	45.27	44.32	44.57	63477416.0
2008-07-11 16:00:00	QQQ	ETF	44.56	44.65	43.95	44.52	3670784.0
2008-07-11 17:00:00	QQQ	ETF	44.54	45.97	44.51	44.57	21215.0
2008-07-11 18:00:00	QQQ	ETF	44.53	44.66	44.53	44.66	70167.0
2008-07-11 19:00:00	QQQ	ETF	44.67	44.67	44.51	44.52	16405.0
2008-07-11 06:00:00	IWM	ETF	66.58	66.58	66.46	66.46	500.0
2008-07-11 07:00:00	IWM	ETF	66.57	66.57	66.14	66.32	88031.0
2008-07-11 08:00:00	IWM	ETF	66.49	67.6	66.06	66.16	617070.0
2008-07-11 09:00:00	IWM	ETF	66.13	66.77	65.77	66.59	11923435.0
2008-07-11 10:00:00	IWM	ETF	66.58	66.87	65.87	66.11	22045859.0
2008-07-11 11:00:00	IWM	ETF	66.1	66.54	65.75	66.48	14486602.0
2008-07-11 12:00:00	IWM	ETF	66.49	66.52	65.67	65.86	7695458.0
2008-07-11 13:00:00	IWM	ETF	65.87	66.72	65.69	66.54	10580049.0
2008-07-11 14:00:00	IWM	ETF	66.54	67.34	66.17	67.28	17287771.0
2008-07-11 15:00:00	IWM	ETF	67.28	67.78	66.72	67.28	35665538.0
2008-07-11 16:00:00	IWM	ETF	67.27	67.41	66.2	67.0	6319924.0
2008-07-11 17:00:00	IWM	ETF	66.99	67.15	66.9	66.98	63342.0
2008-07-11 18:00:00	IWM	ETF	66.98	66.98	66.85	66.9	1803.0
2008-07-11 19:00:00	IWM	ETF	66.85	66.95	66.79	66.95	4140.0
2008-07-11 06:00:00	DIA	ETF	111.7	111.7	111.7	111.7	100.0
2008-07-11 07:00:00	DIA	ETF	111.6	111.6	111.09	111.27	16616.0
2008-07-11 08:00:00	DIA	ETF	111.32	111.42	111.0	111.14	210703.0
2008-07-11 09:00:00	DIA	ETF	111.12	111.37	110.5	111.31	4501678.0

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

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