PREVIEW / etf_1hour / 2012-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-31.parquet
  size:    186 KB
  rows:    5,767

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
2012-01-31 04:00:00	SPY	ETF	131.82	132.0	131.82	131.93	10850.0
2012-01-31 05:00:00	SPY	ETF	132.0	132.14	131.94	132.14	11730.0
2012-01-31 06:00:00	SPY	ETF	132.11	132.17	131.91	131.92	83730.0
2012-01-31 07:00:00	SPY	ETF	131.91	132.03	131.83	131.9	296612.0
2012-01-31 08:00:00	SPY	ETF	131.93	132.0	131.8	131.91	2606579.0
2012-01-31 09:00:00	SPY	ETF	131.89	132.18	131.6	131.83	21944260.0
2012-01-31 10:00:00	SPY	ETF	131.75	132.02	130.88	131.01	30176046.0
2012-01-31 11:00:00	SPY	ETF	131.01	131.0899	130.68	130.88	17895029.0
2012-01-31 12:00:00	SPY	ETF	130.87	131.13	130.82	131.011	11187673.0
2012-01-31 13:00:00	SPY	ETF	131.01	131.26	130.88	130.97	11343570.0
2012-01-31 14:00:00	SPY	ETF	130.97	131.35	130.88	131.29	15057884.0
2012-01-31 15:00:00	SPY	ETF	131.29	131.43	131.12	131.24	31413858.0
2012-01-31 16:00:00	SPY	ETF	131.24	131.3333	131.05	131.08	13779545.0
2012-01-31 17:00:00	SPY	ETF	131.07	131.2731	131.06	131.14	302446.0
2012-01-31 18:00:00	SPY	ETF	131.17	131.22	131.08	131.08	79285.0
2012-01-31 19:00:00	SPY	ETF	131.07	131.22	131.07	131.22	63365.0
2012-01-31 04:00:00	QQQ	ETF	60.74	60.76	60.74	60.76	800.0
2012-01-31 05:00:00	QQQ	ETF	60.81	60.81	60.79	60.81	8000.0
2012-01-31 06:00:00	QQQ	ETF	60.85	60.85	60.77	60.77	6400.0
2012-01-31 07:00:00	QQQ	ETF	60.73	60.73	60.6	60.66	856599.0
2012-01-31 08:00:00	QQQ	ETF	60.65	60.73	60.625	60.71	2094608.0
2012-01-31 09:00:00	QQQ	ETF	60.68	60.86	60.56	60.72	6555895.0
2012-01-31 10:00:00	QQQ	ETF	60.72	60.74	60.26	60.3	8738966.0
2012-01-31 11:00:00	QQQ	ETF	60.3	60.37	60.14	60.25	6691382.0
2012-01-31 12:00:00	QQQ	ETF	60.25	60.4	60.21	60.344	5048566.0
2012-01-31 13:00:00	QQQ	ETF	60.35	60.49	60.32	60.358	2595857.0
2012-01-31 14:00:00	QQQ	ETF	60.35	60.58	60.31	60.51	4556480.0
2012-01-31 15:00:00	QQQ	ETF	60.515	60.58	60.425	60.51	7980795.0
2012-01-31 16:00:00	QQQ	ETF	60.51	60.56	60.25	60.3	2991910.0
2012-01-31 17:00:00	QQQ	ETF	60.3	60.33	60.26	60.32	59171.0
2012-01-31 18:00:00	QQQ	ETF	60.32	60.39	60.32	60.32	19300.0
2012-01-31 19:00:00	QQQ	ETF	60.32	60.35	60.32	60.34	43045.0
2012-01-31 04:00:00	IWM	ETF	79.71	79.71	79.71	79.71	200.0
2012-01-31 05:00:00	IWM	ETF	79.82	79.85	79.82	79.85	300.0
2012-01-31 06:00:00	IWM	ETF	79.88	79.93	79.8	79.8	53200.0
2012-01-31 07:00:00	IWM	ETF	79.73	79.79	79.66	79.67	184430.0
2012-01-31 08:00:00	IWM	ETF	79.67	79.71	79.55	79.61	213362.0
2012-01-31 09:00:00	IWM	ETF	79.56	79.82	79.17	79.28	10942922.0
2012-01-31 10:00:00	IWM	ETF	79.28	79.42	78.67	78.73	8694906.0
2012-01-31 11:00:00	IWM	ETF	78.73	78.94	78.58	78.92	4228713.0
2012-01-31 12:00:00	IWM	ETF	78.912	79.08	78.83	79.0	1808156.0
2012-01-31 13:00:00	IWM	ETF	78.99	79.24	78.91	79.01	2903238.0
2012-01-31 14:00:00	IWM	ETF	79.005	79.45	78.93	79.27	5399599.0
2012-01-31 15:00:00	IWM	ETF	79.28	79.37	79.04	79.06	8516082.0
2012-01-31 16:00:00	IWM	ETF	79.05	79.24	78.86	78.9	2342881.0
2012-01-31 17:00:00	IWM	ETF	78.88	79.02	78.88	78.92	31308.0
2012-01-31 19:00:00	IWM	ETF	78.94	78.94	78.9	78.9	2700.0
2012-01-31 04:00:00	DIA	ETF	126.9	126.9	126.9	126.9	100.0
2012-01-31 07:00:00	DIA	ETF	126.85	126.97	126.83	126.83	2190.0
2012-01-31 08:00:00	DIA	ETF	126.79	126.82	126.68	126.73	20350.0

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

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