PREVIEW / etf_1hour / 2013-09-24

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-24.parquet
  size:    206 KB
  rows:    6,367

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-09-24 04:00:00	SPY	ETF	169.65	169.7	169.5	169.67	19975.0
2013-09-24 05:00:00	SPY	ETF	169.7	169.7	169.46	169.56	6000.0
2013-09-24 06:00:00	SPY	ETF	169.54	169.67	169.49	169.64	51000.0
2013-09-24 07:00:00	SPY	ETF	169.63	169.75	169.42	169.46	288762.0
2013-09-24 08:00:00	SPY	ETF	169.55	169.8	169.46	169.77	540242.0
2013-09-24 09:00:00	SPY	ETF	169.79	169.94	169.57	169.645	12423110.0
2013-09-24 10:00:00	SPY	ETF	169.64	170.14	169.21	170.04	19420401.0
2013-09-24 11:00:00	SPY	ETF	170.04	170.27	170.04	170.19	11918651.0
2013-09-24 12:00:00	SPY	ETF	170.19	170.43	170.07	170.29	9630172.0
2013-09-24 13:00:00	SPY	ETF	170.3	170.53	170.25	170.34	6593654.0
2013-09-24 14:00:00	SPY	ETF	170.35	170.4	170.075	170.09	7472121.0
2013-09-24 15:00:00	SPY	ETF	170.09	170.17	169.37	169.53	20974266.0
2013-09-24 16:00:00	SPY	ETF	169.53	170.2001	169.4703	169.64	8208657.0
2013-09-24 17:00:00	SPY	ETF	169.64	169.8959	169.58	169.62	671503.0
2013-09-24 18:00:00	SPY	ETF	169.64	169.66	169.55	169.55	165030.0
2013-09-24 19:00:00	SPY	ETF	169.55	169.6	169.52	169.55	76318.0
2013-09-24 04:00:00	QQQ	ETF	78.82	78.84	78.8	78.84	14100.0
2013-09-24 05:00:00	QQQ	ETF	78.86	78.86	78.78	78.78	9500.0
2013-09-24 06:00:00	QQQ	ETF	78.78	78.85	78.78	78.85	5300.0
2013-09-24 07:00:00	QQQ	ETF	78.82	78.86	78.78	78.78	11800.0
2013-09-24 08:00:00	QQQ	ETF	78.75	78.9	78.74	78.9	39155.0
2013-09-24 09:00:00	QQQ	ETF	78.9	79.02	78.82	78.83	3236195.0
2013-09-24 10:00:00	QQQ	ETF	78.8234	79.15	78.57	79.1	5056457.0
2013-09-24 11:00:00	QQQ	ETF	79.1	79.18	79.02	79.09	2400306.0
2013-09-24 12:00:00	QQQ	ETF	79.08	79.17	79.011	79.1	1159326.0
2013-09-24 13:00:00	QQQ	ETF	79.1	79.25	79.07	79.16	1351651.0
2013-09-24 14:00:00	QQQ	ETF	79.16	79.18	79.02	79.04	1934163.0
2013-09-24 15:00:00	QQQ	ETF	79.04	79.08	78.69	78.83	3702414.0
2013-09-24 16:00:00	QQQ	ETF	78.82	78.94	78.7955	78.8119	1013018.0
2013-09-24 17:00:00	QQQ	ETF	78.85	78.9586	78.85	78.87	441946.0
2013-09-24 18:00:00	QQQ	ETF	78.87	78.87	78.83	78.83	2135.0
2013-09-24 19:00:00	QQQ	ETF	78.83	78.84	78.83	78.83	2300.0
2013-09-24 04:00:00	IWM	ETF	106.3	106.3	106.21	106.21	300.0
2013-09-24 05:00:00	IWM	ETF	106.3	106.45	106.3	106.45	850.0
2013-09-24 07:00:00	IWM	ETF	106.31	106.31	106.12	106.12	6200.0
2013-09-24 08:00:00	IWM	ETF	106.18	106.35	106.18	106.33	42963.0
2013-09-24 09:00:00	IWM	ETF	106.36	106.5	106.01	106.09	3186511.0
2013-09-24 10:00:00	IWM	ETF	106.09	106.72	105.79	106.61	6789718.0
2013-09-24 11:00:00	IWM	ETF	106.61	107.07	106.61	107.045	4815214.0
2013-09-24 12:00:00	IWM	ETF	107.05	107.35	106.98	107.241	2721211.0
2013-09-24 13:00:00	IWM	ETF	107.245	107.42	107.225	107.25	3340418.0
2013-09-24 14:00:00	IWM	ETF	107.25	107.41	107.11	107.13	3511790.0
2013-09-24 15:00:00	IWM	ETF	107.13	107.28	106.47	106.65	6839384.0
2013-09-24 16:00:00	IWM	ETF	106.64	107.1256	106.3534	106.65	2086407.0
2013-09-24 17:00:00	IWM	ETF	106.3536	106.7789	106.3536	106.67	1209495.0
2013-09-24 18:00:00	IWM	ETF	106.68	106.68	106.67	106.68	1000.0
2013-09-24 07:00:00	DIA	ETF	153.68	153.68	153.46	153.46	2275.0
2013-09-24 08:00:00	DIA	ETF	153.54	153.65	153.54	153.55	3050.0
2013-09-24 09:00:00	DIA	ETF	153.8	153.81	153.43	153.52	533532.0
2013-09-24 10:00:00	DIA	ETF	153.5	153.91	153.06	153.84	1210414.0

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

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