PREVIEW / etf_1hour / 2006-06-08

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-08.parquet
  size:    47 KB
  rows:    1,436

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-06-08 04:00:00	SPY	ETF	125.1	125.15	125.04	125.04	3100.0
2006-06-08 06:00:00	SPY	ETF	125.24	125.56	125.24	125.35	40500.0
2006-06-08 07:00:00	SPY	ETF	125.41	125.41	125.18	125.29	1019800.0
2006-06-08 08:00:00	SPY	ETF	125.28	125.79	125.17	125.76	6028000.0
2006-06-08 09:00:00	SPY	ETF	125.76	126.18	125.14	125.69	17547300.0
2006-06-08 10:00:00	SPY	ETF	125.69	125.86	125.04	125.27	25502500.0
2006-06-08 11:00:00	SPY	ETF	125.24	126.13	123.87	124.23	48510900.0
2006-06-08 12:00:00	SPY	ETF	124.23	124.95	124.19	124.69	21064900.0
2006-06-08 13:00:00	SPY	ETF	124.7	125.26	124.31	125.25	20312700.0
2006-06-08 14:00:00	SPY	ETF	125.25	125.85	124.89	125.27	25764800.0
2006-06-08 15:00:00	SPY	ETF	125.27	126.5	125.16	126.12	33320000.0
2006-06-08 16:00:00	SPY	ETF	126.11	126.2142	125.71	126.01	2626000.0
2006-06-08 17:00:00	SPY	ETF	126.04	126.09	126.0	126.09	113400.0
2006-06-08 18:00:00	SPY	ETF	126.02	126.04	125.9	126.02	8700.0
2006-06-08 19:00:00	SPY	ETF	126.02	126.04	125.98	126.04	7400.0
2006-06-08 09:00:00	QQQ	ETF	38.27	38.49	38.13	38.31	30070800.0
2006-06-08 10:00:00	QQQ	ETF	38.31	38.43	37.95	38.07	37746700.0
2006-06-08 11:00:00	QQQ	ETF	38.07	38.2	37.49	37.7	45483900.0
2006-06-08 12:00:00	QQQ	ETF	37.7	38.03	37.69	37.94	27819400.0
2006-06-08 13:00:00	QQQ	ETF	37.94	38.07	37.67	38.06	34805000.0
2006-06-08 14:00:00	QQQ	ETF	38.05	38.21	37.89	38.05	29520600.0
2006-06-08 15:00:00	QQQ	ETF	38.04	38.56	37.99	38.4	43985800.0
2006-06-08 08:00:00	IWM	ETF	69.68	69.95	69.5	69.95	285500.0
2006-06-08 09:00:00	IWM	ETF	69.94	69.97	69.12	69.55	15151200.0
2006-06-08 10:00:00	IWM	ETF	69.53	69.75	68.81	69.05	25422500.0
2006-06-08 11:00:00	IWM	ETF	69.04	69.43	68.0	68.34	30043500.0
2006-06-08 12:00:00	IWM	ETF	68.35	69.2	68.22	68.97	16635200.0
2006-06-08 13:00:00	IWM	ETF	68.97	69.75	68.57	69.58	12190800.0
2006-06-08 14:00:00	IWM	ETF	69.58	70.02	69.16	69.71	19567900.0
2006-06-08 15:00:00	IWM	ETF	69.7	70.42	69.64	70.25	16371700.0
2006-06-08 16:00:00	IWM	ETF	70.24	70.4	69.92	70.29	1303000.0
2006-06-08 17:00:00	IWM	ETF	70.25	70.32	70.25	70.32	6300.0
2006-06-08 18:00:00	IWM	ETF	70.32	70.32	70.22	70.22	1600.0
2006-06-08 19:00:00	IWM	ETF	70.25	70.25	70.22	70.22	5100.0
2006-06-08 04:00:00	DIA	ETF	108.9	108.9	108.9	108.9	100.0
2006-06-08 07:00:00	DIA	ETF	108.96	108.96	108.74	108.74	3400.0
2006-06-08 08:00:00	DIA	ETF	108.86	109.36	108.68	109.32	42300.0
2006-06-08 09:00:00	DIA	ETF	109.29	109.67	108.9	109.4	1893700.0
2006-06-08 10:00:00	DIA	ETF	109.4	109.48	108.65	108.83	2955700.0
2006-06-08 11:00:00	DIA	ETF	108.85	109.08	107.52	107.75	5998300.0
2006-06-08 12:00:00	DIA	ETF	107.75	108.44	107.74	108.27	3306900.0
2006-06-08 13:00:00	DIA	ETF	108.28	108.67	107.93	108.66	3368800.0
2006-06-08 14:00:00	DIA	ETF	108.66	109.04	108.39	108.73	2206200.0
2006-06-08 15:00:00	DIA	ETF	108.73	109.64	108.71	109.3	6110500.0
2006-06-08 16:00:00	DIA	ETF	109.29	109.3175	108.98	109.16	48300.0
2006-06-08 17:00:00	DIA	ETF	109.24	109.24	109.24	109.24	100.0
2006-06-08 18:00:00	DIA	ETF	109.17	109.17	109.02	109.17	600.0
2006-06-08 19:00:00	DIA	ETF	109.14	109.14	109.14	109.14	400.0
2006-06-08 04:00:00	GLD	ETF	62.0	62.0	62.0	62.0	300.0
2006-06-08 05:00:00	GLD	ETF	62.0	62.0	62.0	62.0	200.0

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

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