PREVIEW / etf_1hour / 2006-03-15

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-15.parquet
  size:    40 KB
  rows:    1,250

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
2006-03-15 06:00:00	SPY	ETF	130.19	130.19	130.18	130.19	28000.0
2006-03-15 07:00:00	SPY	ETF	130.2	130.2	130.11	130.11	103800.0
2006-03-15 08:00:00	SPY	ETF	130.13	130.3	130.1	130.16	725000.0
2006-03-15 09:00:00	SPY	ETF	130.18	130.25	129.98	130.18	5175200.0
2006-03-15 10:00:00	SPY	ETF	130.18	130.23	129.9	129.97	6487800.0
2006-03-15 11:00:00	SPY	ETF	129.97	130.12	129.85	129.95	5467600.0
2006-03-15 12:00:00	SPY	ETF	129.93	130.2	129.87	130.1	3149300.0
2006-03-15 13:00:00	SPY	ETF	130.1	130.29	130.04	130.24	2682300.0
2006-03-15 14:00:00	SPY	ETF	130.23	130.76	130.15	130.57	12146500.0
2006-03-15 15:00:00	SPY	ETF	130.57	130.86	130.56	130.77	9098200.0
2006-03-15 16:00:00	SPY	ETF	130.76	130.8	129.9	130.65	5773800.0
2006-03-15 17:00:00	SPY	ETF	130.66	130.68	130.61	130.65	225100.0
2006-03-15 18:00:00	SPY	ETF	130.65	130.66	130.62	130.62	8500.0
2006-03-15 19:00:00	SPY	ETF	130.62	130.62	130.6	130.6	8900.0
2006-03-15 09:00:00	QQQ	ETF	41.53	41.58	41.43	41.55	9166100.0
2006-03-15 10:00:00	QQQ	ETF	41.56	41.57	41.37	41.4	12746600.0
2006-03-15 11:00:00	QQQ	ETF	41.39	41.44	41.32	41.37	14015800.0
2006-03-15 12:00:00	QQQ	ETF	41.37	41.48	41.34	41.45	7580200.0
2006-03-15 13:00:00	QQQ	ETF	41.45	41.49	41.4	41.47	3469400.0
2006-03-15 14:00:00	QQQ	ETF	41.47	41.64	41.44	41.52	13337000.0
2006-03-15 15:00:00	QQQ	ETF	41.53	41.71	41.49	41.71	18516400.0
2006-03-15 08:00:00	IWM	ETF	73.29	73.37	73.27	73.27	105000.0
2006-03-15 09:00:00	IWM	ETF	73.28	73.36	73.08	73.29	3193500.0
2006-03-15 10:00:00	IWM	ETF	73.31	73.47	73.14	73.18	2481700.0
2006-03-15 11:00:00	IWM	ETF	73.19	73.3	73.04	73.09	4427300.0
2006-03-15 12:00:00	IWM	ETF	73.1	73.5	73.07	73.38	3996700.0
2006-03-15 13:00:00	IWM	ETF	73.38	73.63	73.33	73.62	1924700.0
2006-03-15 14:00:00	IWM	ETF	73.61	73.79	73.54	73.64	4261800.0
2006-03-15 15:00:00	IWM	ETF	73.65	74.34	73.61	73.86	7874700.0
2006-03-15 16:00:00	IWM	ETF	73.87	73.98	73.87	73.95	3264900.0
2006-03-15 17:00:00	IWM	ETF	73.92	73.92	73.92	73.92	800.0
2006-03-15 18:00:00	IWM	ETF	73.85	73.85	73.85	73.85	100.0
2006-03-15 08:00:00	DIA	ETF	111.58	111.9	111.58	111.7	11600.0
2006-03-15 09:00:00	DIA	ETF	111.71	111.79	111.54	111.66	567000.0
2006-03-15 10:00:00	DIA	ETF	111.66	111.8	111.56	111.56	790200.0
2006-03-15 11:00:00	DIA	ETF	111.56	111.74	111.55	111.66	1078400.0
2006-03-15 12:00:00	DIA	ETF	111.66	111.86	111.6	111.78	447900.0
2006-03-15 13:00:00	DIA	ETF	111.78	111.92	111.7	111.89	418100.0
2006-03-15 14:00:00	DIA	ETF	111.87	112.29	111.81	112.2	1386200.0
2006-03-15 15:00:00	DIA	ETF	112.16	112.43	112.14	112.31	749000.0
2006-03-15 16:00:00	DIA	ETF	112.32	112.36	112.27	112.28	268700.0
2006-03-15 17:00:00	DIA	ETF	112.25	112.3	112.25	112.3	400.0
2006-03-15 19:00:00	DIA	ETF	112.25	112.28	112.25	112.25	1900.0
2006-03-15 07:00:00	GLD	ETF	54.98	54.98	54.98	54.98	1500.0
2006-03-15 08:00:00	GLD	ETF	54.98	55.19	54.88	55.17	14000.0
2006-03-15 09:00:00	GLD	ETF	55.12	55.46	55.11	55.42	2091000.0
2006-03-15 10:00:00	GLD	ETF	55.42	55.44	55.1702	55.28	721900.0
2006-03-15 11:00:00	GLD	ETF	55.28	55.28	55.05	55.21	452700.0
2006-03-15 12:00:00	GLD	ETF	55.21	55.3299	55.03	55.1	274700.0
2006-03-15 13:00:00	GLD	ETF	55.1	55.17	54.98	55.07	557800.0

> showing 50 of 1,250 rows — these rows as CSV

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