PREVIEW / etf_1hour / 2006-03-03

all etf 1-hour files

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

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-03 06:00:00	SPY	ETF	129.38	129.39	129.36	129.36	27000.0
2006-03-03 07:00:00	SPY	ETF	129.36	129.37	129.27	129.3	7400.0
2006-03-03 08:00:00	SPY	ETF	129.25	129.36	128.74	128.74	1244600.0
2006-03-03 09:00:00	SPY	ETF	128.74	128.97	128.2	128.94	9058900.0
2006-03-03 10:00:00	SPY	ETF	128.94	129.29	128.71	128.94	11978500.0
2006-03-03 11:00:00	SPY	ETF	128.94	129.14	128.76	129.07	4309700.0
2006-03-03 12:00:00	SPY	ETF	129.07	129.7	129.05	129.56	10074700.0
2006-03-03 13:00:00	SPY	ETF	129.55	130.07	129.44	129.88	9431500.0
2006-03-03 14:00:00	SPY	ETF	129.88	129.94	129.64	129.81	5716600.0
2006-03-03 15:00:00	SPY	ETF	129.82	129.84	128.99	128.99	16436600.0
2006-03-03 16:00:00	SPY	ETF	128.99	129.5617	128.65	128.76	3570900.0
2006-03-03 17:00:00	SPY	ETF	128.76	128.82	128.76	128.82	13000.0
2006-03-03 18:00:00	SPY	ETF	128.79	128.83	128.75	128.83	27300.0
2006-03-03 19:00:00	SPY	ETF	128.84	128.85	128.84	128.84	500.0
2006-03-03 09:00:00	QQQ	ETF	41.45	41.58	41.25	41.53	15953700.0
2006-03-03 10:00:00	QQQ	ETF	41.53	41.71	41.42	41.54	13729200.0
2006-03-03 11:00:00	QQQ	ETF	41.53	41.68	41.49	41.65	7017900.0
2006-03-03 12:00:00	QQQ	ETF	41.66	41.93	41.63	41.85	12940200.0
2006-03-03 13:00:00	QQQ	ETF	41.85	42.01	41.8	41.93	14551500.0
2006-03-03 14:00:00	QQQ	ETF	41.93	41.97	41.77	41.84	11380700.0
2006-03-03 15:00:00	QQQ	ETF	41.84	41.86	41.43	41.44	22857700.0
2006-03-03 07:00:00	IWM	ETF	73.67	73.67	73.67	73.67	900.0
2006-03-03 08:00:00	IWM	ETF	73.54	73.6	73.28	73.28	84300.0
2006-03-03 09:00:00	IWM	ETF	73.28	73.42	73.0	73.37	4315300.0
2006-03-03 10:00:00	IWM	ETF	73.37	73.72	73.23	73.34	6551800.0
2006-03-03 11:00:00	IWM	ETF	73.33	73.58	73.18	73.54	5300800.0
2006-03-03 12:00:00	IWM	ETF	73.56	73.95	73.56	73.77	4740700.0
2006-03-03 13:00:00	IWM	ETF	73.7686	74.14	73.66	73.96	3990300.0
2006-03-03 14:00:00	IWM	ETF	73.95	74.06	73.69	73.86	3884500.0
2006-03-03 15:00:00	IWM	ETF	73.86	73.9	73.36	73.38	6170100.0
2006-03-03 16:00:00	IWM	ETF	73.37	73.39	73.18	73.23	1381600.0
2006-03-03 17:00:00	IWM	ETF	73.24	73.24	73.24	73.24	500.0
2006-03-03 08:00:00	DIA	ETF	110.35	110.38	110.04	110.1	38700.0
2006-03-03 09:00:00	DIA	ETF	109.95	110.15	109.64	110.07	554400.0
2006-03-03 10:00:00	DIA	ETF	110.05	110.36	109.91	110.11	700300.0
2006-03-03 11:00:00	DIA	ETF	110.1	110.19	109.9	110.15	388000.0
2006-03-03 12:00:00	DIA	ETF	110.15	110.74	110.14	110.65	1121400.0
2006-03-03 13:00:00	DIA	ETF	110.67	111.05	110.57	110.91	1086000.0
2006-03-03 14:00:00	DIA	ETF	110.91	111.0	110.77	110.93	451900.0
2006-03-03 15:00:00	DIA	ETF	110.93	110.97	110.2	110.2	1708200.0
2006-03-03 16:00:00	DIA	ETF	110.17	110.19	110.0	110.03	156600.0
2006-03-03 18:00:00	DIA	ETF	110.1	110.1	110.1	110.1	100.0
2006-03-03 19:00:00	DIA	ETF	110.1	110.1	110.1	110.1	300.0
2006-03-03 07:00:00	GLD	ETF	56.59	56.61	56.48	56.5	9500.0
2006-03-03 08:00:00	GLD	ETF	56.61	56.67	56.3	56.48	80400.0
2006-03-03 09:00:00	GLD	ETF	56.51	56.52	56.29	56.42	642900.0
2006-03-03 10:00:00	GLD	ETF	56.41	56.42	56.2	56.4	843300.0
2006-03-03 11:00:00	GLD	ETF	56.35	56.54	56.3	56.36	447500.0
2006-03-03 12:00:00	GLD	ETF	56.36	56.48	56.3501	56.48	213400.0
2006-03-03 13:00:00	GLD	ETF	56.47	56.5	56.27	56.36	201700.0

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

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