PREVIEW / etf_1hour / 2015-06-08

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-08.parquet
  size:    238 KB
  rows:    7,557

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-06-08 04:00:00	SPY	ETF	209.79	209.93	209.49	209.93	30644.0
2015-06-08 05:00:00	SPY	ETF	209.91	209.91	209.62	209.68	5144.0
2015-06-08 06:00:00	SPY	ETF	209.63	209.64	209.47	209.62	41612.0
2015-06-08 07:00:00	SPY	ETF	209.7	209.76	209.52	209.63	123121.0
2015-06-08 08:00:00	SPY	ETF	209.63	209.92	209.45	209.5	322756.0
2015-06-08 09:00:00	SPY	ETF	209.49	209.82	209.17	209.33	11224916.0
2015-06-08 10:00:00	SPY	ETF	209.33	209.51	209.15	209.23	10807305.0
2015-06-08 11:00:00	SPY	ETF	209.23	209.47	208.96	209.04	10131814.0
2015-06-08 12:00:00	SPY	ETF	209.035	209.19	208.77	208.78	6740606.0
2015-06-08 13:00:00	SPY	ETF	208.78	208.88	208.42	208.69	9330586.0
2015-06-08 14:00:00	SPY	ETF	208.7	209.26	208.47	209.13	10876551.0
2015-06-08 15:00:00	SPY	ETF	209.12	209.15	208.39	208.47	18248677.0
2015-06-08 16:00:00	SPY	ETF	208.47	209.3201	208.27	208.63	6479121.0
2015-06-08 17:00:00	SPY	ETF	208.62	208.65	208.48	208.65	796462.0
2015-06-08 18:00:00	SPY	ETF	208.65	208.75	208.62	208.67	117550.0
2015-06-08 19:00:00	SPY	ETF	208.68	208.75	208.66	208.68	27371.0
2015-06-08 04:00:00	QQQ	ETF	109.36	109.36	109.36	109.36	200.0
2015-06-08 05:00:00	QQQ	ETF	109.23	109.28	109.23	109.28	729.0
2015-06-08 06:00:00	QQQ	ETF	109.28	109.28	109.23	109.23	907.0
2015-06-08 07:00:00	QQQ	ETF	109.32	109.34	109.27	109.28	10100.0
2015-06-08 08:00:00	QQQ	ETF	109.3	109.4	109.22	109.22	23581.0
2015-06-08 09:00:00	QQQ	ETF	109.2	109.33	108.84	108.91	2379861.0
2015-06-08 10:00:00	QQQ	ETF	108.9	109.01	108.73	108.7772	3141698.0
2015-06-08 11:00:00	QQQ	ETF	108.78	108.94	108.55	108.56	3226193.0
2015-06-08 12:00:00	QQQ	ETF	108.57	108.64	108.22	108.23	1476510.0
2015-06-08 13:00:00	QQQ	ETF	108.23	108.296	107.97	108.13	2795041.0
2015-06-08 14:00:00	QQQ	ETF	108.13	108.59	107.98	108.5042	3148638.0
2015-06-08 15:00:00	QQQ	ETF	108.51	108.52	108.15	108.19	3648951.0
2015-06-08 16:00:00	QQQ	ETF	108.19	108.29	108.1	108.29	589942.0
2015-06-08 17:00:00	QQQ	ETF	108.3	108.37	108.3	108.37	123600.0
2015-06-08 18:00:00	QQQ	ETF	108.37	108.38	108.28	108.34	20400.0
2015-06-08 19:00:00	QQQ	ETF	108.32	108.38	108.32	108.34	12348.0
2015-06-08 04:00:00	IWM	ETF	125.37	125.37	125.37	125.37	100.0
2015-06-08 05:00:00	IWM	ETF	125.2	125.2	125.2	125.2	100.0
2015-06-08 07:00:00	IWM	ETF	125.2	125.2	125.2	125.2	1100.0
2015-06-08 08:00:00	IWM	ETF	125.34	125.4	125.19	125.21	56654.0
2015-06-08 09:00:00	IWM	ETF	125.18	125.62	125.03	125.06	2268724.0
2015-06-08 10:00:00	IWM	ETF	125.07	125.37	124.9	125.1999	2401478.0
2015-06-08 11:00:00	IWM	ETF	125.2	125.41	124.92	124.96	1916254.0
2015-06-08 12:00:00	IWM	ETF	124.96	125.31	124.82	124.8599	1302240.0
2015-06-08 13:00:00	IWM	ETF	124.855	124.91	124.57	124.795	2232953.0
2015-06-08 14:00:00	IWM	ETF	124.8	125.22	124.62	125.14	2063040.0
2015-06-08 15:00:00	IWM	ETF	125.1328	125.15	124.68	124.82	2701362.0
2015-06-08 16:00:00	IWM	ETF	124.83	124.85	124.65	124.78	1127937.0
2015-06-08 17:00:00	IWM	ETF	124.82	124.82	124.82	124.82	10700.0
2015-06-08 18:00:00	IWM	ETF	124.82	124.82	124.82	124.82	500.0
2015-06-08 19:00:00	IWM	ETF	124.75	124.86	124.75	124.86	300.0
2015-06-08 07:00:00	DIA	ETF	178.55	178.55	178.55	178.55	200.0
2015-06-08 08:00:00	DIA	ETF	178.53	178.55	178.43	178.43	6700.0
2015-06-08 09:00:00	DIA	ETF	178.37	178.6	178.06	178.2301	697371.0

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

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