PREVIEW / etf_1hour / 2015-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-09.parquet
  size:    237 KB
  rows:    7,488

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-09 04:00:00	SPY	ETF	207.84	207.84	207.28	207.45	24568.0
2015-04-09 05:00:00	SPY	ETF	207.45	207.7	207.45	207.56	49517.0
2015-04-09 06:00:00	SPY	ETF	207.56	207.81	207.5	207.7	25528.0
2015-04-09 07:00:00	SPY	ETF	207.75	208.26	207.71	208.2	127723.0
2015-04-09 08:00:00	SPY	ETF	208.19	208.24	207.75	207.81	774347.0
2015-04-09 09:00:00	SPY	ETF	207.78	208.65	207.68	208.01	9534860.0
2015-04-09 10:00:00	SPY	ETF	208.0	208.34	207.4	207.78	17607631.0
2015-04-09 11:00:00	SPY	ETF	207.78	208.01	207.19	207.88	11713036.0
2015-04-09 12:00:00	SPY	ETF	207.88	208.32	207.83	208.29	6387112.0
2015-04-09 13:00:00	SPY	ETF	208.3	208.46	208.04	208.13	7009786.0
2015-04-09 14:00:00	SPY	ETF	208.14	208.53	208.04	208.47	6695531.0
2015-04-09 15:00:00	SPY	ETF	208.47	209.18	208.46	208.93	19989843.0
2015-04-09 16:00:00	SPY	ETF	208.94	209.15	208.094	209.0	3978094.0
2015-04-09 17:00:00	SPY	ETF	208.97	209.12	208.97	209.02	113109.0
2015-04-09 18:00:00	SPY	ETF	209.08	209.12	209.02	209.07	41899.0
2015-04-09 19:00:00	SPY	ETF	209.07	209.08	209.02	209.05	66179.0
2015-04-09 05:00:00	QQQ	ETF	106.46	106.46	106.46	106.46	15000.0
2015-04-09 06:00:00	QQQ	ETF	106.45	106.63	106.42	106.6	37230.0
2015-04-09 07:00:00	QQQ	ETF	106.56	106.81	106.55	106.79	63526.0
2015-04-09 08:00:00	QQQ	ETF	106.68	106.84	106.66	106.7	200984.0
2015-04-09 09:00:00	QQQ	ETF	106.68	107.13	106.54	106.79	3989204.0
2015-04-09 10:00:00	QQQ	ETF	106.79	106.94	106.385	106.5739	3822482.0
2015-04-09 11:00:00	QQQ	ETF	106.57	106.665	106.23	106.59	2469452.0
2015-04-09 12:00:00	QQQ	ETF	106.6	106.96	106.56	106.879	1697758.0
2015-04-09 13:00:00	QQQ	ETF	106.88	106.94	106.72	106.8	1319343.0
2015-04-09 14:00:00	QQQ	ETF	106.81	107.0	106.72	106.97	1357269.0
2015-04-09 15:00:00	QQQ	ETF	106.97	107.35	106.97	107.31	5287663.0
2015-04-09 16:00:00	QQQ	ETF	107.3	107.39	107.23	107.33	627878.0
2015-04-09 17:00:00	QQQ	ETF	107.34	107.39	107.31	107.35	54401.0
2015-04-09 18:00:00	QQQ	ETF	107.35	107.36	107.3	107.3	32185.0
2015-04-09 19:00:00	QQQ	ETF	107.3001	107.32	107.28	107.3	5136.0
2015-04-09 07:00:00	IWM	ETF	125.47	125.55	125.47	125.55	24500.0
2015-04-09 08:00:00	IWM	ETF	125.55	125.57	125.34	125.42	89695.0
2015-04-09 09:00:00	IWM	ETF	125.4	125.73	125.15	125.26	1870518.0
2015-04-09 10:00:00	IWM	ETF	125.28	125.4	124.12	124.38	4450466.0
2015-04-09 11:00:00	IWM	ETF	124.38	124.6	123.77	124.488	4789191.0
2015-04-09 12:00:00	IWM	ETF	124.48	125.12	124.43	125.07	1882550.0
2015-04-09 13:00:00	IWM	ETF	125.07	125.1	124.69	124.785	1373181.0
2015-04-09 14:00:00	IWM	ETF	124.78	124.835	124.62	124.71	1203268.0
2015-04-09 15:00:00	IWM	ETF	124.72	125.08	124.72	125.03	3353608.0
2015-04-09 16:00:00	IWM	ETF	125.02	125.25	124.98	125.25	501964.0
2015-04-09 17:00:00	IWM	ETF	125.24	125.3	125.24	125.26	4466.0
2015-04-09 18:00:00	IWM	ETF	125.16	125.16	125.16	125.16	2500.0
2015-04-09 07:00:00	DIA	ETF	178.65	178.86	178.65	178.86	800.0
2015-04-09 08:00:00	DIA	ETF	179.0	179.0	178.58	178.58	1550.0
2015-04-09 09:00:00	DIA	ETF	178.55	179.44	178.49	178.72	772777.0
2015-04-09 10:00:00	DIA	ETF	178.75	179.09	178.17	178.54	898979.0
2015-04-09 11:00:00	DIA	ETF	178.53	178.69	177.98	178.58	587430.0
2015-04-09 12:00:00	DIA	ETF	178.6	178.96	178.52	178.89	477657.0
2015-04-09 13:00:00	DIA	ETF	178.9	179.01	178.65	178.7299	398287.0

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

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