PREVIEW / etf_1hour / 2005-05-16

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-16.parquet
  size:    30 KB
  rows:    860

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
2005-05-16 06:00:00	SPY	ETF	115.82	115.82	115.82	115.82	5000.0
2005-05-16 07:00:00	SPY	ETF	115.7	115.91	115.7	115.85	89800.0
2005-05-16 08:00:00	SPY	ETF	115.85	115.95	115.67	115.79	339000.0
2005-05-16 09:00:00	SPY	ETF	115.78	116.19	115.65	115.9	7709900.0
2005-05-16 10:00:00	SPY	ETF	115.9	116.37	115.85	116.34	8856400.0
2005-05-16 11:00:00	SPY	ETF	116.34	116.35	116.06	116.2	5166900.0
2005-05-16 12:00:00	SPY	ETF	116.2	116.36	116.06	116.31	3350100.0
2005-05-16 13:00:00	SPY	ETF	116.31	116.59	116.14	116.56	4833300.0
2005-05-16 14:00:00	SPY	ETF	116.53	116.62	116.33	116.44	5987700.0
2005-05-16 15:00:00	SPY	ETF	116.44	116.83	116.2784	116.79	10212900.0
2005-05-16 16:00:00	SPY	ETF	116.8	116.86	116.73	116.8	1482500.0
2005-05-16 17:00:00	SPY	ETF	116.8	116.82	116.78	116.78	7900.0
2005-05-16 18:00:00	SPY	ETF	116.78	116.78	116.77	116.77	5600.0
2005-05-16 19:00:00	SPY	ETF	116.75	116.75	116.75	116.75	500.0
2005-05-16 09:00:00	QQQ	ETF	36.24	36.33	36.13	36.17	12972900.0
2005-05-16 10:00:00	QQQ	ETF	36.16	36.4	36.15	36.39	16105200.0
2005-05-16 11:00:00	QQQ	ETF	36.39	36.39	36.27	36.31	6018500.0
2005-05-16 12:00:00	QQQ	ETF	36.32	36.38	36.31	36.38	4212400.0
2005-05-16 13:00:00	QQQ	ETF	36.38	36.4	36.3	36.39	6969200.0
2005-05-16 14:00:00	QQQ	ETF	36.38	36.42	36.33	36.39	8545200.0
2005-05-16 15:00:00	QQQ	ETF	36.39	36.54	36.36	36.49	19214300.0
2005-05-16 08:00:00	IWM	ETF	58.09	58.09	58.085	58.085	1200.0
2005-05-16 09:00:00	IWM	ETF	58.03	58.48	57.95	58.28	5020800.0
2005-05-16 10:00:00	IWM	ETF	58.275	58.59	58.23	58.57	7270400.0
2005-05-16 11:00:00	IWM	ETF	58.565	58.575	58.38	58.45	3563800.0
2005-05-16 12:00:00	IWM	ETF	58.45	58.55	58.41	58.515	1335800.0
2005-05-16 13:00:00	IWM	ETF	58.515	58.65	58.415	58.595	1730800.0
2005-05-16 14:00:00	IWM	ETF	58.61	58.635	58.41	58.53	2288200.0
2005-05-16 15:00:00	IWM	ETF	58.53	59.0	58.5	58.89	7912800.0
2005-05-16 16:00:00	IWM	ETF	58.88	59.04	58.835	58.95	1383800.0
2005-05-16 18:00:00	IWM	ETF	58.935	58.95	58.91	58.915	9400.0
2005-05-16 08:00:00	DIA	ETF	101.78	101.84	101.77	101.84	4000.0
2005-05-16 09:00:00	DIA	ETF	101.63	102.07	101.59	101.83	804400.0
2005-05-16 10:00:00	DIA	ETF	101.82	102.22	101.81	102.2	655000.0
2005-05-16 11:00:00	DIA	ETF	102.2	102.22	102.01	102.1	503500.0
2005-05-16 12:00:00	DIA	ETF	102.11	102.22	101.98	102.14	351800.0
2005-05-16 13:00:00	DIA	ETF	102.13	102.46	102.0	102.41	831600.0
2005-05-16 14:00:00	DIA	ETF	102.41	102.47	102.22	102.31	1038800.0
2005-05-16 15:00:00	DIA	ETF	102.3	102.71	102.27	102.69	1467100.0
2005-05-16 16:00:00	DIA	ETF	102.65	102.69	102.63	102.65	135900.0
2005-05-16 17:00:00	DIA	ETF	102.7	102.7	102.7	102.7	100.0
2005-05-16 09:00:00	GLD	ETF	41.86	41.9	41.77	41.83	183100.0
2005-05-16 10:00:00	GLD	ETF	41.85	41.87	41.82	41.86	119800.0
2005-05-16 11:00:00	GLD	ETF	41.844	41.85	41.8	41.81	112000.0
2005-05-16 12:00:00	GLD	ETF	41.81	41.89	41.8	41.89	248100.0
2005-05-16 13:00:00	GLD	ETF	41.89	41.89	41.8	41.8	56500.0
2005-05-16 14:00:00	GLD	ETF	41.84	41.88	41.8	41.88	38600.0
2005-05-16 15:00:00	GLD	ETF	41.88	41.88	41.83	41.86	71900.0
2005-05-16 16:00:00	GLD	ETF	41.86	41.86	41.86	41.86	43600.0
2005-05-16 08:00:00	TLT	ETF	92.9	92.9	92.9	92.9	5000.0

> showing 50 of 860 rows — these rows as CSV

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