PREVIEW / etf_1hour / 2010-10-26

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-26.parquet
  size:    167 KB
  rows:    5,167

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-26 04:00:00	SPY	ETF	117.18	118.66	117.18	118.66	5100.0
2010-10-26 05:00:00	SPY	ETF	118.42	118.56	118.39	118.56	52530.0
2010-10-26 06:00:00	SPY	ETF	118.6	118.78	118.56	118.75	8975.0
2010-10-26 07:00:00	SPY	ETF	118.7	118.73	118.29	118.44	900205.0
2010-10-26 08:00:00	SPY	ETF	118.44	118.58	118.2	118.25	2187186.0
2010-10-26 09:00:00	SPY	ETF	118.25	118.3	117.87	118.15	21408728.0
2010-10-26 10:00:00	SPY	ETF	118.15	118.72	118.13	118.59	27187920.0
2010-10-26 11:00:00	SPY	ETF	118.59	118.76	118.3	118.67	19824278.0
2010-10-26 12:00:00	SPY	ETF	118.67	118.78	118.54	118.61	15631988.0
2010-10-26 13:00:00	SPY	ETF	118.619	118.79	118.38	118.42	11826273.0
2010-10-26 14:00:00	SPY	ETF	118.41	118.64	118.23	118.5238	20790786.0
2010-10-26 15:00:00	SPY	ETF	118.52	118.84	118.51	118.71	27020128.0
2010-10-26 16:00:00	SPY	ETF	118.7	118.9	118.275	118.81	9411651.0
2010-10-26 17:00:00	SPY	ETF	118.82	118.85	118.76	118.84	96960.0
2010-10-26 18:00:00	SPY	ETF	118.8	118.84	118.73	118.78	53613.0
2010-10-26 19:00:00	SPY	ETF	118.78	118.87	118.78	118.86	51989.0
2010-10-26 04:00:00	QQQ	ETF	51.76	51.76	51.76	51.76	2100.0
2010-10-26 05:00:00	QQQ	ETF	51.7	51.71	51.7	51.71	1400.0
2010-10-26 07:00:00	QQQ	ETF	51.85	51.85	51.68	51.72	22238.0
2010-10-26 08:00:00	QQQ	ETF	51.74	51.74	51.63	51.64	369412.0
2010-10-26 09:00:00	QQQ	ETF	51.64	51.65	51.42	51.55	8759981.0
2010-10-26 10:00:00	QQQ	ETF	51.55	51.95	51.54	51.92	12420333.0
2010-10-26 11:00:00	QQQ	ETF	51.91	52.04	51.82	52.02	7484658.0
2010-10-26 12:00:00	QQQ	ETF	52.02	52.11	51.98	52.03	3814595.0
2010-10-26 13:00:00	QQQ	ETF	52.04	52.15	51.945	51.96	5502504.0
2010-10-26 14:00:00	QQQ	ETF	51.96	52.07	51.89	52.02	6764053.0
2010-10-26 15:00:00	QQQ	ETF	52.01	52.13	51.965	52.0299	9317762.0
2010-10-26 16:00:00	QQQ	ETF	52.03	52.12	51.98	52.04	2348364.0
2010-10-26 17:00:00	QQQ	ETF	52.05	52.1	52.05	52.1	41661.0
2010-10-26 18:00:00	QQQ	ETF	52.1	52.1	52.05	52.07	94720.0
2010-10-26 19:00:00	QQQ	ETF	52.07	52.12	52.07	52.11	101400.0
2010-10-26 05:00:00	IWM	ETF	70.6	70.6	70.6	70.6	150.0
2010-10-26 06:00:00	IWM	ETF	70.54	70.83	70.29	70.83	2500.0
2010-10-26 07:00:00	IWM	ETF	70.81	70.81	70.55	70.61	16008.0
2010-10-26 08:00:00	IWM	ETF	70.7	70.7	70.4	70.44	527000.0
2010-10-26 09:00:00	IWM	ETF	70.43	70.43	69.99	70.22	5420247.0
2010-10-26 10:00:00	IWM	ETF	70.24	70.87	70.23	70.86	7045697.0
2010-10-26 11:00:00	IWM	ETF	70.86	71.0	70.61	71.0	3371442.0
2010-10-26 12:00:00	IWM	ETF	71.0	71.11	70.89	70.92	2441152.0
2010-10-26 13:00:00	IWM	ETF	70.93	71.17	70.74	70.79	2897920.0
2010-10-26 14:00:00	IWM	ETF	70.78	70.89	70.63	70.76	4295771.0
2010-10-26 15:00:00	IWM	ETF	70.77	70.97	70.62	70.69	7517280.0
2010-10-26 16:00:00	IWM	ETF	70.7	70.95	70.6467	70.82	1340373.0
2010-10-26 17:00:00	IWM	ETF	70.75	70.78	70.72	70.78	17100.0
2010-10-26 18:00:00	IWM	ETF	70.71	70.81	70.71	70.8	8376.0
2010-10-26 19:00:00	IWM	ETF	70.8	70.8	70.75	70.75	700.0
2010-10-26 08:00:00	DIA	ETF	111.49	111.5	111.28	111.35	193900.0
2010-10-26 09:00:00	DIA	ETF	111.26	111.3398	110.93	111.25	892045.0
2010-10-26 10:00:00	DIA	ETF	111.25	111.82	111.24	111.73	1077754.0
2010-10-26 11:00:00	DIA	ETF	111.73	111.81	111.47	111.7	864816.0

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

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