PREVIEW / etf_1hour / 2014-04-02

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-02.parquet
  size:    215 KB
  rows:    6,843

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
2014-04-02 04:00:00	SPY	ETF	188.49	188.58	188.44	188.55	18946.0
2014-04-02 05:00:00	SPY	ETF	188.53	188.62	188.53	188.55	36036.0
2014-04-02 06:00:00	SPY	ETF	188.56	188.64	188.42	188.44	27451.0
2014-04-02 07:00:00	SPY	ETF	188.43	188.54	188.23	188.29	141907.0
2014-04-02 08:00:00	SPY	ETF	188.43	188.51	188.21	188.35	638453.0
2014-04-02 09:00:00	SPY	ETF	188.35	188.59	188.14	188.28	10924814.0
2014-04-02 10:00:00	SPY	ETF	188.28	188.825	188.28	188.775	13097604.0
2014-04-02 11:00:00	SPY	ETF	188.77	188.87	188.56	188.795	7997015.0
2014-04-02 12:00:00	SPY	ETF	188.8	188.9	188.63	188.77	5982461.0
2014-04-02 13:00:00	SPY	ETF	188.78	188.79	188.34	188.49	7401025.0
2014-04-02 14:00:00	SPY	ETF	188.48	188.7	188.4	188.69	8423903.0
2014-04-02 15:00:00	SPY	ETF	188.7	189.13	188.64	188.88	17836795.0
2014-04-02 16:00:00	SPY	ETF	188.88	188.93	188.3492	188.85	4656558.0
2014-04-02 17:00:00	SPY	ETF	188.86	188.86	188.78	188.8	59686.0
2014-04-02 18:00:00	SPY	ETF	188.79	188.79	188.72	188.77	35585.0
2014-04-02 19:00:00	SPY	ETF	188.75	188.76	188.67	188.68	88055.0
2014-04-02 04:00:00	QQQ	ETF	89.43	89.49	89.43	89.49	25500.0
2014-04-02 05:00:00	QQQ	ETF	89.47	89.5	89.47	89.5	13690.0
2014-04-02 06:00:00	QQQ	ETF	89.45	89.46	89.41	89.41	3500.0
2014-04-02 07:00:00	QQQ	ETF	89.36	89.45	89.27	89.31	118715.0
2014-04-02 08:00:00	QQQ	ETF	89.28	89.41	89.28	89.33	129676.0
2014-04-02 09:00:00	QQQ	ETF	89.33	89.68	89.22	89.25	5140571.0
2014-04-02 10:00:00	QQQ	ETF	89.25	89.46	89.1	89.44	5926899.0
2014-04-02 11:00:00	QQQ	ETF	89.44	89.5299	89.25	89.38	2422132.0
2014-04-02 12:00:00	QQQ	ETF	89.39	89.42	89.23	89.382	2842085.0
2014-04-02 13:00:00	QQQ	ETF	89.39	89.39	89.035	89.1625	2618091.0
2014-04-02 14:00:00	QQQ	ETF	89.1601	89.26	89.06	89.255	1712011.0
2014-04-02 15:00:00	QQQ	ETF	89.255	89.53	89.2	89.44	5443329.0
2014-04-02 16:00:00	QQQ	ETF	89.45	89.49	89.286	89.47	993284.0
2014-04-02 17:00:00	QQQ	ETF	89.45	89.45	89.43	89.44	4399462.0
2014-04-02 18:00:00	QQQ	ETF	89.44	89.44	89.4	89.4	10366.0
2014-04-02 19:00:00	QQQ	ETF	89.38	89.38	89.35	89.36	12109.0
2014-04-02 04:00:00	IWM	ETF	118.24	118.24	118.24	118.24	100.0
2014-04-02 05:00:00	IWM	ETF	118.1	118.1	118.1	118.1	250.0
2014-04-02 07:00:00	IWM	ETF	118.3	118.34	118.11	118.13	111595.0
2014-04-02 08:00:00	IWM	ETF	118.17	118.28	118.11	118.16	111167.0
2014-04-02 09:00:00	IWM	ETF	118.18	118.29	117.71	117.74	5346216.0
2014-04-02 10:00:00	IWM	ETF	117.73	118.31	117.72	118.28	6357233.0
2014-04-02 11:00:00	IWM	ETF	118.28	118.41	117.93	118.29	3816262.0
2014-04-02 12:00:00	IWM	ETF	118.3	118.33	118.13	118.255	1586888.0
2014-04-02 13:00:00	IWM	ETF	118.27	118.28	117.92	118.12	2141857.0
2014-04-02 14:00:00	IWM	ETF	118.13	118.23	118.015	118.21	2458313.0
2014-04-02 15:00:00	IWM	ETF	118.22	118.482	118.14	118.41	6622258.0
2014-04-02 16:00:00	IWM	ETF	118.41	118.43	118.32	118.43	917538.0
2014-04-02 17:00:00	IWM	ETF	118.4	118.4	118.36	118.37	18000.0
2014-04-02 19:00:00	IWM	ETF	118.34	118.34	118.3	118.34	2600.0
2014-04-02 07:00:00	DIA	ETF	165.0	165.0	165.0	165.0	800.0
2014-04-02 08:00:00	DIA	ETF	165.08	165.1	165.02	165.1	777.0
2014-04-02 09:00:00	DIA	ETF	165.09	165.22	164.75	164.95	802370.0
2014-04-02 10:00:00	DIA	ETF	164.965	165.39	164.965	165.3	1622468.0

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

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