PREVIEW / etf_1hour / 2014-02-18

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-18.parquet
  size:    220 KB
  rows:    6,962

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-18 04:00:00	SPY	ETF	184.08	184.08	183.77	183.81	26818.0
2014-02-18 05:00:00	SPY	ETF	183.85	183.93	183.79	183.89	5511.0
2014-02-18 06:00:00	SPY	ETF	183.84	183.93	183.73	183.88	41306.0
2014-02-18 07:00:00	SPY	ETF	183.9	184.32	183.9	184.27	300344.0
2014-02-18 08:00:00	SPY	ETF	184.0	184.32	183.85	184.03	1392564.0
2014-02-18 09:00:00	SPY	ETF	184.03	184.46	183.9	184.04	11974521.0
2014-02-18 10:00:00	SPY	ETF	184.04	184.28	183.65	184.1951	13627806.0
2014-02-18 11:00:00	SPY	ETF	184.2	184.49	184.12	184.22	7995472.0
2014-02-18 12:00:00	SPY	ETF	184.22	184.45	184.18	184.35	5501089.0
2014-02-18 13:00:00	SPY	ETF	184.35	184.4	184.11	184.2401	5106960.0
2014-02-18 14:00:00	SPY	ETF	184.245	184.48	184.24	184.35	9158191.0
2014-02-18 15:00:00	SPY	ETF	184.35	184.47	184.2	184.25	16380376.0
2014-02-18 16:00:00	SPY	ETF	184.26	184.4	183.9814	184.27	5794765.0
2014-02-18 17:00:00	SPY	ETF	184.26	184.32	184.22	184.25	109574.0
2014-02-18 18:00:00	SPY	ETF	184.24	184.25	183.98	183.98	216837.0
2014-02-18 19:00:00	SPY	ETF	183.97	184.08	183.94	184.01	227556.0
2014-02-18 04:00:00	QQQ	ETF	89.8	89.8	89.8	89.8	300.0
2014-02-18 05:00:00	QQQ	ETF	89.79	89.81	89.79	89.81	1900.0
2014-02-18 06:00:00	QQQ	ETF	89.77	89.78	89.7	89.78	4200.0
2014-02-18 07:00:00	QQQ	ETF	89.85	89.98	89.84	89.96	16100.0
2014-02-18 08:00:00	QQQ	ETF	89.96	89.96	89.83	89.9	141592.0
2014-02-18 09:00:00	QQQ	ETF	89.91	90.19	89.86	89.92	3996353.0
2014-02-18 10:00:00	QQQ	ETF	89.91	90.34	89.74	90.3	5802671.0
2014-02-18 11:00:00	QQQ	ETF	90.3	90.37	90.14	90.16	3498902.0
2014-02-18 12:00:00	QQQ	ETF	90.155	90.35	90.15	90.27	1926080.0
2014-02-18 13:00:00	QQQ	ETF	90.265	90.31	90.18	90.26	1342218.0
2014-02-18 14:00:00	QQQ	ETF	90.26	90.4172	90.26	90.365	2209117.0
2014-02-18 15:00:00	QQQ	ETF	90.36	90.41	90.23	90.26	4591640.0
2014-02-18 16:00:00	QQQ	ETF	90.25	90.284	89.8889	90.21	3232971.0
2014-02-18 17:00:00	QQQ	ETF	90.22	90.24	90.21	90.24	6231.0
2014-02-18 18:00:00	QQQ	ETF	90.2	90.2	90.08	90.08	36027.0
2014-02-18 19:00:00	QQQ	ETF	90.09	90.13	90.07	90.13	31580.0
2014-02-18 05:00:00	IWM	ETF	113.81	113.81	113.81	113.81	500.0
2014-02-18 06:00:00	IWM	ETF	113.85	113.85	113.85	113.85	140.0
2014-02-18 07:00:00	IWM	ETF	114.17	114.24	114.11	114.2	12500.0
2014-02-18 08:00:00	IWM	ETF	114.19	114.28	114.07	114.14	85707.0
2014-02-18 09:00:00	IWM	ETF	114.18	114.86	114.18	114.51	4097640.0
2014-02-18 10:00:00	IWM	ETF	114.5	115.055	114.14	115.0	5233418.0
2014-02-18 11:00:00	IWM	ETF	115.0	115.45	114.96	115.18	5140265.0
2014-02-18 12:00:00	IWM	ETF	115.18	115.4	115.17	115.27	2554510.0
2014-02-18 13:00:00	IWM	ETF	115.275	115.36	114.97	115.14	3481133.0
2014-02-18 14:00:00	IWM	ETF	115.145	115.415	115.1	115.3	2422044.0
2014-02-18 15:00:00	IWM	ETF	115.3	115.45	115.23	115.26	4523926.0
2014-02-18 16:00:00	IWM	ETF	115.26	115.3	115.17	115.25	2211291.0
2014-02-18 17:00:00	IWM	ETF	115.26	115.28	115.23	115.24	8900.0
2014-02-18 18:00:00	IWM	ETF	115.24	115.24	115.18	115.18	25015.0
2014-02-18 19:00:00	IWM	ETF	115.16	115.18	115.14	115.14	10109.0
2014-02-18 07:00:00	DIA	ETF	161.9	161.9	161.9	161.9	100.0
2014-02-18 08:00:00	DIA	ETF	161.88	161.9	161.6	161.64	8910.0
2014-02-18 09:00:00	DIA	ETF	161.71	161.8	161.34	161.49	1075573.0

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

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