PREVIEW / etf_1hour / 2009-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-17.parquet
  size:    135 KB
  rows:    4,162

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
2009-07-17 04:00:00	SPY	ETF	93.88	94.13	93.88	94.13	325.0
2009-07-17 05:00:00	SPY	ETF	94.05	94.05	93.86	93.93	7300.0
2009-07-17 06:00:00	SPY	ETF	93.98	94.12	93.91	93.97	30200.0
2009-07-17 07:00:00	SPY	ETF	93.97	94.04	93.36	93.51	533674.0
2009-07-17 08:00:00	SPY	ETF	93.52	93.854	93.28	93.82	3682656.0
2009-07-17 09:00:00	SPY	ETF	93.83	94.12	93.54	93.83	19165358.0
2009-07-17 10:00:00	SPY	ETF	93.8399	94.15	93.67	93.78	25796056.0
2009-07-17 11:00:00	SPY	ETF	93.78	93.89	93.64	93.7	11687616.0
2009-07-17 12:00:00	SPY	ETF	93.7	94.04	93.69	93.89	14380118.0
2009-07-17 13:00:00	SPY	ETF	93.9	94.32	93.84	94.1302	16125869.0
2009-07-17 14:00:00	SPY	ETF	94.14	94.17	93.97	94.05	12852577.0
2009-07-17 15:00:00	SPY	ETF	94.042	94.15	93.74	94.13	26119120.0
2009-07-17 16:00:00	SPY	ETF	94.13	94.25	93.7	94.2	6649112.0
2009-07-17 17:00:00	SPY	ETF	94.2	94.24	94.17	94.21	113638.0
2009-07-17 18:00:00	SPY	ETF	94.18	94.18	94.12	94.12	40657.0
2009-07-17 19:00:00	SPY	ETF	94.13	94.17	94.1	94.17	39106.0
2009-07-17 04:00:00	QQQ	ETF	37.26	37.26	37.26	37.26	214.0
2009-07-17 05:00:00	QQQ	ETF	37.28	37.28	37.28	37.28	100.0
2009-07-17 06:00:00	QQQ	ETF	37.32	37.32	37.29	37.32	815.0
2009-07-17 07:00:00	QQQ	ETF	37.3	37.3	37.08	37.14	275289.0
2009-07-17 08:00:00	QQQ	ETF	37.15	37.27	37.09	37.27	1377423.0
2009-07-17 09:00:00	QQQ	ETF	37.27	37.43	37.17	37.2601	16927391.0
2009-07-17 10:00:00	QQQ	ETF	37.27	37.45	37.17	37.31	20303544.0
2009-07-17 11:00:00	QQQ	ETF	37.31	37.3802	37.25	37.35	11323381.0
2009-07-17 12:00:00	QQQ	ETF	37.34	37.44	37.3399	37.41	8345238.0
2009-07-17 13:00:00	QQQ	ETF	37.41	37.57	37.398	37.5	11975174.0
2009-07-17 14:00:00	QQQ	ETF	37.51	37.56	37.4799	37.53	8008579.0
2009-07-17 15:00:00	QQQ	ETF	37.53	37.56	37.4	37.55	16481551.0
2009-07-17 16:00:00	QQQ	ETF	37.55	37.65	37.4797	37.59	3519814.0
2009-07-17 17:00:00	QQQ	ETF	37.61	37.67	37.58	37.67	66481.0
2009-07-17 18:00:00	QQQ	ETF	37.62	37.62	37.55	37.55	23660.0
2009-07-17 19:00:00	QQQ	ETF	37.55	37.6	37.55	37.56	15966.0
2009-07-17 06:00:00	IWM	ETF	52.0	52.0	51.99	51.99	4000.0
2009-07-17 07:00:00	IWM	ETF	51.97	51.97	51.68	51.76	19309.0
2009-07-17 08:00:00	IWM	ETF	51.74	52.07	51.69	52.07	353271.0
2009-07-17 09:00:00	IWM	ETF	52.08	52.27	51.73	51.955	4796693.0
2009-07-17 10:00:00	IWM	ETF	51.93	52.16	51.8	51.93	5600944.0
2009-07-17 11:00:00	IWM	ETF	51.93	51.96	51.75	51.785	2527742.0
2009-07-17 12:00:00	IWM	ETF	51.77	52.02	51.77	51.88	3939615.0
2009-07-17 13:00:00	IWM	ETF	51.88	52.11	51.84	52.01	1996946.0
2009-07-17 14:00:00	IWM	ETF	52.02	52.06	51.94	52.012	2574084.0
2009-07-17 15:00:00	IWM	ETF	52.02	52.03	51.765	51.88	7707230.0
2009-07-17 16:00:00	IWM	ETF	51.88	52.2008	51.85	52.05	3956224.0
2009-07-17 17:00:00	IWM	ETF	52.03	52.04	52.0	52.04	26563.0
2009-07-17 18:00:00	IWM	ETF	51.91	51.94	51.87	51.94	2500.0
2009-07-17 19:00:00	IWM	ETF	51.94	51.94	51.94	51.94	100.0
2009-07-17 07:00:00	DIA	ETF	87.14	87.14	86.68	86.68	4400.0
2009-07-17 08:00:00	DIA	ETF	86.9	87.0	86.6	87.0	73117.0
2009-07-17 09:00:00	DIA	ETF	87.1	87.29	86.72	86.99	1307964.0
2009-07-17 10:00:00	DIA	ETF	87.0	87.3	86.83	87.01	1784687.0

> showing 50 of 4,162 rows — these rows as CSV

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