PREVIEW / etf_1hour / 2010-11-05

all etf 1-hour files

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

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-05 04:00:00	SPY	ETF	122.24	122.34	122.02	122.02	2600.0
2010-11-05 05:00:00	SPY	ETF	122.09	122.13	122.01	122.03	7700.0
2010-11-05 06:00:00	SPY	ETF	122.02	122.03	121.74	121.76	92270.0
2010-11-05 07:00:00	SPY	ETF	121.75	122.05	121.75	121.99	909295.0
2010-11-05 08:00:00	SPY	ETF	121.99	122.7	121.91	122.39	7029532.0
2010-11-05 09:00:00	SPY	ETF	122.38	122.605	122.18	122.45	24732293.0
2010-11-05 10:00:00	SPY	ETF	122.45	122.92	122.33	122.8	27735210.0
2010-11-05 11:00:00	SPY	ETF	122.79	122.86	122.27	122.29	24738704.0
2010-11-05 12:00:00	SPY	ETF	122.29	122.55	122.21	122.49	19458859.0
2010-11-05 13:00:00	SPY	ETF	122.49	122.64	122.48	122.57	10768826.0
2010-11-05 14:00:00	SPY	ETF	122.57	122.58	122.2	122.34	17172293.0
2010-11-05 15:00:00	SPY	ETF	122.35	122.81	122.24	122.74	37045033.0
2010-11-05 16:00:00	SPY	ETF	122.74	122.85	122.4	122.84	10430635.0
2010-11-05 17:00:00	SPY	ETF	122.84	122.85	122.7	122.71	302931.0
2010-11-05 18:00:00	SPY	ETF	122.72	122.8	122.71	122.77	48311.0
2010-11-05 19:00:00	SPY	ETF	122.78	122.85	122.73	122.85	14543.0
2010-11-05 04:00:00	QQQ	ETF	53.71	53.71	53.59	53.6	5954.0
2010-11-05 05:00:00	QQQ	ETF	53.62	53.62	53.62	53.62	2000.0
2010-11-05 06:00:00	QQQ	ETF	53.6	53.6	53.53	53.55	9671.0
2010-11-05 07:00:00	QQQ	ETF	53.55	53.65	53.54	53.63	40368.0
2010-11-05 08:00:00	QQQ	ETF	53.63	53.86	53.53	53.67	2955142.0
2010-11-05 09:00:00	QQQ	ETF	53.67	53.77	53.56	53.66	15676670.0
2010-11-05 10:00:00	QQQ	ETF	53.66	53.81	53.61	53.72	9742780.0
2010-11-05 11:00:00	QQQ	ETF	53.72	53.74	53.54	53.545	6962561.0
2010-11-05 12:00:00	QQQ	ETF	53.54	53.68	53.52	53.655	5038790.0
2010-11-05 13:00:00	QQQ	ETF	53.66	53.73	53.6501	53.685	3110149.0
2010-11-05 14:00:00	QQQ	ETF	53.682	53.7	53.51	53.61	4206384.0
2010-11-05 15:00:00	QQQ	ETF	53.61	53.7	53.53	53.67	9457176.0
2010-11-05 16:00:00	QQQ	ETF	53.67	53.77	53.6388	53.7	2249859.0
2010-11-05 17:00:00	QQQ	ETF	53.7192	53.74	53.67	53.68	1026920.0
2010-11-05 18:00:00	QQQ	ETF	53.7	53.73	53.68	53.73	7945.0
2010-11-05 19:00:00	QQQ	ETF	53.73	53.73	53.71	53.73	12100.0
2010-11-05 04:00:00	IWM	ETF	73.39	73.39	73.39	73.39	400.0
2010-11-05 06:00:00	IWM	ETF	73.2	73.2	73.01	73.01	7000.0
2010-11-05 07:00:00	IWM	ETF	73.02	73.15	72.98	73.11	202115.0
2010-11-05 08:00:00	IWM	ETF	73.09	73.67	73.0	73.54	1554086.0
2010-11-05 09:00:00	IWM	ETF	73.37	73.7	73.301	73.61	7139946.0
2010-11-05 10:00:00	IWM	ETF	73.61	74.0	73.54	73.91	7250503.0
2010-11-05 11:00:00	IWM	ETF	73.91	73.96	73.47	73.47	6127184.0
2010-11-05 12:00:00	IWM	ETF	73.46	73.74	73.44	73.63	5014954.0
2010-11-05 13:00:00	IWM	ETF	73.63	73.745	73.6	73.67	1414992.0
2010-11-05 14:00:00	IWM	ETF	73.68	73.695	73.39	73.51	3035311.0
2010-11-05 15:00:00	IWM	ETF	73.51	73.75	73.45	73.75	8383520.0
2010-11-05 16:00:00	IWM	ETF	73.75	73.85	73.5408	73.8	1086717.0
2010-11-05 17:00:00	IWM	ETF	73.82	73.82	73.77	73.77	3060.0
2010-11-05 18:00:00	IWM	ETF	73.79	73.81	73.7	73.77	8658.0
2010-11-05 19:00:00	IWM	ETF	73.78	73.82	73.76	73.77	2300.0
2010-11-05 05:00:00	DIA	ETF	114.25	114.25	114.25	114.25	212.0
2010-11-05 07:00:00	DIA	ETF	114.1	114.25	114.1	114.2	13700.0
2010-11-05 08:00:00	DIA	ETF	114.16	114.77	114.16	114.57	96027.0

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

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