PREVIEW / etf_1hour / 2010-10-29

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-29.parquet
  size:    163 KB
  rows:    5,086

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-29 05:00:00	SPY	ETF	117.81	117.83	117.72	117.76	6598.0
2010-10-29 06:00:00	SPY	ETF	117.83	117.96	117.83	117.95	3600.0
2010-10-29 07:00:00	SPY	ETF	117.96	117.97	117.75	117.93	292226.0
2010-10-29 08:00:00	SPY	ETF	117.96	118.39	117.75	118.28	1948826.0
2010-10-29 09:00:00	SPY	ETF	118.3	118.56	118.12	118.19	19922509.0
2010-10-29 10:00:00	SPY	ETF	118.19	118.72	118.11	118.49	23611199.0
2010-10-29 11:00:00	SPY	ETF	118.49	118.6	118.07	118.29	23229080.0
2010-10-29 12:00:00	SPY	ETF	118.3	118.57	118.29	118.5138	14908225.0
2010-10-29 13:00:00	SPY	ETF	118.51	118.66	118.37	118.64	10818875.0
2010-10-29 14:00:00	SPY	ETF	118.63	118.7	118.35	118.386	10722560.0
2010-10-29 15:00:00	SPY	ETF	118.38	118.7	118.33	118.47	27031973.0
2010-10-29 16:00:00	SPY	ETF	118.49	118.635	118.215	118.44	10807571.0
2010-10-29 17:00:00	SPY	ETF	118.41	118.44	118.33	118.39	217356.0
2010-10-29 18:00:00	SPY	ETF	118.33	118.53	118.29	118.31	84568.0
2010-10-29 19:00:00	SPY	ETF	118.31	118.35	118.27	118.34	45685.0
2010-10-29 05:00:00	QQQ	ETF	52.08	52.08	52.05	52.07	1650.0
2010-10-29 06:00:00	QQQ	ETF	52.07	52.11	52.07	52.11	7800.0
2010-10-29 07:00:00	QQQ	ETF	52.12	52.14	52.08	52.13	109096.0
2010-10-29 08:00:00	QQQ	ETF	52.14	52.3	52.07	52.26	527283.0
2010-10-29 09:00:00	QQQ	ETF	52.26	52.46	52.21	52.31	9844619.0
2010-10-29 10:00:00	QQQ	ETF	52.31	52.49	52.19	52.3	8186379.0
2010-10-29 11:00:00	QQQ	ETF	52.3	52.36	52.1698	52.26	6520428.0
2010-10-29 12:00:00	QQQ	ETF	52.25	52.43	52.25	52.36	3147651.0
2010-10-29 13:00:00	QQQ	ETF	52.3601	52.41	52.26	52.3991	3310012.0
2010-10-29 14:00:00	QQQ	ETF	52.39	52.4	52.23	52.24	3753464.0
2010-10-29 15:00:00	QQQ	ETF	52.24	52.34	52.17	52.18	7923020.0
2010-10-29 16:00:00	QQQ	ETF	52.18	52.22	52.06	52.22	1274997.0
2010-10-29 17:00:00	QQQ	ETF	52.18	52.19	52.16	52.16	25943.0
2010-10-29 18:00:00	QQQ	ETF	52.17	52.17	52.14	52.15	20049.0
2010-10-29 19:00:00	QQQ	ETF	52.15	52.15	52.11	52.14	15879.0
2010-10-29 05:00:00	IWM	ETF	69.44	69.44	69.4	69.41	1400.0
2010-10-29 07:00:00	IWM	ETF	69.54	69.54	69.42	69.54	27700.0
2010-10-29 08:00:00	IWM	ETF	69.29	69.89	69.29	69.81	290916.0
2010-10-29 09:00:00	IWM	ETF	69.815	70.24	69.69	70.02	6010887.0
2010-10-29 10:00:00	IWM	ETF	70.02	70.58	69.96	70.41	9241059.0
2010-10-29 11:00:00	IWM	ETF	70.42	70.5	70.12	70.28	5170622.0
2010-10-29 12:00:00	IWM	ETF	70.28	70.51	70.28	70.43	2864940.0
2010-10-29 13:00:00	IWM	ETF	70.44	70.67	70.31	70.63	3245793.0
2010-10-29 14:00:00	IWM	ETF	70.62	70.66	70.35	70.38	2811541.0
2010-10-29 15:00:00	IWM	ETF	70.37	70.59	70.28	70.29	7842699.0
2010-10-29 16:00:00	IWM	ETF	70.3	70.4714	70.21	70.38	1744458.0
2010-10-29 17:00:00	IWM	ETF	70.41	70.41	70.38	70.38	500.0
2010-10-29 18:00:00	IWM	ETF	70.36	70.36	70.33	70.33	10309.0
2010-10-29 19:00:00	IWM	ETF	70.3	70.31	70.3	70.31	200.0
2010-10-29 08:00:00	DIA	ETF	110.73	111.11	110.71	111.05	52997.0
2010-10-29 09:00:00	DIA	ETF	111.05	111.29	110.86	110.9	665787.0
2010-10-29 10:00:00	DIA	ETF	110.9	111.38	110.83	111.18	1133483.0
2010-10-29 11:00:00	DIA	ETF	111.19	111.26	110.81	110.99	969626.0
2010-10-29 12:00:00	DIA	ETF	110.98	111.26	110.98	111.23	433197.0
2010-10-29 13:00:00	DIA	ETF	111.2301	111.31	111.09	111.3	290358.0

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

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