PREVIEW / etf_1hour / 2013-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-26.parquet
  size:    201 KB
  rows:    6,315

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-26 04:00:00	SPY	ETF	169.33	169.47	169.26	169.34	16100.0
2013-09-26 05:00:00	SPY	ETF	169.32	169.36	169.26	169.34	6133.0
2013-09-26 06:00:00	SPY	ETF	169.32	169.32	169.12	169.21	69739.0
2013-09-26 07:00:00	SPY	ETF	169.21	169.44	169.21	169.36	184886.0
2013-09-26 08:00:00	SPY	ETF	169.34	169.8	169.15	169.45	1055207.0
2013-09-26 09:00:00	SPY	ETF	169.44	169.93	169.28	169.9	8861316.0
2013-09-26 10:00:00	SPY	ETF	169.905	170.17	169.3	169.43	15952193.0
2013-09-26 11:00:00	SPY	ETF	169.43	169.52	169.1	169.44	10081281.0
2013-09-26 12:00:00	SPY	ETF	169.44	169.68	169.29	169.55	4393880.0
2013-09-26 13:00:00	SPY	ETF	169.55	169.75	169.34	169.48	5058876.0
2013-09-26 14:00:00	SPY	ETF	169.48	169.48	169.05	169.19	7069176.0
2013-09-26 15:00:00	SPY	ETF	169.18	169.69	169.06	169.65	16407430.0
2013-09-26 16:00:00	SPY	ETF	169.66	169.87	169.06	169.83	5597694.0
2013-09-26 17:00:00	SPY	ETF	169.81	169.92	169.5005	169.88	344900.0
2013-09-26 18:00:00	SPY	ETF	169.88	169.98	169.87	169.97	74927.0
2013-09-26 19:00:00	SPY	ETF	169.95	169.97	169.91	169.94	44959.0
2013-09-26 04:00:00	QQQ	ETF	78.85	78.88	78.79	78.83	29302.0
2013-09-26 05:00:00	QQQ	ETF	78.82	78.84	78.79	78.81	16600.0
2013-09-26 06:00:00	QQQ	ETF	78.8	78.8	78.71	78.76	13300.0
2013-09-26 07:00:00	QQQ	ETF	78.77	78.87	78.77	78.85	30521.0
2013-09-26 08:00:00	QQQ	ETF	78.84	78.92	78.79	78.92	72650.0
2013-09-26 09:00:00	QQQ	ETF	78.91	79.2	78.84	79.19	2388983.0
2013-09-26 10:00:00	QQQ	ETF	79.18	79.36	79.01	79.04	4186033.0
2013-09-26 11:00:00	QQQ	ETF	79.04	79.1193	78.85	79.09	2392485.0
2013-09-26 12:00:00	QQQ	ETF	79.1	79.2399	79.03	79.2	1282628.0
2013-09-26 13:00:00	QQQ	ETF	79.21	79.315	79.08	79.1674	1204750.0
2013-09-26 14:00:00	QQQ	ETF	79.16	79.165	78.958	79.025	1693472.0
2013-09-26 15:00:00	QQQ	ETF	79.02	79.21	78.94	79.16	3209576.0
2013-09-26 16:00:00	QQQ	ETF	79.17	79.23	78.966	79.23	895188.0
2013-09-26 17:00:00	QQQ	ETF	79.21	79.24	79.0981	79.24	311493.0
2013-09-26 18:00:00	QQQ	ETF	79.28	79.32	79.28	79.32	11690.0
2013-09-26 19:00:00	QQQ	ETF	79.32	79.32	79.25	79.25	3080.0
2013-09-26 04:00:00	IWM	ETF	106.66	106.66	106.66	106.66	100.0
2013-09-26 07:00:00	IWM	ETF	106.68	106.74	106.68	106.72	26261.0
2013-09-26 08:00:00	IWM	ETF	106.76	106.85	106.66	106.81	256839.0
2013-09-26 09:00:00	IWM	ETF	106.75	107.36	106.65	107.27	2922073.0
2013-09-26 10:00:00	IWM	ETF	107.27	107.47	106.46	106.68	5575422.0
2013-09-26 11:00:00	IWM	ETF	106.67	106.83	106.36	106.75	3955279.0
2013-09-26 12:00:00	IWM	ETF	106.755	106.97	106.61	106.87	1844046.0
2013-09-26 13:00:00	IWM	ETF	106.87	107.11	106.76	106.93	2687961.0
2013-09-26 14:00:00	IWM	ETF	106.92	106.925	106.64	106.67	2124026.0
2013-09-26 15:00:00	IWM	ETF	106.67	107.09	106.57	107.05	5937095.0
2013-09-26 16:00:00	IWM	ETF	107.05	107.23	106.68	107.19	837814.0
2013-09-26 17:00:00	IWM	ETF	107.2	107.22	106.8144	107.2	297509.0
2013-09-26 18:00:00	IWM	ETF	107.34	107.35	107.21	107.21	6178.0
2013-09-26 19:00:00	IWM	ETF	107.26	107.28	107.22	107.22	500.0
2013-09-26 07:00:00	DIA	ETF	152.73	152.73	152.73	152.73	200.0
2013-09-26 08:00:00	DIA	ETF	152.55	152.6	152.55	152.6	400.0
2013-09-26 09:00:00	DIA	ETF	152.75	153.29	152.69	153.28	448548.0
2013-09-26 10:00:00	DIA	ETF	153.27	153.54	152.69	152.79	965445.0

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

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