PREVIEW / etf_1hour / 2010-10-27

all etf 1-hour files

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

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-27 04:00:00	SPY	ETF	118.67	118.67	117.99	118.01	21925.0
2010-10-27 05:00:00	SPY	ETF	118.03	118.38	117.9	118.38	12401.0
2010-10-27 06:00:00	SPY	ETF	118.24	118.39	118.2	118.37	89450.0
2010-10-27 07:00:00	SPY	ETF	118.3	118.34	118.05	118.12	428650.0
2010-10-27 08:00:00	SPY	ETF	118.13	118.31	117.83	117.97	3049538.0
2010-10-27 09:00:00	SPY	ETF	117.96	118.21	117.73	118.21	20155483.0
2010-10-27 10:00:00	SPY	ETF	118.21	118.36	117.47	117.48	41502230.0
2010-10-27 11:00:00	SPY	ETF	117.48	117.76	117.3	117.67	26188991.0
2010-10-27 12:00:00	SPY	ETF	117.67	117.72	117.42	117.5	13098424.0
2010-10-27 13:00:00	SPY	ETF	117.51	117.73	117.26	117.728	15362278.0
2010-10-27 14:00:00	SPY	ETF	117.72	118.1	117.63	117.95	22529286.0
2010-10-27 15:00:00	SPY	ETF	117.9489	118.51	117.83	118.38	34183360.0
2010-10-27 16:00:00	SPY	ETF	118.38	118.46	117.347	118.27	10472818.0
2010-10-27 17:00:00	SPY	ETF	118.28	118.32	118.23	118.25	149643.0
2010-10-27 18:00:00	SPY	ETF	118.27	118.38	118.24	118.32	95137.0
2010-10-27 19:00:00	SPY	ETF	118.32	118.47	118.31	118.43	62089.0
2010-10-27 04:00:00	QQQ	ETF	51.92	51.92	51.8	51.8	4700.0
2010-10-27 05:00:00	QQQ	ETF	51.82	51.91	51.82	51.88	3700.0
2010-10-27 06:00:00	QQQ	ETF	51.86	51.93	51.86	51.93	8100.0
2010-10-27 07:00:00	QQQ	ETF	51.91	51.94	51.8	51.8	39400.0
2010-10-27 08:00:00	QQQ	ETF	51.81	51.86	51.72	51.79	739866.0
2010-10-27 09:00:00	QQQ	ETF	51.78	52.1	51.66	52.06	9966700.0
2010-10-27 10:00:00	QQQ	ETF	52.07	52.16	51.77	51.78	11051517.0
2010-10-27 11:00:00	QQQ	ETF	51.7738	51.89	51.67	51.835	7584178.0
2010-10-27 12:00:00	QQQ	ETF	51.83	51.85	51.735	51.79	3283029.0
2010-10-27 13:00:00	QQQ	ETF	51.79	51.96	51.68	51.96	4371231.0
2010-10-27 14:00:00	QQQ	ETF	51.9501	52.09	51.9	52.01	4901218.0
2010-10-27 15:00:00	QQQ	ETF	52.01	52.23	51.94	52.19	12522697.0
2010-10-27 16:00:00	QQQ	ETF	52.19	52.22	52.05	52.12	1972007.0
2010-10-27 17:00:00	QQQ	ETF	52.12	52.14	52.1	52.11	180708.0
2010-10-27 18:00:00	QQQ	ETF	52.11	52.13	52.09	52.13	45254.0
2010-10-27 19:00:00	QQQ	ETF	52.14	52.22	52.14	52.16	52207.0
2010-10-27 04:00:00	IWM	ETF	70.35	70.35	70.27	70.27	3197.0
2010-10-27 05:00:00	IWM	ETF	70.31	70.43	70.31	70.43	500.0
2010-10-27 07:00:00	IWM	ETF	70.46	70.52	70.31	70.41	156292.0
2010-10-27 08:00:00	IWM	ETF	70.15	70.48	70.15	70.31	366846.0
2010-10-27 09:00:00	IWM	ETF	70.29	70.54	70.06	70.49	5863099.0
2010-10-27 10:00:00	IWM	ETF	70.49	70.62	69.85	69.88	9646982.0
2010-10-27 11:00:00	IWM	ETF	69.88	70.04	69.54	69.97	6669568.0
2010-10-27 12:00:00	IWM	ETF	69.97	70.055	69.78	69.8126	4711002.0
2010-10-27 13:00:00	IWM	ETF	69.82	69.93	69.62	69.93	4585081.0
2010-10-27 14:00:00	IWM	ETF	69.9201	70.22	69.86	70.05	4622323.0
2010-10-27 15:00:00	IWM	ETF	70.06	70.57	69.93	70.49	10684259.0
2010-10-27 16:00:00	IWM	ETF	70.49	70.718	70.1999	70.46	1901632.0
2010-10-27 17:00:00	IWM	ETF	70.44	70.48	70.44	70.48	11900.0
2010-10-27 18:00:00	IWM	ETF	70.48	70.51	70.48	70.48	3000.0
2010-10-27 19:00:00	IWM	ETF	70.48	70.52	70.48	70.52	4600.0
2010-10-27 06:00:00	DIA	ETF	111.48	111.52	111.48	111.52	502.0
2010-10-27 07:00:00	DIA	ETF	111.5	111.55	111.36	111.39	16600.0
2010-10-27 08:00:00	DIA	ETF	111.36	111.4	111.13	111.17	24105.0

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

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