PREVIEW / etf_1hour / 2010-02-01

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-01.parquet
  size:    154 KB
  rows:    4,774

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-01 04:00:00	SPY	ETF	107.9	108.16	107.9	108.03	4400.0
2010-02-01 05:00:00	SPY	ETF	108.09	108.09	107.95	107.95	16671.0
2010-02-01 06:00:00	SPY	ETF	107.93	108.08	107.9	107.95	19589.0
2010-02-01 07:00:00	SPY	ETF	107.91	108.15	107.86	108.15	807380.0
2010-02-01 08:00:00	SPY	ETF	108.15	108.25	107.88	108.04	3832282.0
2010-02-01 09:00:00	SPY	ETF	108.05	108.5	107.37	108.33	23727640.0
2010-02-01 10:00:00	SPY	ETF	108.33	108.81	108.12	108.31	40222512.0
2010-02-01 11:00:00	SPY	ETF	108.375	108.87	108.24	108.45	23860984.0
2010-02-01 12:00:00	SPY	ETF	108.44	108.8	108.36	108.7	17483988.0
2010-02-01 13:00:00	SPY	ETF	108.7	108.93	108.59	108.75	13705988.0
2010-02-01 14:00:00	SPY	ETF	108.75	108.91	108.45	108.75	18509802.0
2010-02-01 15:00:00	SPY	ETF	108.75	109.07	108.57	109.0	30980514.0
2010-02-01 16:00:00	SPY	ETF	109.01	109.17	107.5008	109.08	12007361.0
2010-02-01 17:00:00	SPY	ETF	109.07	109.08	109.03	109.08	65684.0
2010-02-01 18:00:00	SPY	ETF	109.07	109.13	109.01	109.13	199663.0
2010-02-01 19:00:00	SPY	ETF	109.1	109.2	109.06	109.17	124837.0
2010-02-01 04:00:00	QQQ	ETF	43.02	43.07	43.02	43.07	550.0
2010-02-01 07:00:00	QQQ	ETF	42.91	43.0	42.91	42.99	171586.0
2010-02-01 08:00:00	QQQ	ETF	42.99	43.04	42.8	42.9	1153343.0
2010-02-01 09:00:00	QQQ	ETF	42.91	43.18	42.79	43.09	17876877.0
2010-02-01 10:00:00	QQQ	ETF	43.1	43.21	42.9	42.92	30320340.0
2010-02-01 11:00:00	QQQ	ETF	42.92	43.18	42.88	42.94	14772752.0
2010-02-01 12:00:00	QQQ	ETF	42.94	43.19	42.94	43.13	14890707.0
2010-02-01 13:00:00	QQQ	ETF	43.13	43.23	43.08	43.19	8752952.0
2010-02-01 14:00:00	QQQ	ETF	43.191	43.27	43.12	43.2	8796488.0
2010-02-01 15:00:00	QQQ	ETF	43.2	43.2807	43.11	43.25	19224442.0
2010-02-01 16:00:00	QQQ	ETF	43.25	43.29	42.8058	43.26	6518284.0
2010-02-01 17:00:00	QQQ	ETF	43.27	43.28	43.26	43.28	27770.0
2010-02-01 18:00:00	QQQ	ETF	43.26	43.27	43.25	43.25	14836.0
2010-02-01 19:00:00	QQQ	ETF	43.28	43.31	43.27	43.31	19066.0
2010-02-01 07:00:00	IWM	ETF	60.32	60.42	60.32	60.42	30963.0
2010-02-01 08:00:00	IWM	ETF	60.4	60.51	60.11	60.35	593532.0
2010-02-01 09:00:00	IWM	ETF	60.36	60.61	60.19	60.4	5733977.0
2010-02-01 10:00:00	IWM	ETF	60.4	60.64	60.16	60.24	10691781.0
2010-02-01 11:00:00	IWM	ETF	60.23	60.68	60.19	60.35	5915343.0
2010-02-01 12:00:00	IWM	ETF	60.34	60.83	60.33	60.79	6202303.0
2010-02-01 13:00:00	IWM	ETF	60.78	60.905	60.71	60.82	3908758.0
2010-02-01 14:00:00	IWM	ETF	60.82	60.94	60.715	60.7499	5002442.0
2010-02-01 15:00:00	IWM	ETF	60.75	60.84	60.66	60.82	12564749.0
2010-02-01 16:00:00	IWM	ETF	60.82	60.88	60.2007	60.79	4489685.0
2010-02-01 17:00:00	IWM	ETF	60.78	60.85	60.78	60.84	20315.0
2010-02-01 19:00:00	IWM	ETF	60.83	60.87	60.83	60.87	1497.0
2010-02-01 07:00:00	DIA	ETF	101.02	101.14	101.02	101.03	700.0
2010-02-01 08:00:00	DIA	ETF	101.15	101.23	101.07	101.09	48450.0
2010-02-01 09:00:00	DIA	ETF	101.08	101.49	101.07	101.32	1301898.0
2010-02-01 10:00:00	DIA	ETF	101.34	102.35	101.12	101.27	2131653.0
2010-02-01 11:00:00	DIA	ETF	101.27	101.72	101.23	101.36	950455.0
2010-02-01 12:00:00	DIA	ETF	101.36	101.69	101.3	101.61	777598.0
2010-02-01 13:00:00	DIA	ETF	101.62	101.835	101.53	101.66	1006335.0
2010-02-01 14:00:00	DIA	ETF	101.6699	101.799	101.47	101.63	1030022.0

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

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