PREVIEW / etf_1hour / 2010-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-13.parquet
  size:    173 KB
  rows:    5,303

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-13 04:00:00	SPY	ETF	117.28	117.71	117.28	117.65	14359.0
2010-10-13 05:00:00	SPY	ETF	117.68	117.8	117.64	117.8	31700.0
2010-10-13 06:00:00	SPY	ETF	117.81	117.84	117.7	117.81	171640.0
2010-10-13 07:00:00	SPY	ETF	117.8	117.89	117.63	117.77	858600.0
2010-10-13 08:00:00	SPY	ETF	117.75	117.93	117.68	117.73	1498733.0
2010-10-13 09:00:00	SPY	ETF	117.74	117.83	117.38	117.74	26222021.0
2010-10-13 10:00:00	SPY	ETF	117.74	118.08	117.65	118.08	26350792.0
2010-10-13 11:00:00	SPY	ETF	118.08	118.29	117.97	118.1001	19161874.0
2010-10-13 12:00:00	SPY	ETF	118.11	118.44	118.1	118.31	12836951.0
2010-10-13 13:00:00	SPY	ETF	118.3	118.47	118.21	118.34	12965705.0
2010-10-13 14:00:00	SPY	ETF	118.35	118.55	118.19	118.23	21674753.0
2010-10-13 15:00:00	SPY	ETF	118.22	118.35	117.8	117.89	45769321.0
2010-10-13 16:00:00	SPY	ETF	117.89	118.4	117.515	117.86	21581535.0
2010-10-13 17:00:00	SPY	ETF	117.87	117.9	117.86	117.9	234690.0
2010-10-13 18:00:00	SPY	ETF	117.89	117.89	117.84	117.84	274824.0
2010-10-13 19:00:00	SPY	ETF	117.85	117.95	117.84	117.92	184173.0
2010-10-13 04:00:00	QQQ	ETF	50.23	50.41	50.23	50.38	10279.0
2010-10-13 05:00:00	QQQ	ETF	50.44	50.5	50.44	50.5	3070.0
2010-10-13 06:00:00	QQQ	ETF	50.48	50.48	50.45	50.47	35300.0
2010-10-13 07:00:00	QQQ	ETF	50.47	50.51	50.39	50.46	329101.0
2010-10-13 08:00:00	QQQ	ETF	50.48	50.51	50.42	50.43	743223.0
2010-10-13 09:00:00	QQQ	ETF	50.43	50.47	50.28	50.365	12396499.0
2010-10-13 10:00:00	QQQ	ETF	50.37	50.59	50.37	50.585	11754145.0
2010-10-13 11:00:00	QQQ	ETF	50.59	50.65	50.54	50.59	6121081.0
2010-10-13 12:00:00	QQQ	ETF	50.595	50.68	50.56	50.62	5194337.0
2010-10-13 13:00:00	QQQ	ETF	50.62	50.72	50.56	50.69	6545515.0
2010-10-13 14:00:00	QQQ	ETF	50.69	50.75	50.55	50.64	8124379.0
2010-10-13 15:00:00	QQQ	ETF	50.64	50.7	50.48	50.51	14493238.0
2010-10-13 16:00:00	QQQ	ETF	50.52	50.57	50.51	50.52	3321367.0
2010-10-13 17:00:00	QQQ	ETF	50.54	50.54	50.51	50.51	34596.0
2010-10-13 18:00:00	QQQ	ETF	50.51	50.52	50.5	50.51	13479.0
2010-10-13 19:00:00	QQQ	ETF	50.51	50.53	50.51	50.53	35372.0
2010-10-13 05:00:00	IWM	ETF	69.99	70.09	69.99	70.09	5750.0
2010-10-13 06:00:00	IWM	ETF	70.0	70.01	70.0	70.0	5700.0
2010-10-13 07:00:00	IWM	ETF	70.06	70.19	69.98	70.11	262587.0
2010-10-13 08:00:00	IWM	ETF	70.08	70.2	70.05	70.06	463572.0
2010-10-13 09:00:00	IWM	ETF	70.06	70.37	69.77	70.26	8304702.0
2010-10-13 10:00:00	IWM	ETF	70.26	70.52	70.16	70.46	6738973.0
2010-10-13 11:00:00	IWM	ETF	70.46	70.71	70.41	70.6183	4587558.0
2010-10-13 12:00:00	IWM	ETF	70.62	70.86	70.59	70.8	4223245.0
2010-10-13 13:00:00	IWM	ETF	70.81	71.04	70.76	70.94	3830142.0
2010-10-13 14:00:00	IWM	ETF	70.95	71.1436	70.92	71.0	5946015.0
2010-10-13 15:00:00	IWM	ETF	71.0	71.09	70.54	70.61	14812631.0
2010-10-13 16:00:00	IWM	ETF	70.61	70.79	69.6133	70.73	4265108.0
2010-10-13 17:00:00	IWM	ETF	70.72	70.75	70.7	70.75	19152.0
2010-10-13 18:00:00	IWM	ETF	70.66	70.72	70.66	70.72	38086.0
2010-10-13 19:00:00	IWM	ETF	70.72	70.77	70.72	70.77	8025.0
2010-10-13 05:00:00	DIA	ETF	111.0	111.0	111.0	111.0	100.0
2010-10-13 06:00:00	DIA	ETF	110.97	110.97	110.97	110.97	7000.0
2010-10-13 07:00:00	DIA	ETF	110.87	111.02	110.86	110.98	20680.0

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

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