PREVIEW / etf_1hour / 2008-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-14.parquet
  size:    111 KB
  rows:    3,557

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-14 04:00:00	SPY	ETF	125.11	125.16	124.77	124.77	800.0
2008-07-14 05:00:00	SPY	ETF	124.68	125.0	124.64	125.0	7900.0
2008-07-14 06:00:00	SPY	ETF	124.98	125.5	124.98	125.5	117700.0
2008-07-14 07:00:00	SPY	ETF	125.45	125.92	125.41	125.47	2074611.0
2008-07-14 08:00:00	SPY	ETF	125.49	125.83	125.39	125.41	3043429.0
2008-07-14 09:00:00	SPY	ETF	125.42	125.53	124.23	124.25	44912033.0
2008-07-14 10:00:00	SPY	ETF	124.24	124.8392	123.67	124.29	55869910.0
2008-07-14 11:00:00	SPY	ETF	124.28	124.38	122.5	123.03	41717323.0
2008-07-14 12:00:00	SPY	ETF	123.03	123.2	122.58	122.88	32488166.0
2008-07-14 13:00:00	SPY	ETF	122.89	123.9266	122.4	123.1	34525906.0
2008-07-14 14:00:00	SPY	ETF	123.1	123.9266	122.69	122.88	31011848.0
2008-07-14 15:00:00	SPY	ETF	122.87	123.79	122.51	122.82	61295363.0
2008-07-14 16:00:00	SPY	ETF	122.83	123.2941	122.51	122.81	5357864.0
2008-07-14 17:00:00	SPY	ETF	122.8	122.86	122.64	122.73	210399.0
2008-07-14 18:00:00	SPY	ETF	122.76	122.86	122.73	122.79	67656.0
2008-07-14 19:00:00	SPY	ETF	122.76	122.81	122.71	122.8	66286.0
2008-07-14 04:00:00	QQQ	ETF	45.03	45.1	44.97	44.97	400.0
2008-07-14 05:00:00	QQQ	ETF	44.92	44.93	44.92	44.93	300.0
2008-07-14 06:00:00	QQQ	ETF	45.08	45.27	45.07	45.27	181750.0
2008-07-14 07:00:00	QQQ	ETF	45.25	45.38	45.19	45.22	386718.0
2008-07-14 08:00:00	QQQ	ETF	45.22	45.25	45.06	45.17	1538145.0
2008-07-14 09:00:00	QQQ	ETF	45.18	45.19	44.67	44.69	22161622.0
2008-07-14 10:00:00	QQQ	ETF	44.68	44.85	44.35	44.7	36717759.0
2008-07-14 11:00:00	QQQ	ETF	44.7	44.75	44.12	44.34	22275814.0
2008-07-14 12:00:00	QQQ	ETF	44.34	44.3685	44.13	44.25	16674610.0
2008-07-14 13:00:00	QQQ	ETF	44.25	44.52	44.07	44.4	17495225.0
2008-07-14 14:00:00	QQQ	ETF	44.406	44.53	44.14	44.22	17442579.0
2008-07-14 15:00:00	QQQ	ETF	44.22	44.62	44.08	44.23	31138297.0
2008-07-14 16:00:00	QQQ	ETF	44.23	44.5319	44.14	44.19	8193301.0
2008-07-14 17:00:00	QQQ	ETF	44.19	44.21	44.16	44.16	13344.0
2008-07-14 18:00:00	QQQ	ETF	44.18	44.2	44.17	44.19	48570.0
2008-07-14 19:00:00	QQQ	ETF	44.19	44.2	44.16	44.2	21443.0
2008-07-14 06:00:00	IWM	ETF	67.91	67.93	67.91	67.93	600.0
2008-07-14 07:00:00	IWM	ETF	68.09	68.22	67.88	67.94	195288.0
2008-07-14 08:00:00	IWM	ETF	67.95	68.07	67.89	67.9	365266.0
2008-07-14 09:00:00	IWM	ETF	67.88	67.92	66.78	66.8	11058174.0
2008-07-14 10:00:00	IWM	ETF	66.8	67.25	66.37	66.95	14617875.0
2008-07-14 11:00:00	IWM	ETF	66.95	67.0	65.86	66.17	12270817.0
2008-07-14 12:00:00	IWM	ETF	66.16	66.39	65.95	66.21	10479257.0
2008-07-14 13:00:00	IWM	ETF	66.22	66.59	66.0	66.45	9482516.0
2008-07-14 14:00:00	IWM	ETF	66.44	66.67	66.05	66.17	9091609.0
2008-07-14 15:00:00	IWM	ETF	66.16	66.73	65.96	66.29	20236109.0
2008-07-14 16:00:00	IWM	ETF	66.29	67.29	65.99	66.1	17544488.0
2008-07-14 17:00:00	IWM	ETF	66.16	66.18	66.05	66.06	26755.0
2008-07-14 18:00:00	IWM	ETF	66.07	66.15	66.07	66.07	954.0
2008-07-14 04:00:00	DIA	ETF	112.85	112.85	112.85	112.85	100.0
2008-07-14 05:00:00	DIA	ETF	111.25	112.19	111.25	112.19	700.0
2008-07-14 06:00:00	DIA	ETF	112.06	112.25	112.06	112.24	25300.0
2008-07-14 07:00:00	DIA	ETF	112.29	112.58	112.25	112.27	25220.0
2008-07-14 08:00:00	DIA	ETF	112.31	112.43	112.24	112.27	79997.0

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

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