PREVIEW / etf_1hour / 2006-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-13.parquet
  size:    51 KB
  rows:    1,577

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-07-13 06:00:00	SPY	ETF	125.78	125.78	125.71	125.75	50000.0
2006-07-13 07:00:00	SPY	ETF	125.71	125.72	125.42	125.5	115100.0
2006-07-13 08:00:00	SPY	ETF	125.52	125.64	125.22	125.39	3762200.0
2006-07-13 09:00:00	SPY	ETF	125.39	125.6	124.94	125.01	10854500.0
2006-07-13 10:00:00	SPY	ETF	125.01	125.48	124.87	125.08	17258500.0
2006-07-13 11:00:00	SPY	ETF	125.08	125.4	124.83	125.27	10208700.0
2006-07-13 12:00:00	SPY	ETF	125.28	125.68	125.18	125.33	8957700.0
2006-07-13 13:00:00	SPY	ETF	125.3	125.45	124.61	124.63	12138300.0
2006-07-13 14:00:00	SPY	ETF	124.62	124.88	124.27	124.41	14029200.0
2006-07-13 15:00:00	SPY	ETF	124.41	124.48	124.12	124.19	16767900.0
2006-07-13 16:00:00	SPY	ETF	124.19	124.19	123.93	123.99	3228100.0
2006-07-13 17:00:00	SPY	ETF	123.99	124.04	123.92	123.92	1146200.0
2006-07-13 18:00:00	SPY	ETF	123.94	123.94	123.65	123.76	550600.0
2006-07-13 19:00:00	SPY	ETF	123.73	123.74	123.66	123.73	140800.0
2006-07-13 09:00:00	QQQ	ETF	36.66	36.67	36.39	36.41	20206200.0
2006-07-13 10:00:00	QQQ	ETF	36.41	36.78	36.36	36.62	37505600.0
2006-07-13 11:00:00	QQQ	ETF	36.62	36.85	36.55	36.77	21183700.0
2006-07-13 12:00:00	QQQ	ETF	36.77	37.04	36.77	36.8	20830200.0
2006-07-13 13:00:00	QQQ	ETF	36.8	36.84	36.46	36.47	17843600.0
2006-07-13 14:00:00	QQQ	ETF	36.47	36.63	36.4	36.44	21485700.0
2006-07-13 15:00:00	QQQ	ETF	36.43	36.5	36.31	36.32	25393400.0
2006-07-13 07:00:00	IWM	ETF	69.55	69.63	69.55	69.63	2500.0
2006-07-13 08:00:00	IWM	ETF	68.59	69.63	68.59	69.04	272000.0
2006-07-13 09:00:00	IWM	ETF	69.01	69.21	68.6	68.62	9553300.0
2006-07-13 10:00:00	IWM	ETF	68.64	69.5	68.55	68.87	15464000.0
2006-07-13 11:00:00	IWM	ETF	68.86	69.22	68.75	69.03	8736700.0
2006-07-13 12:00:00	IWM	ETF	69.05	69.5	68.98	69.07	8822700.0
2006-07-13 13:00:00	IWM	ETF	69.07	69.14	68.6	68.63	6135200.0
2006-07-13 14:00:00	IWM	ETF	68.63	69.6938	68.35	68.44	10976700.0
2006-07-13 15:00:00	IWM	ETF	68.45	69.39	68.14	68.26	18346600.0
2006-07-13 16:00:00	IWM	ETF	68.26	68.28	67.96	68.03	427500.0
2006-07-13 17:00:00	IWM	ETF	67.96	67.96	67.78	67.78	14000.0
2006-07-13 18:00:00	IWM	ETF	67.86	67.86	67.82	67.83	5900.0
2006-07-13 19:00:00	IWM	ETF	67.76	67.77	67.73	67.73	3000.0
2006-07-13 07:00:00	DIA	ETF	110.1	110.1	109.73	109.73	2500.0
2006-07-13 08:00:00	DIA	ETF	109.78	109.85	109.51	109.65	371800.0
2006-07-13 09:00:00	DIA	ETF	109.6	109.79	109.15	109.18	2983400.0
2006-07-13 10:00:00	DIA	ETF	109.18	109.55	109.02	109.28	2504100.0
2006-07-13 11:00:00	DIA	ETF	109.26	109.49	109.05	109.31	2066200.0
2006-07-13 12:00:00	DIA	ETF	109.32	109.62	109.25	109.29	2502800.0
2006-07-13 13:00:00	DIA	ETF	109.3	109.39	108.67	108.68	1773700.0
2006-07-13 14:00:00	DIA	ETF	108.68	108.89	108.49	108.53	1026600.0
2006-07-13 15:00:00	DIA	ETF	108.53	108.72	108.34	108.53	1626400.0
2006-07-13 16:00:00	DIA	ETF	108.51	108.51	108.27	108.35	54200.0
2006-07-13 17:00:00	DIA	ETF	108.3	108.3	108.3	108.3	100.0
2006-07-13 18:00:00	DIA	ETF	108.28	108.3	108.2	108.25	3100.0
2006-07-13 19:00:00	DIA	ETF	108.15	108.19	108.15	108.19	600.0
2006-07-13 07:00:00	GLD	ETF	64.91	65.02	64.91	65.02	2500.0
2006-07-13 08:00:00	GLD	ETF	65.0	65.11	64.65	64.99	157100.0
2006-07-13 09:00:00	GLD	ETF	64.98	65.15	64.74	64.76	1709900.0

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

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