PREVIEW / etf_1hour / 2007-02-14

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-14.parquet
  size:    67 KB
  rows:    2,062

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
2007-02-14 06:00:00	SPY	ETF	144.71	144.71	144.71	144.71	5000.0
2007-02-14 07:00:00	SPY	ETF	144.75	144.84	144.73	144.8	150340.0
2007-02-14 08:00:00	SPY	ETF	144.8	144.9	144.8	144.88	679224.0
2007-02-14 09:00:00	SPY	ETF	144.87	144.91	144.77	144.88	5842239.0
2007-02-14 10:00:00	SPY	ETF	144.89	145.76	144.84	145.48	22856992.0
2007-02-14 11:00:00	SPY	ETF	145.49	145.72	145.45	145.55	8630024.0
2007-02-14 12:00:00	SPY	ETF	145.55	145.59	145.41	145.55	3758616.0
2007-02-14 13:00:00	SPY	ETF	145.55	145.81	145.51	145.72	5207964.0
2007-02-14 14:00:00	SPY	ETF	145.73	145.87	145.71	145.82	5532535.0
2007-02-14 15:00:00	SPY	ETF	145.83	145.9	145.5	145.64	10628374.0
2007-02-14 16:00:00	SPY	ETF	145.64	145.72	145.56	145.56	1133010.0
2007-02-14 17:00:00	SPY	ETF	145.6	145.6	145.59	145.6	32500.0
2007-02-14 18:00:00	SPY	ETF	145.64	145.66	145.6	145.6	23000.0
2007-02-14 06:00:00	QQQ	ETF	44.0	44.0	44.0	44.0	100.0
2007-02-14 07:00:00	QQQ	ETF	44.03	44.04	44.01	44.02	161780.0
2007-02-14 08:00:00	QQQ	ETF	44.02	44.08	44.01	44.04	1075215.0
2007-02-14 09:00:00	QQQ	ETF	44.04	44.14	44.02	44.13	11480327.0
2007-02-14 10:00:00	QQQ	ETF	44.12	44.5	44.1	44.44	43949200.0
2007-02-14 11:00:00	QQQ	ETF	44.43	44.62	44.41	44.52	23263500.0
2007-02-14 12:00:00	QQQ	ETF	44.53	44.57	44.48	44.55	6784300.0
2007-02-14 13:00:00	QQQ	ETF	44.56	44.71	44.53	44.66	11442500.0
2007-02-14 14:00:00	QQQ	ETF	44.67	44.7	44.55	44.62	12149600.0
2007-02-14 15:00:00	QQQ	ETF	44.61	44.65	44.54	44.57	16480000.0
2007-02-14 16:00:00	QQQ	ETF	44.59	44.66	44.57	44.63	2922747.0
2007-02-14 17:00:00	QQQ	ETF	44.63	44.7	44.61	44.67	256050.0
2007-02-14 18:00:00	QQQ	ETF	44.68	44.69	44.65	44.65	53522.0
2007-02-14 19:00:00	QQQ	ETF	44.66	44.66	44.64	44.66	55899.0
2007-02-14 08:00:00	IWM	ETF	80.75	80.83	80.72	80.76	133800.0
2007-02-14 09:00:00	IWM	ETF	80.73	80.75	80.52	80.6	5220902.0
2007-02-14 10:00:00	IWM	ETF	80.6	81.29	80.57	81.08	16543835.0
2007-02-14 11:00:00	IWM	ETF	81.09	81.23	80.99	81.02	9598142.0
2007-02-14 12:00:00	IWM	ETF	81.01	81.08	80.93	81.065	4535434.0
2007-02-14 13:00:00	IWM	ETF	81.07	81.18	81.0	81.06	4199349.0
2007-02-14 14:00:00	IWM	ETF	81.06	81.09	80.83	80.98	5224695.0
2007-02-14 15:00:00	IWM	ETF	80.98	81.11	80.69	80.74	15258003.0
2007-02-14 16:00:00	IWM	ETF	80.74	80.84	80.71	80.75	1839300.0
2007-02-14 17:00:00	IWM	ETF	80.74	80.74	80.66	80.67	576809.0
2007-02-14 07:00:00	DIA	ETF	126.78	126.79	126.77	126.77	3758.0
2007-02-14 08:00:00	DIA	ETF	126.79	126.84	126.78	126.79	13900.0
2007-02-14 09:00:00	DIA	ETF	126.78	126.85	126.7	126.78	398071.0
2007-02-14 10:00:00	DIA	ETF	126.78	127.83	126.76	127.33	1988969.0
2007-02-14 11:00:00	DIA	ETF	127.32	127.51	127.29	127.39	1230379.0
2007-02-14 12:00:00	DIA	ETF	127.37	127.41	127.29	127.41	479119.0
2007-02-14 13:00:00	DIA	ETF	127.41	127.59	127.36	127.51	555582.0
2007-02-14 14:00:00	DIA	ETF	127.51	127.67	127.5	127.631	618013.0
2007-02-14 15:00:00	DIA	ETF	127.64	127.71	127.5	127.51	2004494.0
2007-02-14 16:00:00	DIA	ETF	127.53	127.55	127.47	127.51	48404.0
2007-02-14 17:00:00	DIA	ETF	127.51	127.52	127.51	127.52	8875.0
2007-02-14 18:00:00	DIA	ETF	127.57	127.57	127.57	127.57	400.0
2007-02-14 19:00:00	DIA	ETF	127.52	127.52	127.52	127.52	700.0

> showing 50 of 2,062 rows — these rows as CSV

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