PREVIEW / etf_1hour / 2010-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-27.parquet
  size:    163 KB
  rows:    5,015

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-12-27 04:00:00	SPY	ETF	125.35	125.35	125.07	125.09	3364.0
2010-12-27 05:00:00	SPY	ETF	125.09	125.12	125.09	125.12	500.0
2010-12-27 06:00:00	SPY	ETF	125.2	125.33	125.2	125.33	400.0
2010-12-27 07:00:00	SPY	ETF	125.21	125.23	125.0	125.05	93640.0
2010-12-27 08:00:00	SPY	ETF	125.05	125.19	125.03	125.14	520431.0
2010-12-27 09:00:00	SPY	ETF	125.15	125.24	125.04	125.185	10726248.0
2010-12-27 10:00:00	SPY	ETF	125.18	125.45	125.15	125.36	10247738.0
2010-12-27 11:00:00	SPY	ETF	125.37	125.41	125.33	125.39	5594783.0
2010-12-27 12:00:00	SPY	ETF	125.39	125.51	125.38	125.47	3621671.0
2010-12-27 13:00:00	SPY	ETF	125.48	125.72	125.46	125.72	8242042.0
2010-12-27 14:00:00	SPY	ETF	125.72	125.74	125.62	125.67	6969941.0
2010-12-27 15:00:00	SPY	ETF	125.675	125.77	125.65	125.66	8953615.0
2010-12-27 16:00:00	SPY	ETF	125.67	125.75	125.115	125.7	3099248.0
2010-12-27 17:00:00	SPY	ETF	125.7	125.71	125.68	125.71	15000.0
2010-12-27 18:00:00	SPY	ETF	125.72	125.72	125.68	125.7	20372.0
2010-12-27 19:00:00	SPY	ETF	125.72	125.8	125.71	125.77	43297.0
2010-12-27 04:00:00	QQQ	ETF	54.57	54.6	54.57	54.6	350.0
2010-12-27 07:00:00	QQQ	ETF	54.68	54.68	54.57	54.59	23810.0
2010-12-27 08:00:00	QQQ	ETF	54.58	54.63	54.58	54.61	161119.0
2010-12-27 09:00:00	QQQ	ETF	54.62	54.65	54.21	54.24	5508392.0
2010-12-27 10:00:00	QQQ	ETF	54.235	54.43	54.23	54.35	5257710.0
2010-12-27 11:00:00	QQQ	ETF	54.355	54.42	54.35	54.419	1499685.0
2010-12-27 12:00:00	QQQ	ETF	54.417	54.53	54.41	54.52	1543370.0
2010-12-27 13:00:00	QQQ	ETF	54.5199	54.86	54.51	54.82	4184161.0
2010-12-27 14:00:00	QQQ	ETF	54.82	54.83	54.78	54.8	1794117.0
2010-12-27 15:00:00	QQQ	ETF	54.8	54.83	54.75	54.75	3942444.0
2010-12-27 16:00:00	QQQ	ETF	54.755	54.8211	54.2293	54.76	3054187.0
2010-12-27 17:00:00	QQQ	ETF	54.75	54.76	54.73	54.76	41118.0
2010-12-27 18:00:00	QQQ	ETF	54.76	54.84	54.75	54.82	29877.0
2010-12-27 19:00:00	QQQ	ETF	54.81	54.84	54.81	54.83	16811.0
2010-12-27 06:00:00	IWM	ETF	78.5	78.5	78.5	78.5	400.0
2010-12-27 07:00:00	IWM	ETF	78.52	78.52	78.43	78.43	8100.0
2010-12-27 08:00:00	IWM	ETF	78.38	78.51	78.38	78.5	86198.0
2010-12-27 09:00:00	IWM	ETF	78.5	78.53	78.31	78.415	2002737.0
2010-12-27 10:00:00	IWM	ETF	78.41	78.68	78.3719	78.521	2629958.0
2010-12-27 11:00:00	IWM	ETF	78.53	78.71	78.51	78.71	2305521.0
2010-12-27 12:00:00	IWM	ETF	78.7092	78.87	78.705	78.81	1695957.0
2010-12-27 13:00:00	IWM	ETF	78.81	79.09	78.81	79.09	1526198.0
2010-12-27 14:00:00	IWM	ETF	79.084	79.09	78.97	78.98	1007054.0
2010-12-27 15:00:00	IWM	ETF	78.97	79.1	78.93	78.96	3156825.0
2010-12-27 16:00:00	IWM	ETF	78.97	79.0	78.93	78.97	610994.0
2010-12-27 17:00:00	IWM	ETF	78.96	79.0	78.91	78.96	900.0
2010-12-27 18:00:00	IWM	ETF	79.01	79.01	79.01	79.01	6300.0
2010-12-27 19:00:00	IWM	ETF	79.03	79.03	79.03	79.03	300.0
2010-12-27 07:00:00	DIA	ETF	115.48	115.48	115.33	115.36	7200.0
2010-12-27 08:00:00	DIA	ETF	115.4	115.44	115.35	115.4	5100.0
2010-12-27 09:00:00	DIA	ETF	115.4	115.4	115.1494	115.23	531530.0
2010-12-27 10:00:00	DIA	ETF	115.2359	115.46	115.2	115.43	355265.0
2010-12-27 11:00:00	DIA	ETF	115.43	115.439	115.34	115.37	204610.0
2010-12-27 12:00:00	DIA	ETF	115.37	115.48	115.37	115.43	192104.0

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

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