PREVIEW / etf_1hour / 2014-02-19

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-19.parquet
  size:    216 KB
  rows:    6,830

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-02-19 04:00:00	SPY	ETF	184.0	184.08	184.0	184.07	17342.0
2014-02-19 05:00:00	SPY	ETF	184.04	184.07	183.82	183.82	138259.0
2014-02-19 06:00:00	SPY	ETF	183.89	183.89	183.54	183.6	61838.0
2014-02-19 07:00:00	SPY	ETF	183.58	183.68	183.54	183.66	221202.0
2014-02-19 08:00:00	SPY	ETF	183.66	183.91	183.56	183.78	1040534.0
2014-02-19 09:00:00	SPY	ETF	183.78	184.46	183.64	184.45	10591522.0
2014-02-19 10:00:00	SPY	ETF	184.4501	184.95	184.24	184.67	19587924.0
2014-02-19 11:00:00	SPY	ETF	184.68	184.75	184.11	184.11	9845757.0
2014-02-19 12:00:00	SPY	ETF	184.11	184.19	183.57	183.88	16473558.0
2014-02-19 13:00:00	SPY	ETF	183.88	184.27	183.85	184.0	6953313.0
2014-02-19 14:00:00	SPY	ETF	184.0	184.4101	183.66	183.86	17144997.0
2014-02-19 15:00:00	SPY	ETF	183.855	184.21	182.87	183.02	28429145.0
2014-02-19 16:00:00	SPY	ETF	183.02	184.2786	182.99	183.15	13429717.0
2014-02-19 17:00:00	SPY	ETF	183.15	183.2	183.1	183.16	76117.0
2014-02-19 18:00:00	SPY	ETF	183.16	183.38	183.13	183.24	479327.0
2014-02-19 19:00:00	SPY	ETF	183.24	183.35	183.24	183.3	37428.0
2014-02-19 04:00:00	QQQ	ETF	90.19	90.23	90.19	90.21	9500.0
2014-02-19 05:00:00	QQQ	ETF	90.23	90.23	90.11	90.11	6050.0
2014-02-19 06:00:00	QQQ	ETF	90.1	90.1	89.98	90.0	4000.0
2014-02-19 07:00:00	QQQ	ETF	89.98	90.02	89.92	90.01	57176.0
2014-02-19 08:00:00	QQQ	ETF	90.01	90.11	89.97	90.1	160856.0
2014-02-19 09:00:00	QQQ	ETF	90.08	90.26	89.93	90.11	3962368.0
2014-02-19 10:00:00	QQQ	ETF	90.11	90.285	89.88	90.145	5630260.0
2014-02-19 11:00:00	QQQ	ETF	90.145	90.22	89.91	89.91	4724594.0
2014-02-19 12:00:00	QQQ	ETF	89.91	89.94	89.66	89.861	3926242.0
2014-02-19 13:00:00	QQQ	ETF	89.8658	90.02	89.84	89.86	2005780.0
2014-02-19 14:00:00	QQQ	ETF	89.86	90.099	89.72	89.82	3496183.0
2014-02-19 15:00:00	QQQ	ETF	89.82	89.86	89.45	89.63	7180114.0
2014-02-19 16:00:00	QQQ	ETF	89.63	90.2689	89.35	89.72	6838330.0
2014-02-19 17:00:00	QQQ	ETF	89.73	89.79	89.63	89.78	54615.0
2014-02-19 18:00:00	QQQ	ETF	89.7	89.78	89.69	89.73	20231.0
2014-02-19 19:00:00	QQQ	ETF	89.72	89.79	89.72	89.78	4800.0
2014-02-19 05:00:00	IWM	ETF	115.0	115.0	115.0	115.0	100.0
2014-02-19 06:00:00	IWM	ETF	114.82	114.82	114.82	114.82	100.0
2014-02-19 07:00:00	IWM	ETF	114.85	114.86	114.76	114.85	17400.0
2014-02-19 08:00:00	IWM	ETF	114.84	115.02	114.79	114.94	97441.0
2014-02-19 09:00:00	IWM	ETF	114.92	115.36	114.79	115.36	3106960.0
2014-02-19 10:00:00	IWM	ETF	115.36	115.64	115.08	115.39	6663438.0
2014-02-19 11:00:00	IWM	ETF	115.4	115.52	115.09	115.095	3941042.0
2014-02-19 12:00:00	IWM	ETF	115.09	115.232	114.51	114.74	6135453.0
2014-02-19 13:00:00	IWM	ETF	114.74	115.15	114.67	115.0	2761928.0
2014-02-19 14:00:00	IWM	ETF	115.0	115.245	114.6	114.7	5457546.0
2014-02-19 15:00:00	IWM	ETF	114.7	114.75	113.98	114.1	9321600.0
2014-02-19 16:00:00	IWM	ETF	114.1	115.4353	114.055	114.12	2332177.0
2014-02-19 17:00:00	IWM	ETF	114.14	115.0737	114.14	114.2	66844.0
2014-02-19 18:00:00	IWM	ETF	114.22	114.24	114.18	114.22	14158.0
2014-02-19 19:00:00	IWM	ETF	114.22	114.26	114.2	114.26	6800.0
2014-02-19 06:00:00	DIA	ETF	161.05	161.05	160.87	160.87	10500.0
2014-02-19 08:00:00	DIA	ETF	160.85	161.16	160.85	161.16	2888.0
2014-02-19 09:00:00	DIA	ETF	161.12	161.87	160.91	161.87	842486.0

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

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