PREVIEW / etf_1hour / 2013-04-05

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-05.parquet
  size:    207 KB
  rows:    6,420

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
2013-04-05 04:00:00	SPY	ETF	155.65	155.65	155.56	155.56	21500.0
2013-04-05 05:00:00	SPY	ETF	155.58	155.59	155.24	155.33	54260.0
2013-04-05 06:00:00	SPY	ETF	155.41	155.42	155.02	155.03	135855.0
2013-04-05 07:00:00	SPY	ETF	155.07	155.13	154.76	154.98	943841.0
2013-04-05 08:00:00	SPY	ETF	155.01	155.8	153.78	153.93	7827959.0
2013-04-05 09:00:00	SPY	ETF	153.92	154.32	153.77	153.96	27838803.0
2013-04-05 10:00:00	SPY	ETF	153.96	154.5	153.8	154.3699	24790418.0
2013-04-05 11:00:00	SPY	ETF	154.37	154.69	154.35	154.36	19164069.0
2013-04-05 12:00:00	SPY	ETF	154.35	154.6	154.27	154.37	10727120.0
2013-04-05 13:00:00	SPY	ETF	154.375	154.79	154.34	154.58	10251819.0
2013-04-05 14:00:00	SPY	ETF	154.58	154.87	154.5	154.82	12764231.0
2013-04-05 15:00:00	SPY	ETF	154.829	155.35	154.61	155.19	29763298.0
2013-04-05 16:00:00	SPY	ETF	155.18	155.872	154.5468	155.13	13747073.0
2013-04-05 17:00:00	SPY	ETF	155.13	155.26	155.12	155.23	322797.0
2013-04-05 18:00:00	SPY	ETF	155.21	155.21	155.11	155.13	42914.0
2013-04-05 19:00:00	SPY	ETF	155.13	155.15	155.09	155.15	14857.0
2013-04-05 05:00:00	QQQ	ETF	68.06	68.06	68.06	68.06	15000.0
2013-04-05 06:00:00	QQQ	ETF	68.06	68.06	67.93	68.0	32380.0
2013-04-05 07:00:00	QQQ	ETF	67.97	67.99	67.85	67.91	75525.0
2013-04-05 08:00:00	QQQ	ETF	67.92	68.0	67.39	67.44	1442971.0
2013-04-05 09:00:00	QQQ	ETF	67.46	67.56	67.19	67.34	9865759.0
2013-04-05 10:00:00	QQQ	ETF	67.34	67.62	67.251	67.58	7247990.0
2013-04-05 11:00:00	QQQ	ETF	67.57	67.72	67.551	67.56	4237505.0
2013-04-05 12:00:00	QQQ	ETF	67.56	67.635	67.51	67.529	3026247.0
2013-04-05 13:00:00	QQQ	ETF	67.53	67.67	67.49	67.57	3096766.0
2013-04-05 14:00:00	QQQ	ETF	67.57	67.71	67.52	67.67	2626919.0
2013-04-05 15:00:00	QQQ	ETF	67.67	67.96	67.58	67.87	6560037.0
2013-04-05 16:00:00	QQQ	ETF	67.86	68.4534	67.61	68.4534	8519194.0
2013-04-05 17:00:00	QQQ	ETF	68.43	68.43	67.86	67.9	4621.0
2013-04-05 18:00:00	QQQ	ETF	67.86	67.86	67.84	67.84	2200.0
2013-04-05 19:00:00	QQQ	ETF	67.85	67.86	67.85	67.86	350.0
2013-04-05 04:00:00	IWM	ETF	91.67	91.67	91.67	91.67	100.0
2013-04-05 06:00:00	IWM	ETF	91.33	91.4	91.32	91.4	2500.0
2013-04-05 07:00:00	IWM	ETF	91.35	91.35	91.16	91.25	120350.0
2013-04-05 08:00:00	IWM	ETF	91.25	91.32	90.38	90.6	1421610.0
2013-04-05 09:00:00	IWM	ETF	90.6	90.92	90.42	90.65	6139180.0
2013-04-05 10:00:00	IWM	ETF	90.65	91.23	90.5	91.09	7460113.0
2013-04-05 11:00:00	IWM	ETF	91.08	91.42	91.08	91.15	5575126.0
2013-04-05 12:00:00	IWM	ETF	91.14	91.42	91.1	91.2251	2595545.0
2013-04-05 13:00:00	IWM	ETF	91.23	91.59	91.2	91.35	2652687.0
2013-04-05 14:00:00	IWM	ETF	91.35	91.55	91.3	91.522	2120645.0
2013-04-05 15:00:00	IWM	ETF	91.53	91.75	91.26	91.73	8118787.0
2013-04-05 16:00:00	IWM	ETF	91.74	91.76	90.8166	91.64	1797475.0
2013-04-05 17:00:00	IWM	ETF	91.63	91.64	91.57	91.64	9706.0
2013-04-05 18:00:00	IWM	ETF	91.67	91.67	91.67	91.67	615.0
2013-04-05 19:00:00	IWM	ETF	91.63	91.64	91.61	91.63	1177.0
2013-04-05 07:00:00	DIA	ETF	144.97	144.97	144.79	144.79	9290.0
2013-04-05 08:00:00	DIA	ETF	144.76	144.97	144.14	144.2	55597.0
2013-04-05 09:00:00	DIA	ETF	144.24	145.77	144.05	144.12	1339143.0
2013-04-05 10:00:00	DIA	ETF	144.12	144.6	144.06	144.499	1104104.0

> showing 50 of 6,420 rows — these rows as CSV

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