PREVIEW / etf_1hour / 2010-10-20

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-20.parquet
  size:    168 KB
  rows:    5,110

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-10-20 04:00:00	SPY	ETF	117.11	117.32	117.0	117.32	19200.0
2010-10-20 05:00:00	SPY	ETF	117.31	117.34	117.22	117.26	1300.0
2010-10-20 06:00:00	SPY	ETF	117.31	117.46	117.31	117.4	44569.0
2010-10-20 07:00:00	SPY	ETF	117.35	117.45	117.23	117.26	750106.0
2010-10-20 08:00:00	SPY	ETF	117.26	117.47	116.94	116.99	3261602.0
2010-10-20 09:00:00	SPY	ETF	116.99	117.56	116.87	117.24	24515301.0
2010-10-20 10:00:00	SPY	ETF	117.23	117.9	116.95	117.745	35641049.0
2010-10-20 11:00:00	SPY	ETF	117.744	118.09	117.63	117.93	22656735.0
2010-10-20 12:00:00	SPY	ETF	117.93	118.38	117.91	118.22	17987417.0
2010-10-20 13:00:00	SPY	ETF	118.22	118.4	118.09	118.13	14913794.0
2010-10-20 14:00:00	SPY	ETF	118.12	118.44	117.95	118.1901	23910940.0
2010-10-20 15:00:00	SPY	ETF	118.191	118.34	117.79	117.87	41260583.0
2010-10-20 16:00:00	SPY	ETF	117.84	118.245	117.185	118.12	11381141.0
2010-10-20 17:00:00	SPY	ETF	118.11	118.11	118.0	118.11	215616.0
2010-10-20 18:00:00	SPY	ETF	118.12	118.17	117.87	118.15	200107.0
2010-10-20 19:00:00	SPY	ETF	118.13	118.21	118.12	118.21	76113.0
2010-10-20 04:00:00	QQQ	ETF	51.0	51.09	51.0	51.09	1259.0
2010-10-20 05:00:00	QQQ	ETF	51.09	51.09	51.04	51.04	300.0
2010-10-20 06:00:00	QQQ	ETF	51.1	51.1	51.07	51.07	100300.0
2010-10-20 07:00:00	QQQ	ETF	51.05	51.12	51.02	51.08	612642.0
2010-10-20 08:00:00	QQQ	ETF	51.07	51.1	50.92	50.93	1144280.0
2010-10-20 09:00:00	QQQ	ETF	50.92	51.19	50.92	51.06	9304469.0
2010-10-20 10:00:00	QQQ	ETF	51.07	51.31	50.87	51.26	15496652.0
2010-10-20 11:00:00	QQQ	ETF	51.2562	51.48	51.18	51.4	11246797.0
2010-10-20 12:00:00	QQQ	ETF	51.393	51.57	51.38	51.403	6433369.0
2010-10-20 13:00:00	QQQ	ETF	51.41	51.5	51.35	51.3699	6550364.0
2010-10-20 14:00:00	QQQ	ETF	51.365	51.48	51.26	51.39	7380384.0
2010-10-20 15:00:00	QQQ	ETF	51.4	51.43	51.16	51.19	13545585.0
2010-10-20 16:00:00	QQQ	ETF	51.18	51.34	51.16	51.34	2526196.0
2010-10-20 17:00:00	QQQ	ETF	51.33	51.36	51.31	51.36	221248.0
2010-10-20 18:00:00	QQQ	ETF	51.35	51.38	51.34	51.34	41122.0
2010-10-20 19:00:00	QQQ	ETF	51.33	51.38	51.33	51.36	17649.0
2010-10-20 04:00:00	IWM	ETF	69.7	69.97	69.7	69.97	1400.0
2010-10-20 05:00:00	IWM	ETF	69.98	69.98	69.98	69.98	200.0
2010-10-20 06:00:00	IWM	ETF	70.07	70.07	70.06	70.06	3000.0
2010-10-20 07:00:00	IWM	ETF	69.99	70.14	69.98	70.03	549520.0
2010-10-20 08:00:00	IWM	ETF	70.03	70.09	69.79	69.8	1638159.0
2010-10-20 09:00:00	IWM	ETF	69.8	70.18	69.78	69.84	5745723.0
2010-10-20 10:00:00	IWM	ETF	69.84	70.3	69.57	70.18	7864395.0
2010-10-20 11:00:00	IWM	ETF	70.18	70.52	70.04	70.41	7449561.0
2010-10-20 12:00:00	IWM	ETF	70.41	70.63	70.39	70.46	3331828.0
2010-10-20 13:00:00	IWM	ETF	70.47	70.62	70.41	70.42	4387869.0
2010-10-20 14:00:00	IWM	ETF	70.43	70.62	70.22	70.49	5835301.0
2010-10-20 15:00:00	IWM	ETF	70.49	70.571	70.12	70.2	9185819.0
2010-10-20 16:00:00	IWM	ETF	70.2	70.53	69.4276	70.37	4588816.0
2010-10-20 17:00:00	IWM	ETF	70.34	70.34	70.3	70.32	19893.0
2010-10-20 18:00:00	IWM	ETF	70.4	70.4	70.21	70.38	9613.0
2010-10-20 19:00:00	IWM	ETF	70.38	70.38	70.38	70.38	1500.0
2010-10-20 04:00:00	DIA	ETF	110.11	110.11	110.11	110.11	128.0
2010-10-20 07:00:00	DIA	ETF	110.28	110.34	110.24	110.24	1710.0

> showing 50 of 5,110 rows — these rows as CSV

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