PREVIEW / etf_1hour / 2018-11-21

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-21.parquet
  size:    313 KB
  rows:    10,320

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
2018-11-21 04:00:00	SPY	ETF	265.53	265.8	265.21	265.41	33020.0
2018-11-21 05:00:00	SPY	ETF	265.31	265.89	264.87	265.09	154397.0
2018-11-21 06:00:00	SPY	ETF	265.09	265.7	264.84	265.34	160347.0
2018-11-21 07:00:00	SPY	ETF	265.31	266.55	265.31	266.38	656091.0
2018-11-21 08:00:00	SPY	ETF	266.34	266.67	264.93	265.93	712894.0
2018-11-21 09:00:00	SPY	ETF	265.91	266.29	265.12	266.1	9308046.0
2018-11-21 10:00:00	SPY	ETF	266.11	266.65	265.65	266.17	10575103.0
2018-11-21 11:00:00	SPY	ETF	266.175	267.15	265.91	266.77	10552860.0
2018-11-21 12:00:00	SPY	ETF	266.79	266.89	266.26	266.85	4710221.0
2018-11-21 13:00:00	SPY	ETF	266.85	266.93	266.34	266.59	4196935.0
2018-11-21 14:00:00	SPY	ETF	266.59	266.71	266.18	266.2515	5303756.0
2018-11-21 15:00:00	SPY	ETF	266.25	266.71	265.01	265.07	18455966.0
2018-11-21 16:00:00	SPY	ETF	265.07	266.2609	264.8	264.94	7462954.0
2018-11-21 17:00:00	SPY	ETF	265.0	265.04	264.86	265.03	122893.0
2018-11-21 18:00:00	SPY	ETF	265.0	265.39	264.94	265.27	1627020.0
2018-11-21 19:00:00	SPY	ETF	265.23	265.35	265.19	265.35	26349.0
2018-11-21 04:00:00	QQQ	ETF	160.7	160.9	160.29	160.52	23091.0
2018-11-21 05:00:00	QQQ	ETF	160.34	160.8	159.95	160.2	30316.0
2018-11-21 06:00:00	QQQ	ETF	160.16	160.67	160.0	160.2	76047.0
2018-11-21 07:00:00	QQQ	ETF	160.14	161.33	160.14	161.14	632027.0
2018-11-21 08:00:00	QQQ	ETF	161.11	161.34	159.92	161.01	816986.0
2018-11-21 09:00:00	QQQ	ETF	160.97	161.9	160.11	161.19	7101951.0
2018-11-21 10:00:00	QQQ	ETF	161.18	161.77	160.59	161.11	7520533.0
2018-11-21 11:00:00	QQQ	ETF	161.12	161.97	160.8515	161.35	4356248.0
2018-11-21 12:00:00	QQQ	ETF	161.37	161.69	161.05	161.6411	3031633.0
2018-11-21 13:00:00	QQQ	ETF	161.641	161.729	161.17	161.5285	1959669.0
2018-11-21 14:00:00	QQQ	ETF	161.52	161.7	161.14	161.19	2031896.0
2018-11-21 15:00:00	QQQ	ETF	161.18	161.565	160.39	160.4	6301585.0
2018-11-21 16:00:00	QQQ	ETF	160.39	160.44	160.16	160.23	2057801.0
2018-11-21 17:00:00	QQQ	ETF	160.38	160.38	160.21	160.32	65413.0
2018-11-21 18:00:00	QQQ	ETF	160.35	160.6	160.35	160.52	44171.0
2018-11-21 19:00:00	QQQ	ETF	160.45	160.57	160.45	160.57	6898.0
2018-11-21 04:00:00	IWM	ETF	146.71	146.99	146.3	146.64	4211.0
2018-11-21 05:00:00	IWM	ETF	146.72	146.95	146.52	146.52	6815.0
2018-11-21 06:00:00	IWM	ETF	146.71	146.92	146.7	146.85	35500.0
2018-11-21 07:00:00	IWM	ETF	146.65	147.03	146.63	146.98	149674.0
2018-11-21 08:00:00	IWM	ETF	146.97	147.05	146.6999	146.78	47376.0
2018-11-21 09:00:00	IWM	ETF	146.64	147.72	146.53	147.71	1945387.0
2018-11-21 10:00:00	IWM	ETF	147.71	148.435	147.6	148.32	2654881.0
2018-11-21 11:00:00	IWM	ETF	148.32	149.37	148.1	148.91	3189989.0
2018-11-21 12:00:00	IWM	ETF	148.91	149.22	148.72	148.84	1919963.0
2018-11-21 13:00:00	IWM	ETF	148.86	148.99	148.5	148.64	1359728.0
2018-11-21 14:00:00	IWM	ETF	148.63	148.69	148.275	148.34	1035334.0
2018-11-21 15:00:00	IWM	ETF	148.34	148.63	147.93	147.98	2834430.0
2018-11-21 16:00:00	IWM	ETF	147.98	148.1	147.9	148.01	635409.0
2018-11-21 17:00:00	IWM	ETF	147.92	148.03	147.92	147.99	179620.0
2018-11-21 18:00:00	IWM	ETF	148.03	148.2	148.02	148.05	10192.0
2018-11-21 19:00:00	IWM	ETF	148.12	148.18	148.12	148.18	2993.0
2018-11-21 04:00:00	DIA	ETF	245.58	245.58	245.58	245.58	166.0
2018-11-21 06:00:00	DIA	ETF	245.7	245.7	245.7	245.7	100.0

> showing 50 of 10,320 rows — these rows as CSV

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