PREVIEW / etf_1hour / 2010-03-08

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-08.parquet
  size:    152 KB
  rows:    4,822

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-03-08 04:00:00	SPY	ETF	114.18	114.18	114.15	114.15	200.0
2010-03-08 05:00:00	SPY	ETF	114.02	114.02	114.02	114.02	2200.0
2010-03-08 06:00:00	SPY	ETF	114.04	114.13	114.02	114.12	7825.0
2010-03-08 07:00:00	SPY	ETF	114.11	114.33	114.1	114.28	264031.0
2010-03-08 08:00:00	SPY	ETF	114.27	114.39	114.12	114.15	886660.0
2010-03-08 09:00:00	SPY	ETF	114.16	114.52	114.16	114.22	18424798.0
2010-03-08 10:00:00	SPY	ETF	114.22	114.47	114.18	114.39	22521362.0
2010-03-08 11:00:00	SPY	ETF	114.39	114.41	114.07	114.14	14406771.0
2010-03-08 12:00:00	SPY	ETF	114.14	114.33	114.1	114.33	12953250.0
2010-03-08 13:00:00	SPY	ETF	114.33	114.47	114.31	114.4101	10117883.0
2010-03-08 14:00:00	SPY	ETF	114.42	114.47	114.29	114.31	8344531.0
2010-03-08 15:00:00	SPY	ETF	114.31	114.39	114.22	114.27	18383370.0
2010-03-08 16:00:00	SPY	ETF	114.27	114.38	114.13	114.18	5196520.0
2010-03-08 17:00:00	SPY	ETF	114.19	114.19	114.09	114.1	55747.0
2010-03-08 18:00:00	SPY	ETF	114.09	114.13	114.06	114.07	52305.0
2010-03-08 19:00:00	SPY	ETF	114.06	114.06	113.99	114.04	53745.0
2010-03-08 04:00:00	QQQ	ETF	46.39	46.39	46.39	46.39	200.0
2010-03-08 07:00:00	QQQ	ETF	46.43	46.47	46.43	46.46	38306.0
2010-03-08 08:00:00	QQQ	ETF	46.35	46.55	46.35	46.44	351896.0
2010-03-08 09:00:00	QQQ	ETF	46.43	46.56	46.43	46.47	10179154.0
2010-03-08 10:00:00	QQQ	ETF	46.47	46.6	46.45	46.58	8450377.0
2010-03-08 11:00:00	QQQ	ETF	46.58	46.6	46.46	46.53	6070090.0
2010-03-08 12:00:00	QQQ	ETF	46.53	46.59	46.5	46.58	3656229.0
2010-03-08 13:00:00	QQQ	ETF	46.5801	46.64	46.58	46.63	4412431.0
2010-03-08 14:00:00	QQQ	ETF	46.63	46.64	46.54	46.56	8800692.0
2010-03-08 15:00:00	QQQ	ETF	46.55	46.62	46.52	46.53	8247827.0
2010-03-08 16:00:00	QQQ	ETF	46.53	46.596	46.45	46.5	7257604.0
2010-03-08 17:00:00	QQQ	ETF	46.5	46.52	46.46	46.49	21368.0
2010-03-08 18:00:00	QQQ	ETF	46.48	46.49	46.45	46.45	28300.0
2010-03-08 19:00:00	QQQ	ETF	46.44	46.46	46.44	46.46	37085.0
2010-03-08 06:00:00	IWM	ETF	66.52	66.52	66.52	66.52	100.0
2010-03-08 07:00:00	IWM	ETF	66.48	66.65	66.48	66.64	44710.0
2010-03-08 08:00:00	IWM	ETF	66.64	66.68	66.42	66.57	233012.0
2010-03-08 09:00:00	IWM	ETF	66.57	66.92	66.535	66.55	11369709.0
2010-03-08 10:00:00	IWM	ETF	66.55	66.87	66.515	66.81	10145448.0
2010-03-08 11:00:00	IWM	ETF	66.8	66.83	66.59	66.669	3635794.0
2010-03-08 12:00:00	IWM	ETF	66.66	66.77	66.61	66.72	3661001.0
2010-03-08 13:00:00	IWM	ETF	66.72	66.9	66.71	66.89	3419502.0
2010-03-08 14:00:00	IWM	ETF	66.88	66.93	66.7	66.829	3583642.0
2010-03-08 15:00:00	IWM	ETF	66.8201	66.87	66.68	66.73	7460022.0
2010-03-08 16:00:00	IWM	ETF	66.73	66.87	66.65	66.76	1164786.0
2010-03-08 17:00:00	IWM	ETF	66.76	66.87	66.67	66.68	515747.0
2010-03-08 18:00:00	IWM	ETF	66.7	66.81	66.67	66.67	7200.0
2010-03-08 19:00:00	IWM	ETF	66.67	66.69	66.63	66.69	2500.0
2010-03-08 08:00:00	DIA	ETF	105.85	105.85	105.65	105.65	36368.0
2010-03-08 09:00:00	DIA	ETF	105.69	105.96	105.64	105.65	765415.0
2010-03-08 10:00:00	DIA	ETF	105.67	105.85	105.6475	105.7885	1225801.0
2010-03-08 11:00:00	DIA	ETF	105.79	105.81	105.54	105.55	763206.0
2010-03-08 12:00:00	DIA	ETF	105.54	105.67	105.5	105.63	873884.0
2010-03-08 13:00:00	DIA	ETF	105.63	105.79	105.63	105.735	507478.0

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

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