PREVIEW / etf_1hour / 2010-09-16

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-16.parquet
  size:    158 KB
  rows:    4,981

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
2010-09-16 04:00:00	SPY	ETF	112.86	112.91	112.74	112.83	2800.0
2010-09-16 05:00:00	SPY	ETF	112.86	112.86	112.81	112.86	1300.0
2010-09-16 06:00:00	SPY	ETF	112.99	113.0	112.85	112.85	136000.0
2010-09-16 07:00:00	SPY	ETF	112.83	112.89	112.74	112.81	777877.0
2010-09-16 08:00:00	SPY	ETF	112.8	113.16	112.49	112.62	4153484.0
2010-09-16 09:00:00	SPY	ETF	112.63	112.89	112.44	112.675	20592519.0
2010-09-16 10:00:00	SPY	ETF	112.67	112.91	112.35	112.7299	40025515.0
2010-09-16 11:00:00	SPY	ETF	112.73	112.83	112.51	112.58	23667207.0
2010-09-16 12:00:00	SPY	ETF	112.59	112.82	112.43	112.785	15083578.0
2010-09-16 13:00:00	SPY	ETF	112.785	112.8	112.52	112.62	12468128.0
2010-09-16 14:00:00	SPY	ETF	112.62	112.91	112.6	112.82	19212104.0
2010-09-16 15:00:00	SPY	ETF	112.82	113.12	112.79	113.07	43704229.0
2010-09-16 16:00:00	SPY	ETF	113.08	113.48	112.595	113.41	14956567.0
2010-09-16 17:00:00	SPY	ETF	113.41	113.43	113.3	113.35	331719.0
2010-09-16 18:00:00	SPY	ETF	113.36	113.5	113.1	113.5	125402.0
2010-09-16 19:00:00	SPY	ETF	113.49	113.57	113.49	113.56	63299.0
2010-09-16 04:00:00	QQQ	ETF	47.65	47.65	47.65	47.65	100.0
2010-09-16 06:00:00	QQQ	ETF	47.72	47.72	47.72	47.72	100.0
2010-09-16 07:00:00	QQQ	ETF	47.68	47.69	47.63	47.66	33704.0
2010-09-16 08:00:00	QQQ	ETF	47.66	47.72	47.56	47.63	398098.0
2010-09-16 09:00:00	QQQ	ETF	47.62	47.74	47.55	47.67	5006362.0
2010-09-16 10:00:00	QQQ	ETF	47.66	47.76	47.54	47.7	10557670.0
2010-09-16 11:00:00	QQQ	ETF	47.6999	47.75	47.59	47.61	7565877.0
2010-09-16 12:00:00	QQQ	ETF	47.6117	47.73	47.54	47.71	4693662.0
2010-09-16 13:00:00	QQQ	ETF	47.7074	47.71	47.58	47.63	7795871.0
2010-09-16 14:00:00	QQQ	ETF	47.63	47.82	47.62	47.7961	5621542.0
2010-09-16 15:00:00	QQQ	ETF	47.795	47.98	47.76	47.94	10787175.0
2010-09-16 16:00:00	QQQ	ETF	47.95	48.19	47.92	48.16	5483094.0
2010-09-16 17:00:00	QQQ	ETF	48.14	48.16	48.12	48.13	53224.0
2010-09-16 18:00:00	QQQ	ETF	48.13	48.17	48.12	48.17	18896.0
2010-09-16 19:00:00	QQQ	ETF	48.17	48.21	48.16	48.21	41570.0
2010-09-16 06:00:00	IWM	ETF	65.34	65.34	65.29	65.34	900.0
2010-09-16 07:00:00	IWM	ETF	65.32	65.36	65.23	65.29	114400.0
2010-09-16 08:00:00	IWM	ETF	65.11	65.36	65.09	65.18	602871.0
2010-09-16 09:00:00	IWM	ETF	65.17	65.41	65.02	65.21	4299870.0
2010-09-16 10:00:00	IWM	ETF	65.2	65.41	64.94	65.1	8068234.0
2010-09-16 11:00:00	IWM	ETF	65.09	65.1199	64.7	64.72	5028842.0
2010-09-16 12:00:00	IWM	ETF	64.72	64.89	64.55	64.8	5181575.0
2010-09-16 13:00:00	IWM	ETF	64.8	64.81	64.39	64.5	8502133.0
2010-09-16 14:00:00	IWM	ETF	64.5	64.85	64.49	64.74	4955604.0
2010-09-16 15:00:00	IWM	ETF	64.74	65.081	64.71	64.95	9656551.0
2010-09-16 16:00:00	IWM	ETF	64.94	65.3669	64.8498	65.2	2134251.0
2010-09-16 17:00:00	IWM	ETF	65.19	65.2	65.15	65.17	3884.0
2010-09-16 18:00:00	IWM	ETF	65.18	65.22	65.15	65.2	4299.0
2010-09-16 19:00:00	IWM	ETF	65.16	65.22	65.16	65.22	2447.0
2010-09-16 07:00:00	DIA	ETF	105.71	105.71	105.65	105.68	3100.0
2010-09-16 08:00:00	DIA	ETF	105.61	105.78	105.5	105.6	37151.0
2010-09-16 09:00:00	DIA	ETF	105.61	105.83	105.43	105.71	722518.0
2010-09-16 10:00:00	DIA	ETF	105.69	105.899	105.4	105.8	1014313.0
2010-09-16 11:00:00	DIA	ETF	105.81	105.9	105.6501	105.72	511476.0

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

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