PREVIEW / etf_1hour / 2006-03-13

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-13.parquet
  size:    39 KB
  rows:    1,242

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-13 07:00:00	SPY	ETF	128.9	128.9	128.8	128.82	35300.0
2006-03-13 08:00:00	SPY	ETF	128.82	128.93	128.7	128.86	753500.0
2006-03-13 09:00:00	SPY	ETF	128.87	129.04	128.69	128.93	7339300.0
2006-03-13 10:00:00	SPY	ETF	128.94	129.16	128.91	129.01	9513600.0
2006-03-13 11:00:00	SPY	ETF	129.01	129.04	128.71	128.76	5626500.0
2006-03-13 12:00:00	SPY	ETF	128.75	128.89	128.67	128.83	2978200.0
2006-03-13 13:00:00	SPY	ETF	128.82	128.86	128.53	128.74	4798400.0
2006-03-13 14:00:00	SPY	ETF	128.75	128.96	128.64	128.67	4342900.0
2006-03-13 15:00:00	SPY	ETF	128.67	128.86	128.53	128.82	7348100.0
2006-03-13 16:00:00	SPY	ETF	128.83	128.91	128.75	128.84	886200.0
2006-03-13 17:00:00	SPY	ETF	128.84	128.85	128.81	128.85	75100.0
2006-03-13 18:00:00	SPY	ETF	128.85	128.86	128.76	128.86	234400.0
2006-03-13 19:00:00	SPY	ETF	128.82	128.82	128.77	128.8	23100.0
2006-03-13 09:00:00	QQQ	ETF	40.76	40.9	40.73	40.85	10575900.0
2006-03-13 10:00:00	QQQ	ETF	40.85	40.94	40.75	40.84	13823300.0
2006-03-13 11:00:00	QQQ	ETF	40.84	40.84	40.65	40.67	9484100.0
2006-03-13 12:00:00	QQQ	ETF	40.66	40.78	40.63	40.75	5057600.0
2006-03-13 13:00:00	QQQ	ETF	40.75	40.77	40.62	40.66	9026300.0
2006-03-13 14:00:00	QQQ	ETF	40.66	40.78	40.62	40.65	6404400.0
2006-03-13 15:00:00	QQQ	ETF	40.64	40.73	40.62	40.67	9172800.0
2006-03-13 07:00:00	IWM	ETF	72.38	72.44	72.38	72.44	600.0
2006-03-13 08:00:00	IWM	ETF	72.38	72.6	72.38	72.56	219400.0
2006-03-13 09:00:00	IWM	ETF	72.6	72.95	72.58	72.8	5546400.0
2006-03-13 10:00:00	IWM	ETF	72.8	73.08	72.79	72.92	4699900.0
2006-03-13 11:00:00	IWM	ETF	72.92	72.94	72.69	72.69	4104500.0
2006-03-13 12:00:00	IWM	ETF	72.69	72.84	72.66	72.84	1730200.0
2006-03-13 13:00:00	IWM	ETF	72.84	72.85	72.56	72.59	5493400.0
2006-03-13 14:00:00	IWM	ETF	72.6	72.76	72.32	72.35	5133700.0
2006-03-13 15:00:00	IWM	ETF	72.35	72.43	72.2	72.38	7054600.0
2006-03-13 16:00:00	IWM	ETF	72.4	72.695	72.4	72.5	734000.0
2006-03-13 17:00:00	IWM	ETF	72.45	72.45	72.41	72.41	200.0
2006-03-13 18:00:00	IWM	ETF	72.41	72.41	72.4	72.4	1900.0
2006-03-13 19:00:00	IWM	ETF	72.4	72.4	72.38	72.38	19400.0
2006-03-13 07:00:00	DIA	ETF	111.0	111.05	111.0	111.04	400.0
2006-03-13 08:00:00	DIA	ETF	111.01	111.05	110.98	111.05	3100.0
2006-03-13 09:00:00	DIA	ETF	111.08	111.18	110.97	111.07	1195400.0
2006-03-13 10:00:00	DIA	ETF	111.08	111.31	111.08	111.18	1191800.0
2006-03-13 11:00:00	DIA	ETF	111.18	111.22	110.95	110.97	638600.0
2006-03-13 12:00:00	DIA	ETF	110.98	111.08	110.91	111.04	830600.0
2006-03-13 13:00:00	DIA	ETF	111.05	111.06	110.74	110.9	576200.0
2006-03-13 14:00:00	DIA	ETF	110.89	111.05	110.72	110.79	615700.0
2006-03-13 15:00:00	DIA	ETF	110.8	110.96	110.67	110.91	501900.0
2006-03-13 16:00:00	DIA	ETF	110.93	111.04	110.91	111.04	63400.0
2006-03-13 19:00:00	DIA	ETF	111.0	111.0	111.0	111.0	800.0
2006-03-13 07:00:00	GLD	ETF	54.06	54.14	54.06	54.08	6900.0
2006-03-13 08:00:00	GLD	ETF	54.07	54.14	53.92	54.02	99700.0
2006-03-13 09:00:00	GLD	ETF	53.88	54.13	53.88	53.96	603100.0
2006-03-13 10:00:00	GLD	ETF	53.96	54.13	53.96	54.09	493300.0
2006-03-13 11:00:00	GLD	ETF	54.1	54.27	54.08	54.2588	349400.0
2006-03-13 12:00:00	GLD	ETF	54.25	54.42	54.22	54.3	227100.0

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

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