PREVIEW / etf_1hour / 2009-09-01

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-01.parquet
  size:    146 KB
  rows:    4,491

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-09-01 04:00:00	SPY	ETF	102.47	102.47	101.67	101.9	11400.0
2009-09-01 05:00:00	SPY	ETF	101.82	101.85	101.6	101.81	21615.0
2009-09-01 06:00:00	SPY	ETF	101.75	101.76	101.65	101.7	2950.0
2009-09-01 07:00:00	SPY	ETF	101.69	101.96	101.63	101.96	756687.0
2009-09-01 08:00:00	SPY	ETF	101.96	102.46	101.85	101.96	3911205.0
2009-09-01 09:00:00	SPY	ETF	101.97	102.97	101.83	102.83	29320923.0
2009-09-01 10:00:00	SPY	ETF	102.83	103.24	102.22	102.22	51107124.0
2009-09-01 11:00:00	SPY	ETF	102.22	102.24	100.49	100.7	69929369.0
2009-09-01 12:00:00	SPY	ETF	100.7	100.92	100.39	100.56	29908781.0
2009-09-01 13:00:00	SPY	ETF	100.56	100.7	100.23	100.67	30882072.0
2009-09-01 14:00:00	SPY	ETF	100.6799	100.75	100.33	100.48	28286635.0
2009-09-01 15:00:00	SPY	ETF	100.48	100.67	99.99	100.16	57002197.0
2009-09-01 16:00:00	SPY	ETF	100.17	102.99	100.0	100.13	16878290.0
2009-09-01 17:00:00	SPY	ETF	100.13	102.4436	100.04	100.09	2169479.0
2009-09-01 18:00:00	SPY	ETF	100.1	100.2	100.1	100.17	99417.0
2009-09-01 19:00:00	SPY	ETF	100.16	100.19	100.05	100.06	37637.0
2009-09-01 04:00:00	QQQ	ETF	40.06	40.06	39.74	39.82	3358.0
2009-09-01 05:00:00	QQQ	ETF	39.78	39.78	39.7	39.7	500.0
2009-09-01 06:00:00	QQQ	ETF	39.73	39.74	39.71	39.71	4325.0
2009-09-01 07:00:00	QQQ	ETF	39.72	39.88	39.69	39.84	445602.0
2009-09-01 08:00:00	QQQ	ETF	39.85	40.03	39.83	39.88	2371455.0
2009-09-01 09:00:00	QQQ	ETF	39.89	40.47	39.85	40.37	15587633.0
2009-09-01 10:00:00	QQQ	ETF	40.38	40.59	40.15	40.15	28853451.0
2009-09-01 11:00:00	QQQ	ETF	40.15	40.215	39.4	39.4	37042990.0
2009-09-01 12:00:00	QQQ	ETF	39.41	39.49	39.33	39.35	13624486.0
2009-09-01 13:00:00	QQQ	ETF	39.36	39.4	39.16	39.39	15580587.0
2009-09-01 14:00:00	QQQ	ETF	39.39	39.46	39.3201	39.37	11755761.0
2009-09-01 15:00:00	QQQ	ETF	39.38	39.46	39.23	39.27	27259379.0
2009-09-01 16:00:00	QQQ	ETF	39.28	40.38	39.2	39.29	7708928.0
2009-09-01 17:00:00	QQQ	ETF	39.29	39.31	39.27	39.28	97187.0
2009-09-01 18:00:00	QQQ	ETF	39.28	39.31	39.27	39.3	48237.0
2009-09-01 19:00:00	QQQ	ETF	39.31	39.31	39.27	39.27	18177.0
2009-09-01 05:00:00	IWM	ETF	56.9	56.9	56.9	56.9	200.0
2009-09-01 06:00:00	IWM	ETF	56.82	56.82	56.82	56.82	200.0
2009-09-01 07:00:00	IWM	ETF	56.77	56.93	56.77	56.93	7700.0
2009-09-01 08:00:00	IWM	ETF	56.95	57.2	56.82	56.88	307802.0
2009-09-01 09:00:00	IWM	ETF	56.87	57.99	56.8	57.91	9010071.0
2009-09-01 10:00:00	IWM	ETF	57.92	58.13	57.29	57.31	11924485.0
2009-09-01 11:00:00	IWM	ETF	57.31	57.31	55.9601	56.05	17266896.0
2009-09-01 12:00:00	IWM	ETF	56.05	56.2	55.818	56.07	8291790.0
2009-09-01 13:00:00	IWM	ETF	56.08	56.1774	55.84	56.1576	5957482.0
2009-09-01 14:00:00	IWM	ETF	56.15	56.22	55.9	56.0109	5424274.0
2009-09-01 15:00:00	IWM	ETF	56.02	56.1206	55.7	55.87	10793791.0
2009-09-01 16:00:00	IWM	ETF	55.88	57.6951	55.83	55.9	1633954.0
2009-09-01 17:00:00	IWM	ETF	55.86	55.87	55.78	55.82	16522.0
2009-09-01 18:00:00	IWM	ETF	55.83	55.86	55.78	55.78	2385.0
2009-09-01 19:00:00	IWM	ETF	55.78	55.85	55.72	55.75	3300.0
2009-09-01 06:00:00	DIA	ETF	94.42	94.42	94.42	94.42	100.0
2009-09-01 07:00:00	DIA	ETF	94.46	94.6	94.46	94.58	2300.0
2009-09-01 08:00:00	DIA	ETF	94.54	95.05	94.47	94.56	59465.0

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

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