PREVIEW / etf_1hour / 2020-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-19.parquet
  size:    357 KB
  rows:    12,410

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-05-19 04:00:00	SPY	ETF	295.43	295.64	293.56	294.58	90204.0
2020-05-19 05:00:00	SPY	ETF	294.63	294.74	293.8	294.15	59925.0
2020-05-19 06:00:00	SPY	ETF	294.06	294.3	293.42	293.95	139051.0
2020-05-19 07:00:00	SPY	ETF	293.92	295.15	293.92	294.43	405686.0
2020-05-19 08:00:00	SPY	ETF	293.9896	297.5	293.5	294.57	606467.0
2020-05-19 09:00:00	SPY	ETF	294.55	294.73	293.52	294.65	9293826.0
2020-05-19 10:00:00	SPY	ETF	294.67	295.88	294.2	295.28	12187883.0
2020-05-19 11:00:00	SPY	ETF	295.27	295.9896	294.93	295.46	7646702.0
2020-05-19 12:00:00	SPY	ETF	295.45	295.68	294.73	295.215	4841430.0
2020-05-19 13:00:00	SPY	ETF	295.2	295.68	294.95	295.5	4740745.0
2020-05-19 14:00:00	SPY	ETF	295.49	296.205	293.73	294.0399	11017469.0
2020-05-19 15:00:00	SPY	ETF	294.05	295.825	291.95	292.02	29552259.0
2020-05-19 16:00:00	SPY	ETF	292.03	292.39	291.81	292.14	12647421.0
2020-05-19 17:00:00	SPY	ETF	291.95	292.15	291.6	291.7	635153.0
2020-05-19 18:00:00	SPY	ETF	291.7	292.3	291.29	292.23	563195.0
2020-05-19 19:00:00	SPY	ETF	292.2	292.89	292.2	292.69	307287.0
2020-05-19 04:00:00	QQQ	ETF	228.0	228.32	227.03	227.83	69316.0
2020-05-19 05:00:00	QQQ	ETF	227.81	227.81	227.27	227.44	22125.0
2020-05-19 06:00:00	QQQ	ETF	227.2	227.55	226.82	227.51	24133.0
2020-05-19 07:00:00	QQQ	ETF	227.31	228.18	227.31	227.7	128605.0
2020-05-19 08:00:00	QQQ	ETF	227.72	228.86	227.31	227.89	108492.0
2020-05-19 09:00:00	QQQ	ETF	227.9098	228.93	227.32	228.72	4064657.0
2020-05-19 10:00:00	QQQ	ETF	228.7201	229.3804	228.51	229.29	6810904.0
2020-05-19 11:00:00	QQQ	ETF	229.27	229.58	228.81	229.17	3654266.0
2020-05-19 12:00:00	QQQ	ETF	229.21	229.34	228.62	229.29	1988325.0
2020-05-19 13:00:00	QQQ	ETF	229.275	229.65	228.99	229.52	1752940.0
2020-05-19 14:00:00	QQQ	ETF	229.515	229.85	228.11	228.2799	3763154.0
2020-05-19 15:00:00	QQQ	ETF	228.285	229.6	226.71	226.75	8418625.0
2020-05-19 16:00:00	QQQ	ETF	226.75	227.09	226.59	226.93	1102530.0
2020-05-19 17:00:00	QQQ	ETF	226.78	226.96	226.6	226.74	52363.0
2020-05-19 18:00:00	QQQ	ETF	226.66	227.15	226.4	227.05	141406.0
2020-05-19 19:00:00	QQQ	ETF	227.1	227.52	227.1	227.48	131666.0
2020-05-19 04:00:00	IWM	ETF	132.78	133.05	131.77	132.17	8525.0
2020-05-19 05:00:00	IWM	ETF	132.2	132.2	131.7	131.82	16123.0
2020-05-19 06:00:00	IWM	ETF	131.82	131.82	131.22	131.67	23376.0
2020-05-19 07:00:00	IWM	ETF	131.68	132.52	131.65	132.27	63660.0
2020-05-19 08:00:00	IWM	ETF	131.89	134.68	131.67	132.3	108721.0
2020-05-19 09:00:00	IWM	ETF	132.35	132.7	131.02	131.86	3056669.0
2020-05-19 10:00:00	IWM	ETF	131.86	133.06	131.84	132.69	3582705.0
2020-05-19 11:00:00	IWM	ETF	132.68	133.25	132.43	132.8	2140101.0
2020-05-19 12:00:00	IWM	ETF	132.82	133.11	132.34	132.85	1567339.0
2020-05-19 13:00:00	IWM	ETF	132.85	133.025	132.615	132.93	1086922.0
2020-05-19 14:00:00	IWM	ETF	132.93	133.45	131.44	131.63	3088796.0
2020-05-19 15:00:00	IWM	ETF	131.65	133.18	130.055	130.11	9629710.0
2020-05-19 16:00:00	IWM	ETF	130.12	130.4	130.0	130.11	1703352.0
2020-05-19 17:00:00	IWM	ETF	130.26	130.26	129.81	129.85	73095.0
2020-05-19 18:00:00	IWM	ETF	129.82	130.14	129.4	130.13	225861.0
2020-05-19 19:00:00	IWM	ETF	130.24	130.84	130.23	130.73	120864.0
2020-05-19 04:00:00	DIA	ETF	246.26	246.26	244.88	244.88	2300.0
2020-05-19 05:00:00	DIA	ETF	245.1	245.4	245.1	245.4	3599.0

> showing 50 of 12,410 rows — these rows as CSV

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