PREVIEW / etf_1hour / 2019-03-08

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-08.parquet
  size:    321 KB
  rows:    10,712

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
2019-03-08 04:00:00	SPY	ETF	274.15	274.38	274.06	274.07	7775.0
2019-03-08 05:00:00	SPY	ETF	274.01	274.26	273.75	274.23	57350.0
2019-03-08 06:00:00	SPY	ETF	274.09	274.24	273.85	273.85	18988.0
2019-03-08 07:00:00	SPY	ETF	273.94	274.15	273.77	273.77	184671.0
2019-03-08 08:00:00	SPY	ETF	273.9501	275.01	272.78	273.01	1789977.0
2019-03-08 09:00:00	SPY	ETF	273.0	273.4599	272.5	272.97	12935551.0
2019-03-08 10:00:00	SPY	ETF	272.97	273.89	272.42	273.2	14758641.0
2019-03-08 11:00:00	SPY	ETF	273.21	273.85	272.985	273.22	7881739.0
2019-03-08 12:00:00	SPY	ETF	273.22	273.285	272.49	272.55	6705048.0
2019-03-08 13:00:00	SPY	ETF	272.5585	273.18	272.5	273.02	5746831.0
2019-03-08 14:00:00	SPY	ETF	273.02	274.19	272.76	273.8	7360489.0
2019-03-08 15:00:00	SPY	ETF	273.7985	274.65	273.28	274.525	19708836.0
2019-03-08 16:00:00	SPY	ETF	274.52	275.05	274.41	275.02	6078027.0
2019-03-08 17:00:00	SPY	ETF	275.02	275.07	274.86	275.01	1451216.0
2019-03-08 18:00:00	SPY	ETF	274.93	275.0	274.89	274.96	42584.0
2019-03-08 19:00:00	SPY	ETF	274.98	275.06	274.96	275.01	32114.0
2019-03-08 04:00:00	QQQ	ETF	170.78	170.78	170.4	170.4	17195.0
2019-03-08 05:00:00	QQQ	ETF	170.45	170.56	170.24	170.45	49335.0
2019-03-08 06:00:00	QQQ	ETF	170.45	170.6	170.29	170.34	22361.0
2019-03-08 07:00:00	QQQ	ETF	170.39	170.5	170.26	170.28	96431.0
2019-03-08 08:00:00	QQQ	ETF	170.27	170.91	169.61	169.67	715467.0
2019-03-08 09:00:00	QQQ	ETF	169.63	170.17	169.25	169.84	6156169.0
2019-03-08 10:00:00	QQQ	ETF	169.83	170.6564	169.3375	170.22	6150273.0
2019-03-08 11:00:00	QQQ	ETF	170.22	170.79	170.14	170.26	4384166.0
2019-03-08 12:00:00	QQQ	ETF	170.26	170.33	169.71	169.767	2812356.0
2019-03-08 13:00:00	QQQ	ETF	169.78	170.28	169.68	170.11	2454301.0
2019-03-08 14:00:00	QQQ	ETF	170.13	170.985	169.97	170.74	3590078.0
2019-03-08 15:00:00	QQQ	ETF	170.74	171.26	170.3198	171.18	6602282.0
2019-03-08 16:00:00	QQQ	ETF	171.18	171.49	171.12	171.48	1403589.0
2019-03-08 17:00:00	QQQ	ETF	171.42	171.42	171.07	171.19	231503.0
2019-03-08 18:00:00	QQQ	ETF	171.2	171.27	171.17	171.27	7804.0
2019-03-08 19:00:00	QQQ	ETF	171.26	171.33	171.26	171.33	11295.0
2019-03-08 04:00:00	IWM	ETF	151.38	151.53	151.38	151.53	600.0
2019-03-08 05:00:00	IWM	ETF	151.33	151.5	151.31	151.5	16598.0
2019-03-08 06:00:00	IWM	ETF	151.43	151.43	151.4	151.4	3100.0
2019-03-08 07:00:00	IWM	ETF	151.45	151.51	151.26	151.26	27600.0
2019-03-08 08:00:00	IWM	ETF	151.36	151.43	150.78	151.0	308957.0
2019-03-08 09:00:00	IWM	ETF	150.9	151.53	150.61	151.19	4873273.0
2019-03-08 10:00:00	IWM	ETF	151.18	151.56	150.77	151.24	3652707.0
2019-03-08 11:00:00	IWM	ETF	151.24	151.76	150.89	150.907	1786558.0
2019-03-08 12:00:00	IWM	ETF	150.9	151.23	150.81	150.88	1063458.0
2019-03-08 13:00:00	IWM	ETF	150.88	151.22	150.87	151.1	864524.0
2019-03-08 14:00:00	IWM	ETF	151.1	151.62	150.9727	151.42	1222161.0
2019-03-08 15:00:00	IWM	ETF	151.42	151.74	150.96	151.62	3873138.0
2019-03-08 16:00:00	IWM	ETF	151.63	152.0	151.5246	151.91	731432.0
2019-03-08 17:00:00	IWM	ETF	151.91	152.04	151.84	151.84	665406.0
2019-03-08 18:00:00	IWM	ETF	151.87	151.87	151.87	151.87	100.0
2019-03-08 19:00:00	IWM	ETF	151.96	152.03	151.96	152.03	908.0
2019-03-08 04:00:00	DIA	ETF	254.1	254.2	254.1	254.2	300.0
2019-03-08 05:00:00	DIA	ETF	253.8	253.8	253.8	253.8	100.0

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

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