PREVIEW / etf_1hour / 2010-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-19.parquet
  size:    169 KB
  rows:    5,126

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-19 04:00:00	SPY	ETF	120.2	120.2	120.08	120.08	6900.0
2010-11-19 05:00:00	SPY	ETF	119.99	120.06	119.76	119.96	16079.0
2010-11-19 06:00:00	SPY	ETF	119.86	120.02	119.81	119.96	47051.0
2010-11-19 07:00:00	SPY	ETF	119.96	119.98	119.56	119.64	475456.0
2010-11-19 08:00:00	SPY	ETF	119.66	119.93	119.58	119.75	1990883.0
2010-11-19 09:00:00	SPY	ETF	119.74	119.92	119.25	119.48	24062905.0
2010-11-19 10:00:00	SPY	ETF	119.48	119.86	119.26	119.7	22713066.0
2010-11-19 11:00:00	SPY	ETF	119.699	119.98	119.63	119.82	16580741.0
2010-11-19 12:00:00	SPY	ETF	119.82	120.05	119.75	120.03	8833672.0
2010-11-19 13:00:00	SPY	ETF	120.029	120.13	119.95	120.05	10615872.0
2010-11-19 14:00:00	SPY	ETF	120.05	120.23	120.01	120.105	15340672.0
2010-11-19 15:00:00	SPY	ETF	120.1	120.34	119.96	120.28	28696157.0
2010-11-19 16:00:00	SPY	ETF	120.27	120.48	118.188	120.36	21975912.0
2010-11-19 17:00:00	SPY	ETF	120.31	120.35	120.3	120.31	32120.0
2010-11-19 18:00:00	SPY	ETF	120.35	120.35	120.26	120.32	21415.0
2010-11-19 19:00:00	SPY	ETF	120.32	120.35	120.25	120.25	29076.0
2010-11-19 04:00:00	QQQ	ETF	52.36	52.36	52.35	52.35	550.0
2010-11-19 06:00:00	QQQ	ETF	52.34	52.39	52.34	52.36	2300.0
2010-11-19 07:00:00	QQQ	ETF	52.35	52.35	52.21	52.24	132909.0
2010-11-19 08:00:00	QQQ	ETF	52.26	52.36	52.23	52.31	358995.0
2010-11-19 09:00:00	QQQ	ETF	52.31	52.4	52.15	52.24	9348855.0
2010-11-19 10:00:00	QQQ	ETF	52.2376	52.43	52.14	52.36	10576028.0
2010-11-19 11:00:00	QQQ	ETF	52.37	52.45	52.27	52.4	5163953.0
2010-11-19 12:00:00	QQQ	ETF	52.4	52.5	52.3375	52.4901	4370761.0
2010-11-19 13:00:00	QQQ	ETF	52.4999	52.54	52.48	52.52	3214052.0
2010-11-19 14:00:00	QQQ	ETF	52.53	52.59	52.5099	52.525	3547843.0
2010-11-19 15:00:00	QQQ	ETF	52.5225	52.56	52.38	52.49	10168623.0
2010-11-19 16:00:00	QQQ	ETF	52.46	52.565	52.44	52.48	4337801.0
2010-11-19 17:00:00	QQQ	ETF	52.49	52.5	52.46	52.49	870700.0
2010-11-19 18:00:00	QQQ	ETF	52.5	52.51	52.5	52.51	3100.0
2010-11-19 19:00:00	QQQ	ETF	52.51	52.52	52.48	52.48	5764.0
2010-11-19 07:00:00	IWM	ETF	72.06	72.08	71.85	71.9	86700.0
2010-11-19 08:00:00	IWM	ETF	71.91	72.11	71.89	72.02	261800.0
2010-11-19 09:00:00	IWM	ETF	72.02	72.12	71.53	71.79	4681093.0
2010-11-19 10:00:00	IWM	ETF	71.8	72.15	71.69	72.01	6313626.0
2010-11-19 11:00:00	IWM	ETF	72.01	72.34	71.98	72.23	3299298.0
2010-11-19 12:00:00	IWM	ETF	72.23	72.4	72.14	72.37	1921997.0
2010-11-19 13:00:00	IWM	ETF	72.38	72.49	72.34	72.48	2069378.0
2010-11-19 14:00:00	IWM	ETF	72.48	72.61	72.4499	72.45	2953543.0
2010-11-19 15:00:00	IWM	ETF	72.459	72.61	72.2119	72.45	7825275.0
2010-11-19 16:00:00	IWM	ETF	72.46	72.62	72.1612	72.51	2011297.0
2010-11-19 17:00:00	IWM	ETF	72.51	72.56	72.44	72.54	118485.0
2010-11-19 18:00:00	IWM	ETF	72.53	72.56	72.46	72.51	6600.0
2010-11-19 19:00:00	IWM	ETF	72.56	72.56	72.4	72.44	12099.0
2010-11-19 05:00:00	DIA	ETF	111.7	111.7	111.7	111.7	4000.0
2010-11-19 07:00:00	DIA	ETF	111.79	111.79	111.32	111.47	9400.0
2010-11-19 08:00:00	DIA	ETF	111.52	111.67	111.47	111.54	12600.0
2010-11-19 09:00:00	DIA	ETF	111.55	111.75	111.1801	111.42	869258.0
2010-11-19 10:00:00	DIA	ETF	111.42	111.7	111.24	111.59	867237.0
2010-11-19 11:00:00	DIA	ETF	111.59	111.77	111.52	111.64	463324.0

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

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