PREVIEW / etf_1hour / 2008-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-23.parquet
  size:    109 KB
  rows:    3,497

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
2008-06-23 04:00:00	SPY	ETF	132.11	132.14	132.04	132.05	3000.0
2008-06-23 05:00:00	SPY	ETF	131.99	132.0	131.77	131.96	51600.0
2008-06-23 06:00:00	SPY	ETF	132.06	132.28	132.06	132.11	384600.0
2008-06-23 07:00:00	SPY	ETF	132.11	132.11	131.7	131.75	989555.0
2008-06-23 08:00:00	SPY	ETF	131.76	132.4	131.76	132.37	3570445.0
2008-06-23 09:00:00	SPY	ETF	132.37	132.47	131.63	131.78	21837969.0
2008-06-23 10:00:00	SPY	ETF	131.77	132.1	131.44	131.71	28772383.0
2008-06-23 11:00:00	SPY	ETF	131.7	131.8	131.32	131.68	22695752.0
2008-06-23 12:00:00	SPY	ETF	131.68	131.76	131.34	131.71	13272112.0
2008-06-23 13:00:00	SPY	ETF	131.7	132.09	131.53	131.93	17781076.0
2008-06-23 14:00:00	SPY	ETF	131.93	132.05	131.53	131.64	20036397.0
2008-06-23 15:00:00	SPY	ETF	131.63	131.7	131.36	131.63	23381660.0
2008-06-23 16:00:00	SPY	ETF	131.62	131.9937	131.14	131.33	7174023.0
2008-06-23 17:00:00	SPY	ETF	131.33	131.47	131.29	131.39	1387888.0
2008-06-23 18:00:00	SPY	ETF	131.37	131.37	131.32	131.33	20835.0
2008-06-23 19:00:00	SPY	ETF	131.3	131.36	131.3	131.36	5100.0
2008-06-23 06:00:00	QQQ	ETF	47.73	47.76	47.69	47.69	51700.0
2008-06-23 07:00:00	QQQ	ETF	47.68	47.68	47.48	47.51	893042.0
2008-06-23 08:00:00	QQQ	ETF	47.51	47.71	47.5	47.69	4874506.0
2008-06-23 09:00:00	QQQ	ETF	47.7	47.74	47.31	47.37	16973409.0
2008-06-23 10:00:00	QQQ	ETF	47.38	47.52	47.07	47.19	22562492.0
2008-06-23 11:00:00	QQQ	ETF	47.18	47.27	46.98	47.27	18393375.0
2008-06-23 12:00:00	QQQ	ETF	47.271	47.3	47.06	47.26	11611314.0
2008-06-23 13:00:00	QQQ	ETF	47.26	47.55	47.17	47.4199	15426306.0
2008-06-23 14:00:00	QQQ	ETF	47.41	47.54	47.27	47.3301	11549737.0
2008-06-23 15:00:00	QQQ	ETF	47.34	47.35	47.01	47.059	16000259.0
2008-06-23 16:00:00	QQQ	ETF	47.058	47.2679	46.79	46.93	5288160.0
2008-06-23 17:00:00	QQQ	ETF	46.91	46.95	46.91	46.94	259403.0
2008-06-23 18:00:00	QQQ	ETF	46.94	46.94	46.91	46.92	24000.0
2008-06-23 19:00:00	QQQ	ETF	46.91	46.95	46.91	46.92	27456.0
2008-06-23 04:00:00	IWM	ETF	72.9	72.9	72.9	72.9	100.0
2008-06-23 06:00:00	IWM	ETF	72.93	72.95	72.93	72.93	3000.0
2008-06-23 07:00:00	IWM	ETF	72.89	72.9	72.71	72.74	78934.0
2008-06-23 08:00:00	IWM	ETF	72.74	73.13	72.74	73.09	528556.0
2008-06-23 09:00:00	IWM	ETF	73.09	73.15	72.4	72.46	9591689.0
2008-06-23 10:00:00	IWM	ETF	72.46	72.83	72.1	72.35	13917736.0
2008-06-23 11:00:00	IWM	ETF	72.35	72.43	72.05	72.36	9243657.0
2008-06-23 12:00:00	IWM	ETF	72.36	72.39	72.01	72.33	7894976.0
2008-06-23 13:00:00	IWM	ETF	72.34	72.62	72.2	72.48	7282608.0
2008-06-23 14:00:00	IWM	ETF	72.48	72.58	72.11	72.21	6581238.0
2008-06-23 15:00:00	IWM	ETF	72.21	72.23	71.86	71.89	10606909.0
2008-06-23 16:00:00	IWM	ETF	71.88	72.29	71.51	71.71	1724296.0
2008-06-23 17:00:00	IWM	ETF	71.65	71.82	71.65	71.8	821938.0
2008-06-23 18:00:00	IWM	ETF	71.7	71.75	71.67	71.67	1963.0
2008-06-23 19:00:00	IWM	ETF	71.76	71.77	71.76	71.77	1000.0
2008-06-23 07:00:00	DIA	ETF	118.7	118.7	118.7	118.7	100.0
2008-06-23 08:00:00	DIA	ETF	118.61	119.0	118.61	118.96	98456.0
2008-06-23 09:00:00	DIA	ETF	118.99	119.05	118.25	118.41	2443250.0
2008-06-23 10:00:00	DIA	ETF	118.43	118.65	118.11	118.33	2562482.0
2008-06-23 11:00:00	DIA	ETF	118.31	118.41	118.04	118.33	1956099.0

> showing 50 of 3,497 rows — these rows as CSV

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