PREVIEW / etf_1hour / 2011-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-16.parquet
  size:    192 KB
  rows:    5,807

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
2011-03-16 04:00:00	SPY	ETF	128.7	128.87	128.55	128.8	4450.0
2011-03-16 05:00:00	SPY	ETF	128.72	128.74	128.18	128.36	13850.0
2011-03-16 06:00:00	SPY	ETF	128.39	128.39	127.78	128.13	324615.0
2011-03-16 07:00:00	SPY	ETF	128.09	128.38	128.0	128.33	1460782.0
2011-03-16 08:00:00	SPY	ETF	128.34	128.9	127.77	128.52	4109837.0
2011-03-16 09:00:00	SPY	ETF	128.52	128.6	127.69	128.09	30516292.0
2011-03-16 10:00:00	SPY	ETF	128.09	128.57	127.8	127.82	32054875.0
2011-03-16 11:00:00	SPY	ETF	127.83	127.86	126.51	127.17	99090642.0
2011-03-16 12:00:00	SPY	ETF	127.16	127.32	126.6	127.14	59270580.0
2011-03-16 13:00:00	SPY	ETF	127.14	127.32	126.415	126.541	30077478.0
2011-03-16 14:00:00	SPY	ETF	126.54	127.23	125.28	126.95	89082482.0
2011-03-16 15:00:00	SPY	ETF	126.94	127.21	126.11	126.21	67837696.0
2011-03-16 16:00:00	SPY	ETF	126.21	128.6509	125.876	126.22	32281700.0
2011-03-16 17:00:00	SPY	ETF	126.25	126.27	125.58	125.7	12741225.0
2011-03-16 18:00:00	SPY	ETF	125.73	125.78	125.14	125.6	2059503.0
2011-03-16 19:00:00	SPY	ETF	125.59	126.23	125.42	126.04	1241246.0
2011-03-16 04:00:00	QQQ	ETF	55.48	55.57	55.48	55.57	5728.0
2011-03-16 05:00:00	QQQ	ETF	55.51	55.51	55.25	55.34	3600.0
2011-03-16 06:00:00	QQQ	ETF	55.2	55.2	55.05	55.16	12358.0
2011-03-16 07:00:00	QQQ	ETF	55.16	55.3	55.13	55.24	91586.0
2011-03-16 08:00:00	QQQ	ETF	55.27	55.43	55.15	55.28	750729.0
2011-03-16 09:00:00	QQQ	ETF	55.31	55.34	54.96	55.1	19382056.0
2011-03-16 10:00:00	QQQ	ETF	55.1	55.34	55.0	55.0	18200377.0
2011-03-16 11:00:00	QQQ	ETF	55.005	55.01	54.41	54.49	38049976.0
2011-03-16 12:00:00	QQQ	ETF	54.5	54.69	54.32	54.632	24226495.0
2011-03-16 13:00:00	QQQ	ETF	54.65	54.71	54.27	54.3501	10566450.0
2011-03-16 14:00:00	QQQ	ETF	54.35	54.6599	53.77	54.5598	23504734.0
2011-03-16 15:00:00	QQQ	ETF	54.55	54.69	54.13	54.18	22013610.0
2011-03-16 16:00:00	QQQ	ETF	54.17	54.43	54.11	54.28	7192665.0
2011-03-16 17:00:00	QQQ	ETF	54.27	54.3	53.93	54.08	515230.0
2011-03-16 18:00:00	QQQ	ETF	54.06	54.06	53.78	54.0	234328.0
2011-03-16 19:00:00	QQQ	ETF	53.98	54.5632	53.94	54.25	251005.0
2011-03-16 04:00:00	IWM	ETF	79.22	79.33	79.13	79.33	5300.0
2011-03-16 05:00:00	IWM	ETF	79.33	79.33	78.88	78.9	1300.0
2011-03-16 06:00:00	IWM	ETF	78.76	78.8	78.6	78.8	51200.0
2011-03-16 07:00:00	IWM	ETF	78.76	78.99	78.73	78.85	35802.0
2011-03-16 08:00:00	IWM	ETF	78.91	79.23	78.86	79.1	544239.0
2011-03-16 09:00:00	IWM	ETF	79.09	79.24	78.63	79.0754	8685619.0
2011-03-16 10:00:00	IWM	ETF	79.08	79.64	79.07	79.09	9656463.0
2011-03-16 11:00:00	IWM	ETF	79.08	79.09	78.22	78.5	30343600.0
2011-03-16 12:00:00	IWM	ETF	78.5	78.86	78.29	78.81	14242733.0
2011-03-16 13:00:00	IWM	ETF	78.81	78.93	78.3499	78.43	9857853.0
2011-03-16 14:00:00	IWM	ETF	78.43	78.92	77.76	78.77	18737742.0
2011-03-16 15:00:00	IWM	ETF	78.77	78.91	78.14	78.27	15620051.0
2011-03-16 16:00:00	IWM	ETF	78.27	79.02	78.1794	78.22	5296917.0
2011-03-16 17:00:00	IWM	ETF	78.22	78.24	77.79	77.94	154638.0
2011-03-16 18:00:00	IWM	ETF	77.91	77.95	77.76	77.88	115753.0
2011-03-16 19:00:00	IWM	ETF	77.88	78.16	77.81	78.14	29285.0
2011-03-16 05:00:00	DIA	ETF	118.78	118.78	118.28	118.29	1800.0
2011-03-16 06:00:00	DIA	ETF	118.28	118.28	118.09	118.18	800.0

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

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