PREVIEW / etf_1hour / 2009-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-06.parquet
  size:    137 KB
  rows:    4,216

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-07-06 04:00:00	SPY	ETF	88.88	89.07	88.88	88.92	3926.0
2009-07-06 05:00:00	SPY	ETF	88.92	89.03	88.88	88.88	3900.0
2009-07-06 06:00:00	SPY	ETF	88.89	88.91	88.71	88.76	50800.0
2009-07-06 07:00:00	SPY	ETF	88.79	89.06	88.78	89.03	504887.0
2009-07-06 08:00:00	SPY	ETF	89.03	90.0	88.95	89.07	2548519.0
2009-07-06 09:00:00	SPY	ETF	89.08	89.6752	88.86	89.45	24808723.0
2009-07-06 10:00:00	SPY	ETF	89.445	89.67	88.66	88.8899	39904371.0
2009-07-06 11:00:00	SPY	ETF	88.89	89.27	88.87	89.04	16067721.0
2009-07-06 12:00:00	SPY	ETF	89.0325	89.25	88.96	89.14	10636581.0
2009-07-06 13:00:00	SPY	ETF	89.14	89.6752	89.14	89.385	19235987.0
2009-07-06 14:00:00	SPY	ETF	89.39	89.56	89.3	89.44	11441043.0
2009-07-06 15:00:00	SPY	ETF	89.44	89.93	89.2	89.9	35392727.0
2009-07-06 16:00:00	SPY	ETF	89.9	90.08	89.78	89.99	8925970.0
2009-07-06 17:00:00	SPY	ETF	89.99	90.03	89.9	89.98	233369.0
2009-07-06 18:00:00	SPY	ETF	89.98	90.02	89.95	89.96	69962.0
2009-07-06 19:00:00	SPY	ETF	89.99	90.0	89.9	89.98	3891506.0
2009-07-06 04:00:00	QQQ	ETF	35.32	35.32	35.3	35.3	1300.0
2009-07-06 05:00:00	QQQ	ETF	35.3	35.3	35.3	35.3	300.0
2009-07-06 06:00:00	QQQ	ETF	35.28	35.28	35.24	35.25	2700.0
2009-07-06 07:00:00	QQQ	ETF	35.26	35.37	35.26	35.36	487915.0
2009-07-06 08:00:00	QQQ	ETF	35.36	35.46	35.15	35.43	986109.0
2009-07-06 09:00:00	QQQ	ETF	35.43	35.54	35.26	35.37	15455101.0
2009-07-06 10:00:00	QQQ	ETF	35.38	35.47	35.04	35.17	26662523.0
2009-07-06 11:00:00	QQQ	ETF	35.17	35.22	35.1	35.11	9256694.0
2009-07-06 12:00:00	QQQ	ETF	35.11	35.2	35.08	35.125	6358069.0
2009-07-06 13:00:00	QQQ	ETF	35.13	35.3	35.12	35.19	10292999.0
2009-07-06 14:00:00	QQQ	ETF	35.2	35.33	35.19	35.29	7269752.0
2009-07-06 15:00:00	QQQ	ETF	35.3	35.46	35.22	35.43	24236111.0
2009-07-06 16:00:00	QQQ	ETF	35.42	35.49	35.3346	35.46	3369839.0
2009-07-06 17:00:00	QQQ	ETF	35.47	35.48	35.44	35.44	21423.0
2009-07-06 18:00:00	QQQ	ETF	35.44	35.49	35.44	35.46	12590.0
2009-07-06 19:00:00	QQQ	ETF	35.47	35.47	35.43	35.46	21400.0
2009-07-06 07:00:00	IWM	ETF	49.48	49.6	49.48	49.51	36800.0
2009-07-06 08:00:00	IWM	ETF	49.6	50.04	49.35	49.65	321969.0
2009-07-06 09:00:00	IWM	ETF	49.65	49.74	49.32	49.4	4983117.0
2009-07-06 10:00:00	IWM	ETF	49.4	49.5699	48.65	48.76	9806366.0
2009-07-06 11:00:00	IWM	ETF	48.76	49.04	48.73	48.84	5250524.0
2009-07-06 12:00:00	IWM	ETF	48.84	48.97	48.83	48.9	2499545.0
2009-07-06 13:00:00	IWM	ETF	48.9	49.215	48.895	49.02	2780970.0
2009-07-06 14:00:00	IWM	ETF	49.02	49.16	48.95	49.05	2570672.0
2009-07-06 15:00:00	IWM	ETF	49.05	49.51	49.01	49.46	8625758.0
2009-07-06 16:00:00	IWM	ETF	49.45	49.63	49.41	49.52	6477344.0
2009-07-06 17:00:00	IWM	ETF	49.54	49.54	49.49	49.53	2245.0
2009-07-06 18:00:00	IWM	ETF	49.52	49.58	49.47	49.58	1200.0
2009-07-06 04:00:00	DIA	ETF	82.26	82.26	82.26	82.26	200.0
2009-07-06 05:00:00	DIA	ETF	82.28	82.28	82.28	82.28	100.0
2009-07-06 06:00:00	DIA	ETF	82.12	82.12	82.12	82.12	400.0
2009-07-06 07:00:00	DIA	ETF	82.12	82.31	82.11	82.24	15025.0
2009-07-06 08:00:00	DIA	ETF	82.28	82.49	82.25	82.36	46895.0
2009-07-06 09:00:00	DIA	ETF	82.39	82.77	82.11	82.68	1932743.0

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

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