PREVIEW / etf_1hour / 2009-12-29

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-29.parquet
  size:    144 KB
  rows:    4,485

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-12-29 05:00:00	SPY	ETF	112.89	112.89	112.89	112.89	650.0
2009-12-29 06:00:00	SPY	ETF	112.92	113.16	112.92	113.15	9100.0
2009-12-29 07:00:00	SPY	ETF	113.12	113.12	113.06	113.1	197070.0
2009-12-29 08:00:00	SPY	ETF	113.09	113.11	112.98	113.02	831915.0
2009-12-29 09:00:00	SPY	ETF	113.03	113.12	112.8101	112.88	9759325.0
2009-12-29 10:00:00	SPY	ETF	112.89	112.99	112.76	112.85	11218801.0
2009-12-29 11:00:00	SPY	ETF	112.85	112.87	112.62	112.7183	8849838.0
2009-12-29 12:00:00	SPY	ETF	112.71	112.775	112.58	112.665	8413701.0
2009-12-29 13:00:00	SPY	ETF	112.67	112.81	112.63	112.8	6479515.0
2009-12-29 14:00:00	SPY	ETF	112.79	112.8	112.67	112.7	8228765.0
2009-12-29 15:00:00	SPY	ETF	112.72	112.87	112.55	112.58	18679013.0
2009-12-29 16:00:00	SPY	ETF	112.61	112.99	112.46	112.57	4820934.0
2009-12-29 17:00:00	SPY	ETF	112.56	112.59	112.53	112.59	14800.0
2009-12-29 18:00:00	SPY	ETF	112.58	112.6	112.55	112.56	8704.0
2009-12-29 19:00:00	SPY	ETF	112.52	112.55	112.33	112.41	57591.0
2009-12-29 06:00:00	QQQ	ETF	46.22	46.27	46.22	46.27	10300.0
2009-12-29 07:00:00	QQQ	ETF	46.27	46.27	46.23	46.26	37399.0
2009-12-29 08:00:00	QQQ	ETF	46.25	46.25	46.22	46.23	70273.0
2009-12-29 09:00:00	QQQ	ETF	46.23	46.27	46.11	46.16	4763404.0
2009-12-29 10:00:00	QQQ	ETF	46.16	46.17	46.04	46.1199	4500394.0
2009-12-29 11:00:00	QQQ	ETF	46.1101	46.13	46.01	46.06	3516778.0
2009-12-29 12:00:00	QQQ	ETF	46.0599	46.11	45.99	46.0505	4656872.0
2009-12-29 13:00:00	QQQ	ETF	46.05	46.12	46.03	46.11	1913304.0
2009-12-29 14:00:00	QQQ	ETF	46.1	46.11	46.04	46.06	3158684.0
2009-12-29 15:00:00	QQQ	ETF	46.06	46.14	46.01	46.03	5800989.0
2009-12-29 16:00:00	QQQ	ETF	46.02	46.08	46.01	46.07	2670915.0
2009-12-29 17:00:00	QQQ	ETF	46.06	46.07	46.03	46.03	16036.0
2009-12-29 18:00:00	QQQ	ETF	46.06	46.06	46.04	46.04	4426.0
2009-12-29 19:00:00	QQQ	ETF	46.03	46.03	46.0	46.0	21892.0
2009-12-29 07:00:00	IWM	ETF	63.57	63.61	63.49	63.52	31036.0
2009-12-29 08:00:00	IWM	ETF	63.52	63.57	63.48	63.48	265740.0
2009-12-29 09:00:00	IWM	ETF	63.48	63.53	63.23	63.29	3196408.0
2009-12-29 10:00:00	IWM	ETF	63.28	63.45	63.2	63.325	3741386.0
2009-12-29 11:00:00	IWM	ETF	63.32	63.33	63.19	63.26	3543776.0
2009-12-29 12:00:00	IWM	ETF	63.25	63.33	63.2	63.24	2541345.0
2009-12-29 13:00:00	IWM	ETF	63.25	63.31	63.22	63.309	1542229.0
2009-12-29 14:00:00	IWM	ETF	63.3	63.31	63.23	63.25	1288422.0
2009-12-29 15:00:00	IWM	ETF	63.25	63.37	63.18	63.22	4528174.0
2009-12-29 16:00:00	IWM	ETF	63.23	63.3	63.18	63.18	1690899.0
2009-12-29 17:00:00	IWM	ETF	63.19	63.24	63.19	63.24	10400.0
2009-12-29 19:00:00	IWM	ETF	63.17	63.17	63.13	63.13	700.0
2009-12-29 06:00:00	DIA	ETF	105.51	105.51	105.51	105.51	200.0
2009-12-29 08:00:00	DIA	ETF	105.52	105.7	105.5	105.59	12817.0
2009-12-29 09:00:00	DIA	ETF	105.57	105.6	105.43	105.54	733210.0
2009-12-29 10:00:00	DIA	ETF	105.56	105.64	105.45	105.51	372769.0
2009-12-29 11:00:00	DIA	ETF	105.51	105.545	105.3	105.42	446292.0
2009-12-29 12:00:00	DIA	ETF	105.42	105.49	105.32	105.39	380417.0
2009-12-29 13:00:00	DIA	ETF	105.39	105.49	105.36	105.4725	194925.0
2009-12-29 14:00:00	DIA	ETF	105.48	105.5	105.41	105.42	282108.0
2009-12-29 15:00:00	DIA	ETF	105.425	105.565	105.25	105.26	758943.0

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

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