PREVIEW / etf_1hour / 2015-03-02

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-03-02.parquet
  size:    242 KB
  rows:    7,707

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
2015-03-02 04:00:00	SPY	ETF	211.07	211.14	211.02	211.12	12100.0
2015-03-02 05:00:00	SPY	ETF	211.07	211.13	211.04	211.13	2774.0
2015-03-02 06:00:00	SPY	ETF	211.05	211.05	210.79	210.79	37185.0
2015-03-02 07:00:00	SPY	ETF	210.88	210.95	210.71	210.78	135873.0
2015-03-02 08:00:00	SPY	ETF	210.77	210.83	210.6	210.62	439116.0
2015-03-02 09:00:00	SPY	ETF	210.61	211.29	210.57	211.27	9616044.0
2015-03-02 10:00:00	SPY	ETF	211.27	211.75	211.25	211.6	12110457.0
2015-03-02 11:00:00	SPY	ETF	211.6	211.78	211.41	211.55	8692884.0
2015-03-02 12:00:00	SPY	ETF	211.559	211.59	211.21	211.41	6917524.0
2015-03-02 13:00:00	SPY	ETF	211.415	211.65	211.36	211.6152	5630518.0
2015-03-02 14:00:00	SPY	ETF	211.62	211.69	211.37	211.645	7732098.0
2015-03-02 15:00:00	SPY	ETF	211.65	212.06	211.6	212.0	22645171.0
2015-03-02 16:00:00	SPY	ETF	212.01	212.03	211.86	211.93	10272108.0
2015-03-02 17:00:00	SPY	ETF	211.93	211.96	211.12	211.91	1581838.0
2015-03-02 18:00:00	SPY	ETF	211.92	211.96	211.89	211.93	22813.0
2015-03-02 19:00:00	SPY	ETF	211.915	211.92	211.86	211.86	100679.0
2015-03-02 05:00:00	QQQ	ETF	108.75	108.75	108.73	108.73	400.0
2015-03-02 06:00:00	QQQ	ETF	108.61	108.65	108.52	108.52	26300.0
2015-03-02 07:00:00	QQQ	ETF	108.55	108.6	108.53	108.57	43736.0
2015-03-02 08:00:00	QQQ	ETF	108.56	108.61	108.35	108.54	92963.0
2015-03-02 09:00:00	QQQ	ETF	108.55	109.07	108.53	109.06	4421831.0
2015-03-02 10:00:00	QQQ	ETF	109.06	109.25	108.98	109.08	4298567.0
2015-03-02 11:00:00	QQQ	ETF	109.08	109.29	108.98	109.19	2076902.0
2015-03-02 12:00:00	QQQ	ETF	109.19	109.22	108.87	109.01	2094772.0
2015-03-02 13:00:00	QQQ	ETF	109.01	109.075	108.83	109.07	1323706.0
2015-03-02 14:00:00	QQQ	ETF	109.07	109.16	108.98	109.15	1664557.0
2015-03-02 15:00:00	QQQ	ETF	109.16	109.42	109.13	109.38	4685568.0
2015-03-02 16:00:00	QQQ	ETF	109.38	109.3909	108.4	109.31	652303.0
2015-03-02 17:00:00	QQQ	ETF	109.31	109.36	109.31	109.35	17414.0
2015-03-02 18:00:00	QQQ	ETF	109.33	109.33	109.29	109.31	20328.0
2015-03-02 19:00:00	QQQ	ETF	109.3	109.3	109.29	109.3	8778.0
2015-03-02 04:00:00	IWM	ETF	123.24	123.24	122.69	122.69	411.0
2015-03-02 05:00:00	IWM	ETF	122.78	122.78	122.78	122.78	161.0
2015-03-02 06:00:00	IWM	ETF	122.8	122.8	122.65	122.65	2050.0
2015-03-02 07:00:00	IWM	ETF	122.6	122.6	122.47	122.53	2900.0
2015-03-02 08:00:00	IWM	ETF	122.54	122.6	122.49	122.49	15997.0
2015-03-02 09:00:00	IWM	ETF	122.44	123.02	122.44	122.94	1951372.0
2015-03-02 10:00:00	IWM	ETF	122.891	123.775	122.891	123.53	4553930.0
2015-03-02 11:00:00	IWM	ETF	123.54	123.61	123.2	123.23	2103664.0
2015-03-02 12:00:00	IWM	ETF	123.23	123.3	122.63	122.91	2930109.0
2015-03-02 13:00:00	IWM	ETF	122.92	123.15	122.8	123.13	1723523.0
2015-03-02 14:00:00	IWM	ETF	123.135	123.19	122.91	123.12	1757302.0
2015-03-02 15:00:00	IWM	ETF	123.12	123.64	123.06	123.54	6224276.0
2015-03-02 16:00:00	IWM	ETF	123.53	123.53	123.2271	123.34	4122789.0
2015-03-02 17:00:00	IWM	ETF	123.38	123.38	123.35	123.35	3840.0
2015-03-02 18:00:00	IWM	ETF	123.35	123.4	123.32	123.4	7608.0
2015-03-02 19:00:00	IWM	ETF	123.4	123.4	123.34	123.34	600.0
2015-03-02 07:00:00	DIA	ETF	181.35	181.35	181.25	181.25	1200.0
2015-03-02 08:00:00	DIA	ETF	181.28	181.32	181.28	181.32	200.0
2015-03-02 09:00:00	DIA	ETF	181.23	181.99	181.23	181.96	624914.0

> showing 50 of 7,707 rows — these rows as CSV

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