PREVIEW / etf_1hour / 2015-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-27.parquet
  size:    245 KB
  rows:    7,823

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-04-27 04:00:00	SPY	ETF	211.73	211.88	211.73	211.74	2915.0
2015-04-27 05:00:00	SPY	ETF	211.65	211.87	211.65	211.87	3005.0
2015-04-27 06:00:00	SPY	ETF	211.96	212.21	211.94	212.14	50498.0
2015-04-27 07:00:00	SPY	ETF	212.21	212.3	212.06	212.15	101595.0
2015-04-27 08:00:00	SPY	ETF	212.14	212.16	211.67	212.13	235973.0
2015-04-27 09:00:00	SPY	ETF	212.12	212.43	211.87	212.32	10325735.0
2015-04-27 10:00:00	SPY	ETF	212.34	212.48	211.81	211.9	8353835.0
2015-04-27 11:00:00	SPY	ETF	211.8901	212.12	211.65	211.74	7669680.0
2015-04-27 12:00:00	SPY	ETF	211.735	211.81	211.01	211.17	9448525.0
2015-04-27 13:00:00	SPY	ETF	211.16	211.4	210.92	211.23	6016716.0
2015-04-27 14:00:00	SPY	ETF	211.23	211.37	210.89	211.08	6438661.0
2015-04-27 15:00:00	SPY	ETF	211.09	211.25	210.54	210.76	19449949.0
2015-04-27 16:00:00	SPY	ETF	210.76	211.6261	210.74	210.84	8043330.0
2015-04-27 17:00:00	SPY	ETF	210.85	210.93	210.77	210.82	148046.0
2015-04-27 18:00:00	SPY	ETF	210.87	210.93	210.83	210.92	122515.0
2015-04-27 19:00:00	SPY	ETF	210.92	210.99	210.89	210.98	43158.0
2015-04-27 05:00:00	QQQ	ETF	110.59	110.59	110.59	110.59	1500.0
2015-04-27 06:00:00	QQQ	ETF	110.73	110.73	110.73	110.73	1500.0
2015-04-27 07:00:00	QQQ	ETF	110.71	110.83	110.71	110.83	133274.0
2015-04-27 08:00:00	QQQ	ETF	110.83	110.92	110.54	110.91	103070.0
2015-04-27 09:00:00	QQQ	ETF	110.92	111.13	110.74	111.1	4008617.0
2015-04-27 10:00:00	QQQ	ETF	111.1	111.16	110.7945	110.8	3069236.0
2015-04-27 11:00:00	QQQ	ETF	110.79	110.94	110.59	110.62	3061666.0
2015-04-27 12:00:00	QQQ	ETF	110.62	110.665	110.34	110.415	3879529.0
2015-04-27 13:00:00	QQQ	ETF	110.41	110.55	110.32	110.35	2143779.0
2015-04-27 14:00:00	QQQ	ETF	110.36	110.44	110.15	110.25	2736665.0
2015-04-27 15:00:00	QQQ	ETF	110.26	110.35	110.02	110.26	5834942.0
2015-04-27 16:00:00	QQQ	ETF	110.26	110.62	110.11	110.37	1966181.0
2015-04-27 17:00:00	QQQ	ETF	110.38	110.6	110.35	110.42	82448.0
2015-04-27 18:00:00	QQQ	ETF	110.4	110.41	110.35	110.39	42901.0
2015-04-27 19:00:00	QQQ	ETF	110.419	110.45	110.41	110.45	37752.0
2015-04-27 07:00:00	IWM	ETF	126.09	126.09	126.09	126.09	100.0
2015-04-27 08:00:00	IWM	ETF	126.1	126.11	125.85	126.08	30844.0
2015-04-27 09:00:00	IWM	ETF	126.1	126.8	126.055	126.78	2156972.0
2015-04-27 10:00:00	IWM	ETF	126.79	126.91	125.87	125.93	3531672.0
2015-04-27 11:00:00	IWM	ETF	125.92	126.0	125.31	125.39	3513380.0
2015-04-27 12:00:00	IWM	ETF	125.39	125.4	124.35	124.4	5439496.0
2015-04-27 13:00:00	IWM	ETF	124.4	124.65	124.04	124.49	3852126.0
2015-04-27 14:00:00	IWM	ETF	124.5	124.605	124.31	124.56	2300446.0
2015-04-27 15:00:00	IWM	ETF	124.56	124.64	124.18	124.45	4780714.0
2015-04-27 16:00:00	IWM	ETF	124.46	124.75	124.4	124.49	1237235.0
2015-04-27 17:00:00	IWM	ETF	124.51	124.58	124.5	124.5	1500.0
2015-04-27 18:00:00	IWM	ETF	124.42	124.54	124.42	124.48	2400.0
2015-04-27 19:00:00	IWM	ETF	124.5	124.57	124.5	124.57	500.0
2015-04-27 07:00:00	DIA	ETF	181.05	181.05	181.05	181.05	100.0
2015-04-27 08:00:00	DIA	ETF	181.0	181.16	180.97	180.97	2050.0
2015-04-27 09:00:00	DIA	ETF	181.18	181.79	180.8	181.19	1251279.0
2015-04-27 10:00:00	DIA	ETF	181.2	181.36	180.83	180.92	598108.0
2015-04-27 11:00:00	DIA	ETF	180.91	181.14	180.74	180.85	340497.0
2015-04-27 12:00:00	DIA	ETF	180.86	180.94	180.13	180.3	790111.0

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

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