PREVIEW / etf_1hour / 2010-02-26

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-26.parquet
  size:    151 KB
  rows:    4,713

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-02-26 04:00:00	SPY	ETF	110.97	110.97	110.97	110.97	100.0
2010-02-26 05:00:00	SPY	ETF	111.03	111.08	110.99	111.05	2700.0
2010-02-26 06:00:00	SPY	ETF	111.02	111.02	110.75	110.81	21200.0
2010-02-26 07:00:00	SPY	ETF	110.86	111.05	110.69	110.7	354996.0
2010-02-26 08:00:00	SPY	ETF	110.73	111.11	110.54	110.86	4131307.0
2010-02-26 09:00:00	SPY	ETF	110.86	110.87	110.36	110.5	28097359.0
2010-02-26 10:00:00	SPY	ETF	110.46	111.07	110.11	110.75	40152310.0
2010-02-26 11:00:00	SPY	ETF	110.76	111.0	110.69	110.76	18347126.0
2010-02-26 12:00:00	SPY	ETF	110.76	110.77	110.44	110.61	17502843.0
2010-02-26 13:00:00	SPY	ETF	110.6	110.97	110.52	110.9099	11947391.0
2010-02-26 14:00:00	SPY	ETF	110.91	111.0409	110.76	111.0	9923137.0
2010-02-26 15:00:00	SPY	ETF	111.0	111.12	110.74	110.75	30620451.0
2010-02-26 16:00:00	SPY	ETF	110.75	111.07	110.43	111.04	10420615.0
2010-02-26 17:00:00	SPY	ETF	111.04	111.16	111.0	111.14	418350.0
2010-02-26 18:00:00	SPY	ETF	111.12	111.14	111.08	111.12	68600.0
2010-02-26 19:00:00	SPY	ETF	111.1	111.2	111.09	111.14	95403.0
2010-02-26 04:00:00	QQQ	ETF	44.69	44.7	44.69	44.7	1600.0
2010-02-26 06:00:00	QQQ	ETF	44.67	44.67	44.67	44.67	200.0
2010-02-26 07:00:00	QQQ	ETF	44.66	44.69	44.6	44.6	23269.0
2010-02-26 08:00:00	QQQ	ETF	44.61	44.75	44.5	44.64	2662470.0
2010-02-26 09:00:00	QQQ	ETF	44.64	44.66	44.4	44.49	13915673.0
2010-02-26 10:00:00	QQQ	ETF	44.49	44.85	44.4	44.69	18268203.0
2010-02-26 11:00:00	QQQ	ETF	44.68	44.825	44.64	44.72	6173076.0
2010-02-26 12:00:00	QQQ	ETF	44.73	44.77	44.62	44.72	7496093.0
2010-02-26 13:00:00	QQQ	ETF	44.72	44.83	44.6899	44.8099	4077251.0
2010-02-26 14:00:00	QQQ	ETF	44.8	44.82	44.75	44.82	2849049.0
2010-02-26 15:00:00	QQQ	ETF	44.81	44.86	44.73	44.77	8271980.0
2010-02-26 16:00:00	QQQ	ETF	44.78	44.85	44.7204	44.8	1991670.0
2010-02-26 17:00:00	QQQ	ETF	44.81	44.83	44.78	44.82	29253.0
2010-02-26 18:00:00	QQQ	ETF	44.83	44.83	44.8	44.81	8880.0
2010-02-26 19:00:00	QQQ	ETF	44.83	44.85	44.82	44.85	3359.0
2010-02-26 05:00:00	IWM	ETF	63.22	63.22	63.22	63.22	200.0
2010-02-26 07:00:00	IWM	ETF	63.19	63.19	63.06	63.09	1600.0
2010-02-26 08:00:00	IWM	ETF	63.07	63.36	62.97	63.12	384414.0
2010-02-26 09:00:00	IWM	ETF	63.11	63.21	62.81	62.87	10504014.0
2010-02-26 10:00:00	IWM	ETF	62.9	63.1	62.46	62.88	8918453.0
2010-02-26 11:00:00	IWM	ETF	62.88	63.09	62.83	62.86	4600237.0
2010-02-26 12:00:00	IWM	ETF	62.8507	62.9	62.62	62.76	7435742.0
2010-02-26 13:00:00	IWM	ETF	62.76	63.06	62.75	62.98	2945705.0
2010-02-26 14:00:00	IWM	ETF	62.99	63.08	62.89	63.07	1833647.0
2010-02-26 15:00:00	IWM	ETF	63.07	63.16	62.81	62.81	10596407.0
2010-02-26 16:00:00	IWM	ETF	62.81	63.0939	62.64	63.0939	8209473.0
2010-02-26 17:00:00	IWM	ETF	63.03	63.0939	62.99	63.07	2528334.0
2010-02-26 18:00:00	IWM	ETF	63.04	63.04	63.0	63.0	3200.0
2010-02-26 19:00:00	IWM	ETF	63.01	63.04	63.0	63.03	1500.0
2010-02-26 06:00:00	DIA	ETF	103.48	103.5	103.48	103.5	200.0
2010-02-26 07:00:00	DIA	ETF	103.5	103.5	103.27	103.27	500.0
2010-02-26 08:00:00	DIA	ETF	103.39	103.42	103.19	103.4	8200.0
2010-02-26 09:00:00	DIA	ETF	103.37	103.43	103.02	103.1	984075.0
2010-02-26 10:00:00	DIA	ETF	103.1	103.61	102.78	103.36	2299710.0

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

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