PREVIEW / etf_1hour / 2018-06-21

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-21.parquet
  size:    302 KB
  rows:    9,959

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-06-21 04:00:00	SPY	ETF	276.25	276.25	275.8	275.84	3148.0
2018-06-21 05:00:00	SPY	ETF	275.76	275.77	275.2	275.3	35446.0
2018-06-21 06:00:00	SPY	ETF	275.2	275.85	275.2	275.85	85861.0
2018-06-21 07:00:00	SPY	ETF	275.85	276.05	275.7	276.05	199195.0
2018-06-21 08:00:00	SPY	ETF	275.9501	276.96	275.59	275.73	439513.0
2018-06-21 09:00:00	SPY	ETF	275.75	275.98	275.48	275.525	5307033.0
2018-06-21 10:00:00	SPY	ETF	275.51	275.51	274.0	274.63	11777380.0
2018-06-21 11:00:00	SPY	ETF	274.62	275.31	274.42	275.05	6819064.0
2018-06-21 12:00:00	SPY	ETF	275.04	275.08	274.26	274.28	5862620.0
2018-06-21 13:00:00	SPY	ETF	274.28	274.92	274.17	274.89	6792394.0
2018-06-21 14:00:00	SPY	ETF	274.89	275.1	274.37	274.38	6261538.0
2018-06-21 15:00:00	SPY	ETF	274.38	274.66	273.68	274.23	19438419.0
2018-06-21 16:00:00	SPY	ETF	274.25	274.35	274.05	274.07	6240644.0
2018-06-21 17:00:00	SPY	ETF	274.1	274.15	273.92	273.92	256408.0
2018-06-21 18:00:00	SPY	ETF	273.99	274.16	273.92	274.12	73752.0
2018-06-21 19:00:00	SPY	ETF	274.18	274.31	274.06	274.21	36209.0
2018-06-21 04:00:00	QQQ	ETF	177.71	177.84	177.41	177.52	10200.0
2018-06-21 05:00:00	QQQ	ETF	177.51	177.51	177.0	177.01	56760.0
2018-06-21 06:00:00	QQQ	ETF	177.03	177.34	176.93	177.34	48537.0
2018-06-21 07:00:00	QQQ	ETF	177.35	177.53	177.34	177.51	76761.0
2018-06-21 08:00:00	QQQ	ETF	177.25	177.65	177.22	177.36	320812.0
2018-06-21 09:00:00	QQQ	ETF	177.33	177.88	177.09	177.45	3820157.0
2018-06-21 10:00:00	QQQ	ETF	177.45	177.45	175.57	176.26	8653900.0
2018-06-21 11:00:00	QQQ	ETF	176.26	176.97	176.075	176.75	3243299.0
2018-06-21 12:00:00	QQQ	ETF	176.74	176.76	175.7801	175.79	3249452.0
2018-06-21 13:00:00	QQQ	ETF	175.79	176.31	175.74	176.065	3264029.0
2018-06-21 14:00:00	QQQ	ETF	176.07	176.29	175.81	175.81	2298395.0
2018-06-21 15:00:00	QQQ	ETF	175.81	176.04	175.37	175.72	6533295.0
2018-06-21 16:00:00	QQQ	ETF	175.71	175.77	175.39	175.4	3358105.0
2018-06-21 17:00:00	QQQ	ETF	175.35	175.42	175.29	175.29	31890.0
2018-06-21 18:00:00	QQQ	ETF	175.35	175.41	175.25	175.39	34402.0
2018-06-21 19:00:00	QQQ	ETF	175.43	175.54	175.31	175.47	15691.0
2018-06-21 05:00:00	IWM	ETF	169.72	169.84	169.72	169.81	6000.0
2018-06-21 06:00:00	IWM	ETF	169.78	169.93	169.7	169.93	8597.0
2018-06-21 07:00:00	IWM	ETF	170.06	170.22	170.0	170.22	38266.0
2018-06-21 08:00:00	IWM	ETF	170.13	170.25	169.94	170.07	38255.0
2018-06-21 09:00:00	IWM	ETF	170.08	170.12	169.16	169.2	2257881.0
2018-06-21 10:00:00	IWM	ETF	169.2	169.22	167.96	168.81	4887370.0
2018-06-21 11:00:00	IWM	ETF	168.79	169.33	168.63	169.27	1977417.0
2018-06-21 12:00:00	IWM	ETF	169.265	169.28	168.78	168.83	1607691.0
2018-06-21 13:00:00	IWM	ETF	168.84	169.08	168.67	169.03	1827011.0
2018-06-21 14:00:00	IWM	ETF	169.03	169.26	168.6	168.61	2265668.0
2018-06-21 15:00:00	IWM	ETF	168.6	168.74	167.77	168.34	5964297.0
2018-06-21 16:00:00	IWM	ETF	168.33	168.4	168.13	168.15	1221451.0
2018-06-21 17:00:00	IWM	ETF	168.2	168.2	168.05	168.07	2681.0
2018-06-21 18:00:00	IWM	ETF	168.15	168.38	168.11	168.3	7618.0
2018-06-21 19:00:00	IWM	ETF	168.32	168.39	168.29	168.39	13323.0
2018-06-21 04:00:00	DIA	ETF	246.6	246.6	246.5	246.5	2500.0
2018-06-21 05:00:00	DIA	ETF	245.99	245.99	245.59	245.59	800.0
2018-06-21 06:00:00	DIA	ETF	245.58	245.84	245.58	245.84	300.0

> showing 50 of 9,959 rows — these rows as CSV

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