PREVIEW / etf_1hour / 2018-05-17

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-17.parquet
  size:    294 KB
  rows:    9,651

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-05-17 04:00:00	SPY	ETF	271.95	271.95	271.65	271.65	4709.0
2018-05-17 05:00:00	SPY	ETF	271.78	272.01	271.77	271.91	6125.0
2018-05-17 06:00:00	SPY	ETF	272.06	272.06	271.8	271.8	92250.0
2018-05-17 07:00:00	SPY	ETF	271.78	271.96	271.71	271.76	201050.0
2018-05-17 08:00:00	SPY	ETF	271.75	272.37	271.54	271.84	446883.0
2018-05-17 09:00:00	SPY	ETF	271.85	272.08	271.38	271.875	4823840.0
2018-05-17 10:00:00	SPY	ETF	271.88	273.23	271.87	273.14	7944027.0
2018-05-17 11:00:00	SPY	ETF	273.14	273.2	272.53	272.56	5358416.0
2018-05-17 12:00:00	SPY	ETF	272.5589	272.84	272.1	272.28	4458803.0
2018-05-17 13:00:00	SPY	ETF	272.26	272.49	271.465	271.52	4711013.0
2018-05-17 14:00:00	SPY	ETF	271.52	272.22	271.13	272.19	9474815.0
2018-05-17 15:00:00	SPY	ETF	272.19	272.34	271.67	272.01	12108943.0
2018-05-17 16:00:00	SPY	ETF	272.04	272.06	271.85	271.91	5178899.0
2018-05-17 17:00:00	SPY	ETF	271.95	272.01	271.86	271.91	40877.0
2018-05-17 18:00:00	SPY	ETF	271.9	272.4	271.68	272.12	120605.0
2018-05-17 19:00:00	SPY	ETF	272.17	272.32	272.01	272.24	23620.0
2018-05-17 04:00:00	QQQ	ETF	168.52	168.52	168.33	168.36	7587.0
2018-05-17 05:00:00	QQQ	ETF	168.34	168.45	168.34	168.45	2200.0
2018-05-17 06:00:00	QQQ	ETF	168.5	168.53	168.32	168.32	18400.0
2018-05-17 07:00:00	QQQ	ETF	168.34	168.51	168.28	168.35	186140.0
2018-05-17 08:00:00	QQQ	ETF	168.35	168.49	168.06	168.26	424205.0
2018-05-17 09:00:00	QQQ	ETF	168.26	168.7	168.26	168.46	2167130.0
2018-05-17 10:00:00	QQQ	ETF	168.47	169.61	168.45	169.55	5696452.0
2018-05-17 11:00:00	QQQ	ETF	169.55	169.56	168.97	168.98	2041518.0
2018-05-17 12:00:00	QQQ	ETF	168.98	169.19	168.45	168.54	1788718.0
2018-05-17 13:00:00	QQQ	ETF	168.5201	168.7	167.88	167.91	2375813.0
2018-05-17 14:00:00	QQQ	ETF	167.88	168.54	167.51	168.51	3731947.0
2018-05-17 15:00:00	QQQ	ETF	168.52	168.64	168.18	168.32	3827229.0
2018-05-17 16:00:00	QQQ	ETF	168.32	168.37	168.2	168.2	1027771.0
2018-05-17 17:00:00	QQQ	ETF	168.2	168.31	168.13	168.18	42882.0
2018-05-17 18:00:00	QQQ	ETF	168.13	168.52	168.0	168.4	45986.0
2018-05-17 19:00:00	QQQ	ETF	168.39	168.49	168.3	168.46	12017.0
2018-05-17 04:00:00	IWM	ETF	160.74	160.78	160.74	160.78	700.0
2018-05-17 05:00:00	IWM	ETF	160.91	160.91	160.9	160.9	2969.0
2018-05-17 06:00:00	IWM	ETF	160.99	160.99	160.86	160.91	2697.0
2018-05-17 07:00:00	IWM	ETF	160.89	160.92	160.76	160.76	116435.0
2018-05-17 08:00:00	IWM	ETF	160.75	160.96	160.72	160.95	180525.0
2018-05-17 09:00:00	IWM	ETF	160.98	161.49	160.75	161.4	1822239.0
2018-05-17 10:00:00	IWM	ETF	161.41	162.0	161.35	161.9	2616593.0
2018-05-17 11:00:00	IWM	ETF	161.91	161.98	161.67	161.77	1249744.0
2018-05-17 12:00:00	IWM	ETF	161.77	161.91	161.57	161.64	1718765.0
2018-05-17 13:00:00	IWM	ETF	161.63	161.78	161.27	161.37	1218212.0
2018-05-17 14:00:00	IWM	ETF	161.34	161.87	161.03	161.855	2603229.0
2018-05-17 15:00:00	IWM	ETF	161.86	162.0	161.63	161.66	3895519.0
2018-05-17 16:00:00	IWM	ETF	161.66	161.79	161.6	161.7	1095006.0
2018-05-17 17:00:00	IWM	ETF	161.75	161.75	161.67	161.67	3371.0
2018-05-17 18:00:00	IWM	ETF	161.67	162.0	161.64	161.85	18325.0
2018-05-17 19:00:00	IWM	ETF	161.88	161.88	161.74	161.86	5710.0
2018-05-17 04:00:00	DIA	ETF	247.59	247.59	247.57	247.57	200.0
2018-05-17 05:00:00	DIA	ETF	247.74	247.86	247.74	247.86	725.0

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

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