PREVIEW / etf_1hour / 2015-03-04

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-03-04.parquet
  size:    234 KB
  rows:    7,494

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-04 04:00:00	SPY	ETF	210.25	210.4	210.25	210.39	2100.0
2015-03-04 05:00:00	SPY	ETF	210.49	210.49	210.24	210.25	10857.0
2015-03-04 06:00:00	SPY	ETF	210.25	210.39	210.18	210.32	55188.0
2015-03-04 07:00:00	SPY	ETF	210.36	210.44	210.24	210.43	128347.0
2015-03-04 08:00:00	SPY	ETF	210.37	210.54	210.25	210.4	730328.0
2015-03-04 09:00:00	SPY	ETF	210.38	210.45	209.37	209.622	16388284.0
2015-03-04 10:00:00	SPY	ETF	209.63	209.74	209.06	209.595	19428117.0
2015-03-04 11:00:00	SPY	ETF	209.59	210.19	209.55	210.01	12560009.0
2015-03-04 12:00:00	SPY	ETF	210.02	210.49	209.94	210.2	7995922.0
2015-03-04 13:00:00	SPY	ETF	210.21	210.4	209.86	209.92	6883754.0
2015-03-04 14:00:00	SPY	ETF	209.92	210.26	209.78	210.23	10538080.0
2015-03-04 15:00:00	SPY	ETF	210.23	210.35	209.98	210.23	25269507.0
2015-03-04 16:00:00	SPY	ETF	210.22	211.1355	210.07	210.131	8512443.0
2015-03-04 17:00:00	SPY	ETF	210.2135	210.2135	210.1	210.14	5044448.0
2015-03-04 18:00:00	SPY	ETF	210.15	210.16	210.02	210.09	80767.0
2015-03-04 19:00:00	SPY	ETF	210.07	210.15	210.0	210.14	38909.0
2015-03-04 04:00:00	QQQ	ETF	108.58	108.58	108.45	108.46	1033.0
2015-03-04 05:00:00	QQQ	ETF	108.43	108.43	108.43	108.43	2800.0
2015-03-04 06:00:00	QQQ	ETF	108.43	108.46	108.42	108.42	26400.0
2015-03-04 07:00:00	QQQ	ETF	108.44	108.51	108.44	108.51	10336.0
2015-03-04 08:00:00	QQQ	ETF	108.51	108.53	108.47	108.53	27703.0
2015-03-04 09:00:00	QQQ	ETF	108.5	108.55	107.92	108.08	4251602.0
2015-03-04 10:00:00	QQQ	ETF	108.09	108.27	107.86	108.24	4137326.0
2015-03-04 11:00:00	QQQ	ETF	108.23	108.59	108.22	108.46	2328654.0
2015-03-04 12:00:00	QQQ	ETF	108.45	108.67	108.41	108.51	1664741.0
2015-03-04 13:00:00	QQQ	ETF	108.515	108.65	108.36	108.4	1814421.0
2015-03-04 14:00:00	QQQ	ETF	108.41	108.62	108.28	108.6	2100998.0
2015-03-04 15:00:00	QQQ	ETF	108.6	108.62	108.43	108.47	3536768.0
2015-03-04 16:00:00	QQQ	ETF	108.47	108.51	108.3	108.44	601806.0
2015-03-04 17:00:00	QQQ	ETF	108.43	108.43	108.36	108.43	13190.0
2015-03-04 18:00:00	QQQ	ETF	108.43	108.45	108.41	108.41	24123.0
2015-03-04 19:00:00	QQQ	ETF	108.41	108.46	108.4	108.44	4293.0
2015-03-04 04:00:00	IWM	ETF	122.2	122.2	122.2	122.2	300.0
2015-03-04 07:00:00	IWM	ETF	122.22	122.22	122.13	122.16	18548.0
2015-03-04 08:00:00	IWM	ETF	122.19	122.22	122.14	122.16	20769.0
2015-03-04 09:00:00	IWM	ETF	122.18	122.4	121.61	121.98	3089055.0
2015-03-04 10:00:00	IWM	ETF	121.97	122.145	121.67	122.07	3530316.0
2015-03-04 11:00:00	IWM	ETF	122.065	122.5	122.04	122.15	3459174.0
2015-03-04 12:00:00	IWM	ETF	122.14	122.54	122.115	122.345	1688537.0
2015-03-04 13:00:00	IWM	ETF	122.35	122.58	122.21	122.24	1523460.0
2015-03-04 14:00:00	IWM	ETF	122.25	122.56	122.2138	122.5542	1571538.0
2015-03-04 15:00:00	IWM	ETF	122.56	122.605	122.23	122.4	3563164.0
2015-03-04 16:00:00	IWM	ETF	122.39	122.4	122.3	122.31	602932.0
2015-03-04 17:00:00	IWM	ETF	122.33	122.33	122.33	122.33	2000.0
2015-03-04 19:00:00	IWM	ETF	122.26	122.26	122.26	122.26	650.0
2015-03-04 09:00:00	DIA	ETF	181.39	181.41	180.31	180.5	799389.0
2015-03-04 10:00:00	DIA	ETF	180.49	180.6	180.13	180.44	860157.0
2015-03-04 11:00:00	DIA	ETF	180.45	180.94	180.43	180.82	432074.0
2015-03-04 12:00:00	DIA	ETF	180.81	181.19	180.76	180.9628	309716.0
2015-03-04 13:00:00	DIA	ETF	180.97	181.11	180.61	180.6301	205266.0

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

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