PREVIEW / etf_1hour / 2010-11-17

all etf 1-hour files

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

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-17 04:00:00	SPY	ETF	118.22	118.5	118.22	118.4	17615.0
2010-11-17 05:00:00	SPY	ETF	118.37	118.6	118.37	118.58	21875.0
2010-11-17 06:00:00	SPY	ETF	118.53	118.6	118.2	118.2	136373.0
2010-11-17 07:00:00	SPY	ETF	118.2	118.46	118.02	118.33	738542.0
2010-11-17 08:00:00	SPY	ETF	118.33	118.55	118.12	118.23	4217166.0
2010-11-17 09:00:00	SPY	ETF	118.22	118.37	117.86	118.29	22796705.0
2010-11-17 10:00:00	SPY	ETF	118.3	118.71	118.29	118.38	28686706.0
2010-11-17 11:00:00	SPY	ETF	118.38	118.62	118.25	118.54	20800012.0
2010-11-17 12:00:00	SPY	ETF	118.53	118.62	118.36	118.4	8627745.0
2010-11-17 13:00:00	SPY	ETF	118.39	118.65	118.32	118.47	12625398.0
2010-11-17 14:00:00	SPY	ETF	118.48	118.55	118.32	118.4	16201498.0
2010-11-17 15:00:00	SPY	ETF	118.4	118.43	117.89	118.22	47266418.0
2010-11-17 16:00:00	SPY	ETF	118.21	118.495	118.17	118.22	8195639.0
2010-11-17 17:00:00	SPY	ETF	118.22	118.28	118.18	118.28	261485.0
2010-11-17 18:00:00	SPY	ETF	118.28	118.45	118.21	118.45	152090.0
2010-11-17 19:00:00	SPY	ETF	118.44	118.63	118.42	118.6	142939.0
2010-11-17 04:00:00	QQQ	ETF	51.54	51.54	51.54	51.54	100.0
2010-11-17 05:00:00	QQQ	ETF	51.62	51.67	51.62	51.67	4000.0
2010-11-17 06:00:00	QQQ	ETF	51.69	51.69	51.57	51.58	2160.0
2010-11-17 07:00:00	QQQ	ETF	51.52	51.66	51.46	51.61	118024.0
2010-11-17 08:00:00	QQQ	ETF	51.56	51.68	51.5	51.54	705146.0
2010-11-17 09:00:00	QQQ	ETF	51.55	51.64	51.38	51.59	9393491.0
2010-11-17 10:00:00	QQQ	ETF	51.59	51.85	51.59	51.7617	11664321.0
2010-11-17 11:00:00	QQQ	ETF	51.77	51.85	51.67	51.81	8851754.0
2010-11-17 12:00:00	QQQ	ETF	51.808	51.83	51.71	51.75	3081783.0
2010-11-17 13:00:00	QQQ	ETF	51.74	51.87	51.69	51.802	3193379.0
2010-11-17 14:00:00	QQQ	ETF	51.81	51.87	51.72	51.74	6708750.0
2010-11-17 15:00:00	QQQ	ETF	51.74	51.76	51.35	51.61	21072680.0
2010-11-17 16:00:00	QQQ	ETF	51.61	51.76	51.3899	51.55	4068835.0
2010-11-17 17:00:00	QQQ	ETF	51.54	51.63	51.53	51.61	52094.0
2010-11-17 18:00:00	QQQ	ETF	51.61	51.65	51.6	51.65	40200.0
2010-11-17 19:00:00	QQQ	ETF	51.66	51.75	51.63	51.72	85390.0
2010-11-17 05:00:00	IWM	ETF	70.92	70.99	70.92	70.99	1200.0
2010-11-17 06:00:00	IWM	ETF	70.88	70.88	70.88	70.88	2000.0
2010-11-17 07:00:00	IWM	ETF	70.72	70.97	70.64	70.85	123554.0
2010-11-17 08:00:00	IWM	ETF	70.67	71.01	70.67	70.8	314558.0
2010-11-17 09:00:00	IWM	ETF	70.79	70.91	70.4	70.79	7248891.0
2010-11-17 10:00:00	IWM	ETF	70.8	70.96	70.72	70.81	6008023.0
2010-11-17 11:00:00	IWM	ETF	70.81	71.01	70.66	70.99	3493544.0
2010-11-17 12:00:00	IWM	ETF	70.99	71.0	70.7699	70.87	2956491.0
2010-11-17 13:00:00	IWM	ETF	70.88	71.01	70.82	70.96	2282903.0
2010-11-17 14:00:00	IWM	ETF	70.97	71.02	70.88	70.93	1782353.0
2010-11-17 15:00:00	IWM	ETF	70.93	70.95	70.54	70.86	9927711.0
2010-11-17 16:00:00	IWM	ETF	70.86	70.9	70.6061	70.79	3759048.0
2010-11-17 17:00:00	IWM	ETF	70.79	70.82	70.75	70.82	35333.0
2010-11-17 18:00:00	IWM	ETF	70.82	70.96	70.01	70.85	12603.0
2010-11-17 19:00:00	IWM	ETF	70.92	70.96	70.86	70.94	1400.0
2010-11-17 04:00:00	DIA	ETF	111.31	111.31	111.31	111.31	200.0
2010-11-17 07:00:00	DIA	ETF	110.5	110.77	110.5	110.77	3100.0
2010-11-17 08:00:00	DIA	ETF	110.66	110.82	110.55	110.58	29700.0

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

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