PREVIEW / etf_1hour / 2020-02-27

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-27.parquet
  size:    409 KB
  rows:    13,794

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-02-27 04:00:00	SPY	ETF	309.38	310.41	308.93	309.07	117825.0
2020-02-27 05:00:00	SPY	ETF	309.23	309.5	307.85	307.85	139538.0
2020-02-27 06:00:00	SPY	ETF	307.9	308.79	307.6	307.98	293568.0
2020-02-27 07:00:00	SPY	ETF	307.98	308.47	306.65	306.76	1340860.0
2020-02-27 08:00:00	SPY	ETF	307.95	309.78	306.11	306.23	2256968.0
2020-02-27 09:00:00	SPY	ETF	306.23	307.1	303.35	305.15	34789728.0
2020-02-27 10:00:00	SPY	ETF	305.14	311.5637	300.65	305.53	43926314.0
2020-02-27 11:00:00	SPY	ETF	305.53	307.0	303.645	306.57	29347314.0
2020-02-27 12:00:00	SPY	ETF	306.54	311.5637	306.07	307.828	31166851.0
2020-02-27 13:00:00	SPY	ETF	307.81	309.28	303.69	304.52	33720126.0
2020-02-27 14:00:00	SPY	ETF	304.48	311.5637	303.08	303.19	24873130.0
2020-02-27 15:00:00	SPY	ETF	303.2	304.35	297.52	297.55	54129062.0
2020-02-27 16:00:00	SPY	ETF	297.52	304.163	294.57	295.04	20453681.0
2020-02-27 17:00:00	SPY	ETF	295.06	297.51	294.75	295.1	1470037.0
2020-02-27 18:00:00	SPY	ETF	295.06	297.24	293.62	296.85	1927860.0
2020-02-27 19:00:00	SPY	ETF	296.8	297.35	295.55	296.9	468182.0
2020-02-27 04:00:00	QQQ	ETF	214.57	215.59	214.2	214.47	110047.0
2020-02-27 05:00:00	QQQ	ETF	214.58	214.77	213.5	213.5	135321.0
2020-02-27 06:00:00	QQQ	ETF	213.61	214.5	213.34	213.65	235396.0
2020-02-27 07:00:00	QQQ	ETF	213.59	213.92	212.13	212.18	971606.0
2020-02-27 08:00:00	QQQ	ETF	212.17	216.48	211.5	211.73	1395358.0
2020-02-27 09:00:00	QQQ	ETF	211.79	212.62	209.79	211.365	15067568.0
2020-02-27 10:00:00	QQQ	ETF	211.36	212.03	207.7	211.29	17414913.0
2020-02-27 11:00:00	QQQ	ETF	211.28	212.93	209.87	212.0672	13296298.0
2020-02-27 12:00:00	QQQ	ETF	212.05	214.37	211.58	212.96	9970852.0
2020-02-27 13:00:00	QQQ	ETF	212.9474	214.03	209.95	210.65	9928548.0
2020-02-27 14:00:00	QQQ	ETF	210.63	211.09	209.31	209.37	7863843.0
2020-02-27 15:00:00	QQQ	ETF	209.37	210.49	205.5	205.6	17867459.0
2020-02-27 16:00:00	QQQ	ETF	205.58	210.5455	203.23	203.51	5036234.0
2020-02-27 17:00:00	QQQ	ETF	203.42	205.64	203.42	203.82	164171.0
2020-02-27 18:00:00	QQQ	ETF	203.61	205.47	202.74	205.14	512025.0
2020-02-27 19:00:00	QQQ	ETF	205.2	205.5	204.25	205.15	778889.0
2020-02-27 04:00:00	IWM	ETF	153.66	153.69	153.39	153.39	8123.0
2020-02-27 05:00:00	IWM	ETF	153.3	153.3	152.73	152.73	11863.0
2020-02-27 06:00:00	IWM	ETF	152.5	152.92	152.5	152.7	2300.0
2020-02-27 07:00:00	IWM	ETF	152.7	152.9	152.23	152.37	107099.0
2020-02-27 08:00:00	IWM	ETF	152.54	152.6502	151.9	151.9699	365310.0
2020-02-27 09:00:00	IWM	ETF	152.05	152.06	149.8	150.86	6056905.0
2020-02-27 10:00:00	IWM	ETF	150.82	151.58	148.815	151.58	6070931.0
2020-02-27 11:00:00	IWM	ETF	151.57	153.07	151.46	152.99	5457709.0
2020-02-27 12:00:00	IWM	ETF	152.99	155.01	152.79	153.95	6591907.0
2020-02-27 13:00:00	IWM	ETF	153.92	154.63	152.02	152.31	4036143.0
2020-02-27 14:00:00	IWM	ETF	152.29	152.56	151.41	151.71	4648092.0
2020-02-27 15:00:00	IWM	ETF	151.69	152.26	148.92	149.06	7142725.0
2020-02-27 16:00:00	IWM	ETF	149.04	154.5669	147.5	147.5	1479339.0
2020-02-27 17:00:00	IWM	ETF	147.93	149.06	147.51	147.82	75236.0
2020-02-27 18:00:00	IWM	ETF	147.71	149.06	146.98	148.6	171295.0
2020-02-27 19:00:00	IWM	ETF	148.69	148.78	148.03	148.51	706764.0
2020-02-27 04:00:00	DIA	ETF	268.52	268.77	267.78	267.78	11531.0
2020-02-27 05:00:00	DIA	ETF	267.7	268.16	266.44	266.44	7100.0

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

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