PREVIEW / etf_1hour / 2010-11-10

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-10.parquet
  size:    174 KB
  rows:    5,327

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-11-10 04:00:00	SPY	ETF	121.67	121.72	121.59	121.71	3600.0
2010-11-10 05:00:00	SPY	ETF	121.75	121.76	121.49	121.49	20200.0
2010-11-10 06:00:00	SPY	ETF	121.52	121.63	121.47	121.62	25825.0
2010-11-10 07:00:00	SPY	ETF	121.66	121.71	121.39	121.4	318690.0
2010-11-10 08:00:00	SPY	ETF	121.73	121.8	121.29	121.66	2625748.0
2010-11-10 09:00:00	SPY	ETF	121.67	121.78	120.9	120.995	32402781.0
2010-11-10 10:00:00	SPY	ETF	121.0	121.19	120.66	121.085	40387418.0
2010-11-10 11:00:00	SPY	ETF	121.085	121.65	120.9	121.59	31678614.0
2010-11-10 12:00:00	SPY	ETF	121.585	121.69	121.34	121.475	14727935.0
2010-11-10 13:00:00	SPY	ETF	121.48	121.93	121.2	121.77	26939705.0
2010-11-10 14:00:00	SPY	ETF	121.77	122.16	121.76	121.99	31893981.0
2010-11-10 15:00:00	SPY	ETF	121.99	122.12	121.78	122.0701	30974976.0
2010-11-10 16:00:00	SPY	ETF	122.07	122.11	121.035	121.49	5756209.0
2010-11-10 17:00:00	SPY	ETF	121.49	121.51	121.02	121.15	1746608.0
2010-11-10 18:00:00	SPY	ETF	121.15	122.09	121.14	121.4	557273.0
2010-11-10 19:00:00	SPY	ETF	121.4	121.4	121.2	121.31	247784.0
2010-11-10 05:00:00	QQQ	ETF	53.55	53.55	53.5	53.5	15000.0
2010-11-10 06:00:00	QQQ	ETF	53.52	53.54	53.52	53.54	7600.0
2010-11-10 07:00:00	QQQ	ETF	53.56	53.56	53.45	53.45	25060.0
2010-11-10 08:00:00	QQQ	ETF	53.5	53.65	53.42	53.58	731707.0
2010-11-10 09:00:00	QQQ	ETF	53.57	53.61	53.15	53.25	11958569.0
2010-11-10 10:00:00	QQQ	ETF	53.25	53.28	53.1	53.27	10532809.0
2010-11-10 11:00:00	QQQ	ETF	53.27	53.6	53.24	53.5745	9077961.0
2010-11-10 12:00:00	QQQ	ETF	53.58	53.63	53.48	53.53	3927045.0
2010-11-10 13:00:00	QQQ	ETF	53.54	53.7001	53.41	53.62	8210819.0
2010-11-10 14:00:00	QQQ	ETF	53.611	53.77	53.611	53.725	7394231.0
2010-11-10 15:00:00	QQQ	ETF	53.729	53.75	53.625	53.71	7021419.0
2010-11-10 16:00:00	QQQ	ETF	53.71	53.7436	53.26	53.27	9013164.0
2010-11-10 17:00:00	QQQ	ETF	53.28	53.3	52.88	52.95	3351238.0
2010-11-10 18:00:00	QQQ	ETF	52.95	53.06	52.92	53.04	345639.0
2010-11-10 19:00:00	QQQ	ETF	53.05	53.05	52.97	53.03	92921.0
2010-11-10 07:00:00	IWM	ETF	72.79	72.79	72.64	72.67	20100.0
2010-11-10 08:00:00	IWM	ETF	72.57	72.98	72.57	72.84	241272.0
2010-11-10 09:00:00	IWM	ETF	72.86	72.93	72.25	72.41	6542360.0
2010-11-10 10:00:00	IWM	ETF	72.41	72.54	72.11	72.49	9106407.0
2010-11-10 11:00:00	IWM	ETF	72.49	73.04	72.38	72.98	6707745.0
2010-11-10 12:00:00	IWM	ETF	72.98	73.07	72.805	72.94	3230344.0
2010-11-10 13:00:00	IWM	ETF	72.93	73.22	72.73	73.15	6106699.0
2010-11-10 14:00:00	IWM	ETF	73.15	73.438	73.13	73.39	5588436.0
2010-11-10 15:00:00	IWM	ETF	73.39	73.55	73.25	73.54	7144279.0
2010-11-10 16:00:00	IWM	ETF	73.54	73.55	72.3	73.19	4874165.0
2010-11-10 17:00:00	IWM	ETF	73.2	73.2	72.78	72.81	212366.0
2010-11-10 18:00:00	IWM	ETF	72.81	73.54	72.81	72.9	33128.0
2010-11-10 19:00:00	IWM	ETF	72.9	72.95	72.9	72.95	2000.0
2010-11-10 08:00:00	DIA	ETF	113.54	113.79	113.53	113.72	29767.0
2010-11-10 09:00:00	DIA	ETF	113.74	113.77	112.97	113.06	1263698.0
2010-11-10 10:00:00	DIA	ETF	113.06	113.24	112.76	113.18	1621755.0
2010-11-10 11:00:00	DIA	ETF	113.18	113.58	112.98	113.5341	889019.0
2010-11-10 12:00:00	DIA	ETF	113.53	113.5899	113.29	113.36	596267.0
2010-11-10 13:00:00	DIA	ETF	113.36	113.73	113.161	113.58	1180150.0

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

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