PREVIEW / etf_1hour / 2006-06-22

all etf 1-hour files

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

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-22 04:00:00	SPY	ETF	125.45	125.45	125.45	125.45	3000.0
2006-06-22 05:00:00	SPY	ETF	125.32	125.32	125.32	125.32	10000.0
2006-06-22 06:00:00	SPY	ETF	125.27	125.27	125.27	125.27	1000.0
2006-06-22 07:00:00	SPY	ETF	125.23	125.26	125.06	125.09	24400.0
2006-06-22 08:00:00	SPY	ETF	125.1	125.21	124.97	125.05	1033400.0
2006-06-22 09:00:00	SPY	ETF	125.01	125.06	124.74	124.96	6506600.0
2006-06-22 10:00:00	SPY	ETF	124.96	125.03	124.37	124.61	17417500.0
2006-06-22 11:00:00	SPY	ETF	124.62	124.84	124.46	124.7	7182700.0
2006-06-22 12:00:00	SPY	ETF	124.71	124.84	124.22	124.43	6110900.0
2006-06-22 13:00:00	SPY	ETF	124.42	124.51	124.04	124.31	8943900.0
2006-06-22 14:00:00	SPY	ETF	124.31	124.48	124.04	124.4	6791800.0
2006-06-22 15:00:00	SPY	ETF	124.4	124.69	124.25	124.45	17287100.0
2006-06-22 16:00:00	SPY	ETF	124.46	124.5	124.34	124.45	2307500.0
2006-06-22 17:00:00	SPY	ETF	124.48	124.48	124.43	124.43	30700.0
2006-06-22 18:00:00	SPY	ETF	124.46	124.47	124.42	124.47	13600.0
2006-06-22 19:00:00	SPY	ETF	124.47	124.48	124.45	124.46	1500.0
2006-06-22 09:00:00	QQQ	ETF	38.6	38.68	38.49	38.56	13319000.0
2006-06-22 10:00:00	QQQ	ETF	38.56	38.59	38.1	38.22	37942500.0
2006-06-22 11:00:00	QQQ	ETF	38.23	38.35	38.16	38.25	14258800.0
2006-06-22 12:00:00	QQQ	ETF	38.25	38.32	38.08	38.17	13610900.0
2006-06-22 13:00:00	QQQ	ETF	38.17	38.22	37.99	38.14	15150300.0
2006-06-22 14:00:00	QQQ	ETF	38.14	38.23	38.03	38.17	16096400.0
2006-06-22 15:00:00	QQQ	ETF	38.17	38.27	38.09	38.19	20838100.0
2006-06-22 08:00:00	IWM	ETF	68.58	68.66	68.31	68.36	439700.0
2006-06-22 09:00:00	IWM	ETF	68.36	68.54	68.1	68.49	8228700.0
2006-06-22 10:00:00	IWM	ETF	68.5	68.57	67.96	68.21	9377200.0
2006-06-22 11:00:00	IWM	ETF	68.22	68.59	68.14	68.49	4233500.0
2006-06-22 12:00:00	IWM	ETF	68.5	68.61	68.02	68.18	5921000.0
2006-06-22 13:00:00	IWM	ETF	68.19	68.29	67.86	68.11	6111900.0
2006-06-22 14:00:00	IWM	ETF	68.09	68.25	67.86	68.15	5721500.0
2006-06-22 15:00:00	IWM	ETF	68.18	68.48	68.05	68.33	8477000.0
2006-06-22 16:00:00	IWM	ETF	68.32	68.38	68.11	68.23	1866600.0
2006-06-22 17:00:00	IWM	ETF	68.19	68.19	68.19	68.19	500.0
2006-06-22 18:00:00	IWM	ETF	68.37	68.37	68.37	68.37	3416300.0
2006-06-22 08:00:00	DIA	ETF	110.69	110.69	110.59	110.59	4200.0
2006-06-22 09:00:00	DIA	ETF	110.61	110.67	110.4	110.56	726800.0
2006-06-22 10:00:00	DIA	ETF	110.56	110.59	110.16	110.41	1006900.0
2006-06-22 11:00:00	DIA	ETF	110.41	110.63	110.25	110.43	427600.0
2006-06-22 12:00:00	DIA	ETF	110.43	110.51	110.04	110.23	378100.0
2006-06-22 13:00:00	DIA	ETF	110.19	110.29	109.85	110.04	794600.0
2006-06-22 14:00:00	DIA	ETF	110.03	110.18	109.79	110.1	779400.0
2006-06-22 15:00:00	DIA	ETF	110.1151	110.33	110.01	110.13	659400.0
2006-06-22 16:00:00	DIA	ETF	110.1	110.25	110.07	110.25	308300.0
2006-06-22 17:00:00	DIA	ETF	110.2	110.2	110.2	110.2	100.0
2006-06-22 19:00:00	DIA	ETF	110.25	110.25	110.25	110.25	100.0
2006-06-22 07:00:00	GLD	ETF	58.32	58.55	58.32	58.37	20800.0
2006-06-22 08:00:00	GLD	ETF	58.43	58.7	58.15	58.53	682700.0
2006-06-22 09:00:00	GLD	ETF	58.56	58.58	58.04	58.2	937100.0
2006-06-22 10:00:00	GLD	ETF	58.2	58.32	57.83	58.31	1126900.0
2006-06-22 11:00:00	GLD	ETF	58.31	58.61	58.14	58.28	847300.0

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

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