PREVIEW / etf_1hour / 2021-01-27

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-27.parquet
  size:    431 KB
  rows:    15,265

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
2021-01-27 04:00:00	SPY	ETF	383.25	383.79	383.22	383.39	16129.0
2021-01-27 05:00:00	SPY	ETF	383.3	383.34	382.61	382.61	43213.0
2021-01-27 06:00:00	SPY	ETF	382.65	382.65	379.73	380.69	510243.0
2021-01-27 07:00:00	SPY	ETF	380.78	381.2	378.86	379.02	980067.0
2021-01-27 08:00:00	SPY	ETF	378.95	383.41	378.76	379.95	1396925.0
2021-01-27 09:00:00	SPY	ETF	380.01	380.32	375.63	377.57	13353503.0
2021-01-27 10:00:00	SPY	ETF	377.57	379.92	377.2	379.75	9769635.0
2021-01-27 11:00:00	SPY	ETF	379.76	379.77	376.16	376.28	7311756.0
2021-01-27 12:00:00	SPY	ETF	376.26	378.74	375.91	378.65	6793859.0
2021-01-27 13:00:00	SPY	ETF	378.65	378.89	377.04	377.39	4596849.0
2021-01-27 14:00:00	SPY	ETF	377.39	378.16	373.63	374.07	13204394.0
2021-01-27 15:00:00	SPY	ETF	374.06	375.165	372.01	374.44	28648352.0
2021-01-27 16:00:00	SPY	ETF	374.44	375.24	370.0	372.98	8040647.0
2021-01-27 17:00:00	SPY	ETF	373.1162	374.41	372.13	372.86	241994.0
2021-01-27 18:00:00	SPY	ETF	372.95	374.41	370.06	370.55	452977.0
2021-01-27 19:00:00	SPY	ETF	370.82	372.46	370.82	372.26	321006.0
2021-01-27 04:00:00	QQQ	ETF	329.93	330.58	329.93	330.23	33854.0
2021-01-27 05:00:00	QQQ	ETF	330.13	330.28	329.61	329.63	43972.0
2021-01-27 06:00:00	QQQ	ETF	329.56	329.6	327.78	327.8	279163.0
2021-01-27 07:00:00	QQQ	ETF	327.8	328.53	325.6	325.6	845527.0
2021-01-27 08:00:00	QQQ	ETF	325.51	330.5	325.46	326.44	1561800.0
2021-01-27 09:00:00	QQQ	ETF	326.44	326.6	321.0	323.67	7374496.0
2021-01-27 10:00:00	QQQ	ETF	323.665	326.18	323.25	325.71	4403597.0
2021-01-27 11:00:00	QQQ	ETF	325.7	325.74	322.0311	322.14	3195869.0
2021-01-27 12:00:00	QQQ	ETF	322.12	324.83	321.81	324.6	2968186.0
2021-01-27 13:00:00	QQQ	ETF	324.63	324.9	322.9918	323.37	2327496.0
2021-01-27 14:00:00	QQQ	ETF	323.34	324.2168	319.38	319.76	5783755.0
2021-01-27 15:00:00	QQQ	ETF	319.74	320.44	317.36	319.75	10549249.0
2021-01-27 16:00:00	QQQ	ETF	319.75	320.64	314.06	318.38	3676598.0
2021-01-27 17:00:00	QQQ	ETF	318.5	319.43	317.17	317.53	123933.0
2021-01-27 18:00:00	QQQ	ETF	317.54	319.43	315.76	316.2	338274.0
2021-01-27 19:00:00	QQQ	ETF	316.73	317.47	316.28	317.2	231631.0
2021-01-27 04:00:00	IWM	ETF	211.99	212.51	211.99	212.41	8119.0
2021-01-27 05:00:00	IWM	ETF	212.19	212.57	212.09	212.12	9861.0
2021-01-27 06:00:00	IWM	ETF	212.05	212.05	208.32	209.25	203105.0
2021-01-27 07:00:00	IWM	ETF	209.36	209.85	207.47	207.85	578408.0
2021-01-27 08:00:00	IWM	ETF	207.81	210.5096	207.51	209.28	549824.0
2021-01-27 09:00:00	IWM	ETF	209.5	209.76	207.29	209.76	6151956.0
2021-01-27 10:00:00	IWM	ETF	209.7301	211.92	209.07	211.92	5643730.0
2021-01-27 11:00:00	IWM	ETF	211.92	212.21	210.27	210.43	4708506.0
2021-01-27 12:00:00	IWM	ETF	210.41	212.82	209.64	212.79	2866731.0
2021-01-27 13:00:00	IWM	ETF	212.78	212.985	212.11	212.41	1993300.0
2021-01-27 14:00:00	IWM	ETF	212.44	212.85	208.86	209.46	4318879.0
2021-01-27 15:00:00	IWM	ETF	209.44	210.28	208.1	209.42	7206117.0
2021-01-27 16:00:00	IWM	ETF	209.39	210.09	207.95	208.33	1672001.0
2021-01-27 17:00:00	IWM	ETF	208.49	209.39	208.31	208.77	852368.0
2021-01-27 18:00:00	IWM	ETF	208.73	209.55	206.41	206.8	317969.0
2021-01-27 19:00:00	IWM	ETF	206.68	208.22	206.68	208.08	90784.0
2021-01-27 04:00:00	DIA	ETF	308.63	308.97	308.62	308.62	2300.0
2021-01-27 05:00:00	DIA	ETF	308.61	308.61	308.05	308.05	7300.0

> showing 50 of 15,265 rows — these rows as CSV

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