PREVIEW / etf_1hour / 2015-06-09

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-09.parquet
  size:    240 KB
  rows:    7,672

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-09 04:00:00	SPY	ETF	208.62	208.7	208.28	208.4	30953.0
2015-06-09 05:00:00	SPY	ETF	208.38	208.38	207.5	207.62	212018.0
2015-06-09 06:00:00	SPY	ETF	207.62	208.25	207.5	208.22	133849.0
2015-06-09 07:00:00	SPY	ETF	208.22	208.34	208.05	208.25	293517.0
2015-06-09 08:00:00	SPY	ETF	208.25	209.12	208.05	208.3	480111.0
2015-06-09 09:00:00	SPY	ETF	208.29	208.82	207.91	207.98	14589629.0
2015-06-09 10:00:00	SPY	ETF	207.97	208.6	207.69	208.56	20003950.0
2015-06-09 11:00:00	SPY	ETF	208.57	208.91	208.41	208.69	13066219.0
2015-06-09 12:00:00	SPY	ETF	208.7	208.88	208.5	208.8649	6944175.0
2015-06-09 13:00:00	SPY	ETF	208.87	209.1	208.63	208.695	8557085.0
2015-06-09 14:00:00	SPY	ETF	208.695	209.02	208.64	208.76	7585134.0
2015-06-09 15:00:00	SPY	ETF	208.75	208.81	208.27	208.45	19118135.0
2015-06-09 16:00:00	SPY	ETF	208.44	208.85	208.3	208.72	8449385.0
2015-06-09 17:00:00	SPY	ETF	208.72	208.72	208.4351	208.7	2107487.0
2015-06-09 18:00:00	SPY	ETF	208.69	208.75	208.65	208.73	82241.0
2015-06-09 19:00:00	SPY	ETF	208.75	208.84	208.72	208.84	47712.0
2015-06-09 04:00:00	QQQ	ETF	108.08	108.1	108.02	108.02	7650.0
2015-06-09 05:00:00	QQQ	ETF	108.0	108.0	107.53	107.59	14917.0
2015-06-09 06:00:00	QQQ	ETF	107.68	107.91	107.6	107.9	48050.0
2015-06-09 07:00:00	QQQ	ETF	107.93	108.0	107.85	107.93	46700.0
2015-06-09 08:00:00	QQQ	ETF	107.93	107.95	107.8	107.9	154872.0
2015-06-09 09:00:00	QQQ	ETF	107.9	108.12	107.45	107.53	3648973.0
2015-06-09 10:00:00	QQQ	ETF	107.53	107.84	107.2	107.81	6386289.0
2015-06-09 11:00:00	QQQ	ETF	107.82	108.11	107.77	107.953	2481566.0
2015-06-09 12:00:00	QQQ	ETF	107.96	108.18	107.78	108.179	1433258.0
2015-06-09 13:00:00	QQQ	ETF	108.18	108.36	108.1	108.14	2272405.0
2015-06-09 14:00:00	QQQ	ETF	108.14	108.4	108.11	108.22	1726931.0
2015-06-09 15:00:00	QQQ	ETF	108.21	108.24	107.91	108.03	3826772.0
2015-06-09 16:00:00	QQQ	ETF	108.04	108.26	107.97	108.19	634628.0
2015-06-09 17:00:00	QQQ	ETF	108.2	108.2	108.17	108.2	1800.0
2015-06-09 18:00:00	QQQ	ETF	108.2	108.23	108.19	108.19	4585.0
2015-06-09 19:00:00	QQQ	ETF	108.2	108.23	108.19	108.23	4426.0
2015-06-09 05:00:00	IWM	ETF	124.5	124.5	124.1	124.1	1600.0
2015-06-09 06:00:00	IWM	ETF	124.1	124.1	124.1	124.1	100.0
2015-06-09 07:00:00	IWM	ETF	124.2	124.4	124.16	124.38	7400.0
2015-06-09 08:00:00	IWM	ETF	124.37	124.53	124.27	124.48	38155.0
2015-06-09 09:00:00	IWM	ETF	124.48	124.86	123.89	123.99	4200956.0
2015-06-09 10:00:00	IWM	ETF	123.98	124.235	123.5	124.225	3975708.0
2015-06-09 11:00:00	IWM	ETF	124.23	124.68	124.22	124.475	3910112.0
2015-06-09 12:00:00	IWM	ETF	124.495	124.58	124.25	124.58	1225766.0
2015-06-09 13:00:00	IWM	ETF	124.58	124.8	124.49	124.54	1496051.0
2015-06-09 14:00:00	IWM	ETF	124.54	124.67	124.375	124.45	1301894.0
2015-06-09 15:00:00	IWM	ETF	124.44	124.45	124.15	124.4	3674096.0
2015-06-09 16:00:00	IWM	ETF	124.41	124.62	124.34	124.61	865070.0
2015-06-09 17:00:00	IWM	ETF	124.44	124.8	124.44	124.77	17908.0
2015-06-09 18:00:00	IWM	ETF	124.4	124.53	124.4	124.5	525.0
2015-06-09 19:00:00	IWM	ETF	124.51	124.51	124.51	124.51	1500.0
2015-06-09 07:00:00	DIA	ETF	177.7	177.7	177.7	177.7	100.0
2015-06-09 08:00:00	DIA	ETF	177.81	177.85	177.59	177.64	10944.0
2015-06-09 09:00:00	DIA	ETF	177.75	178.15	177.29	177.38	756524.0

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

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