PREVIEW / etf_1hour / 2020-04-13

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-13.parquet
  size:    386 KB
  rows:    13,220

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
2020-04-13 04:00:00	SPY	ETF	274.63	274.71	274.07	274.6	77433.0
2020-04-13 05:00:00	SPY	ETF	274.6	275.19	274.58	274.71	62993.0
2020-04-13 06:00:00	SPY	ETF	274.81	275.94	274.4	275.35	131532.0
2020-04-13 07:00:00	SPY	ETF	275.35	277.1	275.35	276.98	738065.0
2020-04-13 08:00:00	SPY	ETF	276.91	278.0	274.18	277.33	1254924.0
2020-04-13 09:00:00	SPY	ETF	277.34	278.2	273.96	274.15	13677869.0
2020-04-13 10:00:00	SPY	ETF	274.15	275.59	272.1	272.7298	18669834.0
2020-04-13 11:00:00	SPY	ETF	272.76	274.1	271.41	273.6173	14738014.0
2020-04-13 12:00:00	SPY	ETF	273.6	275.07	272.94	273.27	12588979.0
2020-04-13 13:00:00	SPY	ETF	273.286	274.57	272.45	274.085	11957215.0
2020-04-13 14:00:00	SPY	ETF	274.08	274.81	272.97	274.25	10511991.0
2020-04-13 15:00:00	SPY	ETF	274.23	276.6	273.22	275.57	22587186.0
2020-04-13 16:00:00	SPY	ETF	275.58	276.33	274.0126	276.21	5912660.0
2020-04-13 17:00:00	SPY	ETF	276.25	276.5	275.66	276.4	484118.0
2020-04-13 18:00:00	SPY	ETF	276.36	277.32	275.66	276.98	336563.0
2020-04-13 19:00:00	SPY	ETF	276.99	277.13	276.7	277.08	145459.0
2020-04-13 04:00:00	QQQ	ETF	198.18	198.5	198.08	198.5	35386.0
2020-04-13 05:00:00	QQQ	ETF	198.48	199.02	198.48	198.66	22450.0
2020-04-13 06:00:00	QQQ	ETF	198.67	199.44	198.43	199.14	23905.0
2020-04-13 07:00:00	QQQ	ETF	199.09	200.34	199.02	200.21	183055.0
2020-04-13 08:00:00	QQQ	ETF	199.4601	200.65	197.73	200.23	315947.0
2020-04-13 09:00:00	QQQ	ETF	200.27	201.25	199.28	199.48	5067320.0
2020-04-13 10:00:00	QQQ	ETF	199.48	200.89	199.12	199.67	6335776.0
2020-04-13 11:00:00	QQQ	ETF	199.68	200.7851	198.75	200.315	4898799.0
2020-04-13 12:00:00	QQQ	ETF	200.315	201.24	200.07	200.34	4381216.0
2020-04-13 13:00:00	QQQ	ETF	200.32	201.5	199.86	201.22	3608582.0
2020-04-13 14:00:00	QQQ	ETF	201.22	201.65	200.57	201.52	3390891.0
2020-04-13 15:00:00	QQQ	ETF	201.53	203.42	200.9	203.04	8140360.0
2020-04-13 16:00:00	QQQ	ETF	203.04	203.55	202.88	203.52	1174181.0
2020-04-13 17:00:00	QQQ	ETF	203.55	203.6	203.03	203.57	41562.0
2020-04-13 18:00:00	QQQ	ETF	203.5	204.42	203.48	204.3	97078.0
2020-04-13 19:00:00	QQQ	ETF	204.25	204.35	204.01	204.2	54744.0
2020-04-13 04:00:00	IWM	ETF	121.54	121.54	121.0	121.29	13609.0
2020-04-13 05:00:00	IWM	ETF	121.28	121.42	121.07	121.12	20654.0
2020-04-13 06:00:00	IWM	ETF	121.12	121.4	120.88	121.07	31125.0
2020-04-13 07:00:00	IWM	ETF	121.05	122.43	121.05	122.35	199895.0
2020-04-13 08:00:00	IWM	ETF	121.9999	123.32	121.2	122.7	433926.0
2020-04-13 09:00:00	IWM	ETF	122.81	123.51	120.32	120.89	5373057.0
2020-04-13 10:00:00	IWM	ETF	120.89	122.27	120.0	120.16	5912409.0
2020-04-13 11:00:00	IWM	ETF	120.12	120.78	119.16	120.4699	3994109.0
2020-04-13 12:00:00	IWM	ETF	120.48	121.574	119.77	119.94	3982002.0
2020-04-13 13:00:00	IWM	ETF	119.93	120.579	119.115	120.18	3508452.0
2020-04-13 14:00:00	IWM	ETF	120.18	120.62	119.39	120.1404	3232582.0
2020-04-13 15:00:00	IWM	ETF	120.14	121.02	119.54	120.5	6792554.0
2020-04-13 16:00:00	IWM	ETF	120.51	121.29	120.32	121.19	1200163.0
2020-04-13 17:00:00	IWM	ETF	121.42	121.42	120.37	121.05	127191.0
2020-04-13 18:00:00	IWM	ETF	121.29	121.69	120.37	121.52	96486.0
2020-04-13 19:00:00	IWM	ETF	121.57	121.65	121.4	121.65	60719.0
2020-04-13 04:00:00	DIA	ETF	234.25	234.48	233.99	234.35	9441.0
2020-04-13 05:00:00	DIA	ETF	234.43	234.66	234.39	234.39	800.0

> showing 50 of 13,220 rows — these rows as CSV

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