PREVIEW / etf_1hour / 2015-04-08

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-08.parquet
  size:    239 KB
  rows:    7,607

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-08 04:00:00	SPY	ETF	207.54	207.83	207.54	207.57	20754.0
2015-04-08 05:00:00	SPY	ETF	207.69	207.76	207.55	207.66	40494.0
2015-04-08 06:00:00	SPY	ETF	207.54	207.54	207.24	207.3	25872.0
2015-04-08 07:00:00	SPY	ETF	207.37	207.58	207.35	207.43	119441.0
2015-04-08 08:00:00	SPY	ETF	207.5	207.6	207.37	207.48	419887.0
2015-04-08 09:00:00	SPY	ETF	207.48	208.45	207.48	208.39	9937380.0
2015-04-08 10:00:00	SPY	ETF	208.38	208.51	207.15	207.6	13864174.0
2015-04-08 11:00:00	SPY	ETF	207.59	208.24	207.45	208.07	8684564.0
2015-04-08 12:00:00	SPY	ETF	208.08	208.13	207.8	207.89	5368867.0
2015-04-08 13:00:00	SPY	ETF	207.9	208.03	207.64	207.95	4136483.0
2015-04-08 14:00:00	SPY	ETF	207.95	208.45	207.08	207.79	19712331.0
2015-04-08 15:00:00	SPY	ETF	207.79	208.08	207.6	207.99	19168686.0
2015-04-08 16:00:00	SPY	ETF	207.99	208.18	207.7545	208.15	7083567.0
2015-04-08 17:00:00	SPY	ETF	208.17	208.34	208.16	208.3	140645.0
2015-04-08 18:00:00	SPY	ETF	208.3	208.3	208.18	208.2	62297.0
2015-04-08 19:00:00	SPY	ETF	208.2	208.2	208.16	208.17	18170.0
2015-04-08 04:00:00	QQQ	ETF	106.0	106.0	105.9	105.9	400.0
2015-04-08 07:00:00	QQQ	ETF	105.81	105.96	105.76	105.9	172827.0
2015-04-08 08:00:00	QQQ	ETF	105.95	105.98	105.85	105.9	27026.0
2015-04-08 09:00:00	QQQ	ETF	105.92	106.61	105.82	106.58	3437199.0
2015-04-08 10:00:00	QQQ	ETF	106.59	106.65	105.95	106.235	3732000.0
2015-04-08 11:00:00	QQQ	ETF	106.235	106.64	106.14	106.551	3392280.0
2015-04-08 12:00:00	QQQ	ETF	106.56	106.62	106.42	106.45	1196520.0
2015-04-08 13:00:00	QQQ	ETF	106.45	106.54	106.31	106.49	1101578.0
2015-04-08 14:00:00	QQQ	ETF	106.48	106.79	106.01	106.39	4865763.0
2015-04-08 15:00:00	QQQ	ETF	106.39	106.65	106.28	106.64	6143039.0
2015-04-08 16:00:00	QQQ	ETF	106.66	106.81	106.63	106.8	361066.0
2015-04-08 17:00:00	QQQ	ETF	106.79	106.85	106.79	106.82	52127.0
2015-04-08 18:00:00	QQQ	ETF	106.82	106.83	106.79	106.79	11266.0
2015-04-08 19:00:00	QQQ	ETF	106.79	106.8	106.76	106.77	15150.0
2015-04-08 06:00:00	IWM	ETF	124.45	124.45	124.45	124.45	100.0
2015-04-08 07:00:00	IWM	ETF	124.38	124.46	124.36	124.37	89049.0
2015-04-08 08:00:00	IWM	ETF	124.38	124.43	124.23	124.32	69853.0
2015-04-08 09:00:00	IWM	ETF	124.35	125.34	124.35	125.15	2507201.0
2015-04-08 10:00:00	IWM	ETF	125.15	125.21	124.61	124.97	2740269.0
2015-04-08 11:00:00	IWM	ETF	124.96	125.44	124.88	125.3	2316078.0
2015-04-08 12:00:00	IWM	ETF	125.3	125.37	125.11	125.27	1147967.0
2015-04-08 13:00:00	IWM	ETF	125.28	125.37	125.145	125.33	982678.0
2015-04-08 14:00:00	IWM	ETF	125.34	125.66	124.87	125.085	3526771.0
2015-04-08 15:00:00	IWM	ETF	125.09	125.45	125.04	125.44	3342847.0
2015-04-08 16:00:00	IWM	ETF	125.44	125.54	125.42	125.46	678154.0
2015-04-08 17:00:00	IWM	ETF	125.46	125.54	125.44	125.52	12760.0
2015-04-08 19:00:00	IWM	ETF	125.51	125.51	125.51	125.51	1500.0
2015-04-08 04:00:00	DIA	ETF	178.6	178.6	178.6	178.6	300.0
2015-04-08 06:00:00	DIA	ETF	178.43	178.43	178.43	178.43	100.0
2015-04-08 07:00:00	DIA	ETF	178.65	178.65	178.6	178.6	400.0
2015-04-08 08:00:00	DIA	ETF	178.66	178.67	178.6	178.6	1350.0
2015-04-08 09:00:00	DIA	ETF	178.55	179.54	178.55	179.42	677341.0
2015-04-08 10:00:00	DIA	ETF	179.43	179.56	178.33	178.68	761991.0
2015-04-08 11:00:00	DIA	ETF	178.66	179.06	178.54	178.94	379387.0

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

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