PREVIEW / etf_1hour / 2009-08-13

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-13.parquet
  size:    141 KB
  rows:    4,397

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-08-13 04:00:00	SPY	ETF	101.3	101.59	101.29	101.59	5900.0
2009-08-13 05:00:00	SPY	ETF	101.6	101.66	101.6	101.62	13150.0
2009-08-13 06:00:00	SPY	ETF	101.48	101.64	101.48	101.61	27500.0
2009-08-13 07:00:00	SPY	ETF	101.66	101.95	101.62	101.66	868583.0
2009-08-13 08:00:00	SPY	ETF	101.66	101.95	100.85	101.27	8221041.0
2009-08-13 09:00:00	SPY	ETF	101.28	101.43	100.26	100.4	29177294.0
2009-08-13 10:00:00	SPY	ETF	100.39	101.46	100.3	101.33	32142902.0
2009-08-13 11:00:00	SPY	ETF	101.32	101.43	100.9901	101.25	18570994.0
2009-08-13 12:00:00	SPY	ETF	101.24	101.3701	101.19	101.25	10434222.0
2009-08-13 13:00:00	SPY	ETF	101.25	101.61	101.0	101.0984	21573975.0
2009-08-13 14:00:00	SPY	ETF	101.09	101.31	100.7	100.942	15874809.0
2009-08-13 15:00:00	SPY	ETF	100.9499	101.58	100.9499	101.58	28001940.0
2009-08-13 16:00:00	SPY	ETF	101.6	101.83	100.3	101.72	11333815.0
2009-08-13 17:00:00	SPY	ETF	101.73	101.84	101.7	101.75	105655.0
2009-08-13 18:00:00	SPY	ETF	101.73	101.78	101.68	101.7	48770.0
2009-08-13 19:00:00	SPY	ETF	101.71	101.73	101.67	101.71	52029.0
2009-08-13 04:00:00	QQQ	ETF	40.04	40.15	40.04	40.15	700.0
2009-08-13 05:00:00	QQQ	ETF	40.14	40.22	40.14	40.22	12400.0
2009-08-13 06:00:00	QQQ	ETF	40.15	40.17	40.15	40.16	21501.0
2009-08-13 07:00:00	QQQ	ETF	40.16	40.32	40.16	40.25	533170.0
2009-08-13 08:00:00	QQQ	ETF	40.26	40.35	40.0	40.15	4970939.0
2009-08-13 09:00:00	QQQ	ETF	40.15	40.21	39.64	39.75	19125807.0
2009-08-13 10:00:00	QQQ	ETF	39.75	40.16	39.71	40.11	19443839.0
2009-08-13 11:00:00	QQQ	ETF	40.11	40.14	39.93	40.03	13674501.0
2009-08-13 12:00:00	QQQ	ETF	40.02	40.09	39.97	40.04	4555036.0
2009-08-13 13:00:00	QQQ	ETF	40.04	40.16	39.91	39.95	8956186.0
2009-08-13 14:00:00	QQQ	ETF	39.95	39.98	39.77	39.87	11225016.0
2009-08-13 15:00:00	QQQ	ETF	39.87	40.09	39.87	40.09	15102619.0
2009-08-13 16:00:00	QQQ	ETF	40.09	40.19	40.0384	40.19	7921212.0
2009-08-13 17:00:00	QQQ	ETF	40.19	40.22	40.15	40.17	148268.0
2009-08-13 18:00:00	QQQ	ETF	40.19	40.2	40.17	40.17	13416.0
2009-08-13 19:00:00	QQQ	ETF	40.15	40.17	40.14	40.14	14734.0
2009-08-13 07:00:00	IWM	ETF	57.81	57.98	57.8	57.84	52759.0
2009-08-13 08:00:00	IWM	ETF	57.82	57.96	57.44	57.63	2858210.0
2009-08-13 09:00:00	IWM	ETF	57.64	57.71	56.73	56.84	7602173.0
2009-08-13 10:00:00	IWM	ETF	56.84	57.52	56.77	57.42	6429925.0
2009-08-13 11:00:00	IWM	ETF	57.42	57.49	57.28	57.42	2512793.0
2009-08-13 12:00:00	IWM	ETF	57.42	57.66	57.39	57.55	3511357.0
2009-08-13 13:00:00	IWM	ETF	57.56	57.78	57.29	57.39	3812788.0
2009-08-13 14:00:00	IWM	ETF	57.38	57.48	57.15	57.25	3744918.0
2009-08-13 15:00:00	IWM	ETF	57.25	57.6	57.25	57.6	7806429.0
2009-08-13 16:00:00	IWM	ETF	57.6	57.71	56.8	57.7	3956418.0
2009-08-13 17:00:00	IWM	ETF	57.7	57.8	57.7	57.77	68086.0
2009-08-13 18:00:00	IWM	ETF	57.68	57.79	57.61	57.77	1718.0
2009-08-13 19:00:00	IWM	ETF	57.69	57.84	57.69	57.78	3856.0
2009-08-13 06:00:00	DIA	ETF	94.58	94.58	94.58	94.58	100.0
2009-08-13 07:00:00	DIA	ETF	94.62	94.77	94.56	94.56	5725.0
2009-08-13 08:00:00	DIA	ETF	94.56	94.75	93.99	94.14	100014.0
2009-08-13 09:00:00	DIA	ETF	94.22	94.31	93.17	93.31	2508820.0
2009-08-13 10:00:00	DIA	ETF	93.29	94.17	93.19	94.09	2222130.0

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

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