PREVIEW / etf_1hour / 2009-12-04

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-04.parquet
  size:    151 KB
  rows:    4,631

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-04 04:00:00	SPY	ETF	110.44	110.5	110.44	110.5	1734.0
2009-12-04 05:00:00	SPY	ETF	110.45	110.45	110.45	110.45	100.0
2009-12-04 06:00:00	SPY	ETF	110.48	110.5	110.45	110.46	9350.0
2009-12-04 07:00:00	SPY	ETF	110.5	110.57	110.47	110.47	255365.0
2009-12-04 08:00:00	SPY	ETF	110.47	111.88	109.83	111.59	18718774.0
2009-12-04 09:00:00	SPY	ETF	111.59	112.38	111.41	112.17	34498411.0
2009-12-04 10:00:00	SPY	ETF	112.17	112.24	111.56	111.64	38047877.0
2009-12-04 11:00:00	SPY	ETF	111.65	111.71	110.04	110.55	63000010.0
2009-12-04 12:00:00	SPY	ETF	110.53	110.9904	110.48	110.89	21568351.0
2009-12-04 13:00:00	SPY	ETF	110.88	111.07	110.31	110.38	17050259.0
2009-12-04 14:00:00	SPY	ETF	110.38	110.85	110.06	110.67	30963308.0
2009-12-04 15:00:00	SPY	ETF	110.67	111.17	110.58	111.029	36567527.0
2009-12-04 16:00:00	SPY	ETF	111.0	112.31	110.2808	111.31	10581199.0
2009-12-04 17:00:00	SPY	ETF	111.26	111.31	110.4217	111.26	3064775.0
2009-12-04 18:00:00	SPY	ETF	111.24	111.27	111.21	111.23	11041.0
2009-12-04 19:00:00	SPY	ETF	111.27	111.29	111.24	111.26	21085.0
2009-12-04 07:00:00	QQQ	ETF	43.88	43.91	43.86	43.89	71900.0
2009-12-04 08:00:00	QQQ	ETF	43.9	44.48	43.85	44.38	3383086.0
2009-12-04 09:00:00	QQQ	ETF	44.39	44.73	44.34	44.66	15075836.0
2009-12-04 10:00:00	QQQ	ETF	44.67	44.69	44.52	44.55	16210400.0
2009-12-04 11:00:00	QQQ	ETF	44.55	44.55	43.66	43.9	31578605.0
2009-12-04 12:00:00	QQQ	ETF	43.9074	44.08	43.87	44.02	10169592.0
2009-12-04 13:00:00	QQQ	ETF	44.02	44.08	43.83	43.86	7114526.0
2009-12-04 14:00:00	QQQ	ETF	43.86	44.04	43.73	44.01	11947251.0
2009-12-04 15:00:00	QQQ	ETF	44.01	44.23	43.97	44.12	16485013.0
2009-12-04 16:00:00	QQQ	ETF	44.11	44.24	43.9115	44.2	6276152.0
2009-12-04 17:00:00	QQQ	ETF	43.9115	44.24	43.9115	44.15	4167245.0
2009-12-04 18:00:00	QQQ	ETF	44.2	44.2	44.15	44.19	10100.0
2009-12-04 19:00:00	QQQ	ETF	44.19	44.21	44.14	44.14	25900.0
2009-12-04 05:00:00	IWM	ETF	59.05	59.05	59.05	59.05	500.0
2009-12-04 07:00:00	IWM	ETF	59.13	59.26	59.12	59.2	12600.0
2009-12-04 08:00:00	IWM	ETF	59.21	60.32	59.13	60.08	2499628.0
2009-12-04 09:00:00	IWM	ETF	60.09	60.76	60.0	60.67	13375000.0
2009-12-04 10:00:00	IWM	ETF	60.665	60.87	60.41	60.64	15233803.0
2009-12-04 11:00:00	IWM	ETF	60.64	60.65	59.28	59.83	18721928.0
2009-12-04 12:00:00	IWM	ETF	59.82	60.32	59.78	60.24	8691730.0
2009-12-04 13:00:00	IWM	ETF	60.24	60.45	59.7	59.77	8072098.0
2009-12-04 14:00:00	IWM	ETF	59.76	60.06	59.65	60.03	8946709.0
2009-12-04 15:00:00	IWM	ETF	60.03	60.41	59.9	60.4	16516600.0
2009-12-04 16:00:00	IWM	ETF	60.4	60.56	60.2181	60.49	1432771.0
2009-12-04 17:00:00	IWM	ETF	60.51	60.51	60.46	60.5	31504.0
2009-12-04 18:00:00	IWM	ETF	60.5	60.55	60.47	60.55	2863.0
2009-12-04 19:00:00	IWM	ETF	60.54	60.55	60.5	60.5	1000.0
2009-12-04 08:00:00	DIA	ETF	103.86	105.06	103.82	104.82	221435.0
2009-12-04 09:00:00	DIA	ETF	104.83	105.27	104.7	105.14	2270257.0
2009-12-04 10:00:00	DIA	ETF	105.15	105.2	104.71	104.78	2774977.0
2009-12-04 11:00:00	DIA	ETF	104.77	104.78	103.2	103.63	5029995.0
2009-12-04 12:00:00	DIA	ETF	103.61	104.02	103.2	103.95	1299128.0
2009-12-04 13:00:00	DIA	ETF	103.96	104.11	103.44	103.5	1003697.0
2009-12-04 14:00:00	DIA	ETF	103.52	103.86	103.275	103.8	1467233.0

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

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