PREVIEW / etf_1hour / 2021-02-24

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-24.parquet
  size:    427 KB
  rows:    14,954

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-02-24 04:00:00	SPY	ETF	387.46	388.22	387.14	388.12	35497.0
2021-02-24 05:00:00	SPY	ETF	388.31	388.46	387.87	387.99	46431.0
2021-02-24 06:00:00	SPY	ETF	388.0	388.35	387.55	387.65	86780.0
2021-02-24 07:00:00	SPY	ETF	387.6	389.37	387.6	389.05	364936.0
2021-02-24 08:00:00	SPY	ETF	389.05	389.31	385.4	386.44	708240.0
2021-02-24 09:00:00	SPY	ETF	386.44	387.1734	385.4081	386.39	9053280.0
2021-02-24 10:00:00	SPY	ETF	386.38	388.625	385.27	388.34	9806912.0
2021-02-24 11:00:00	SPY	ETF	388.35	390.07	388.26	389.9219	7476822.0
2021-02-24 12:00:00	SPY	ETF	389.92	391.21	389.92	390.485	5864493.0
2021-02-24 13:00:00	SPY	ETF	390.49	392.1101	390.17	392.0	5329165.0
2021-02-24 14:00:00	SPY	ETF	392.0	392.16	390.99	391.15	4924626.0
2021-02-24 15:00:00	SPY	ETF	391.17	392.23	391.04	391.76	11176856.0
2021-02-24 16:00:00	SPY	ETF	391.76	392.65	391.68	392.01	4297117.0
2021-02-24 17:00:00	SPY	ETF	392.1	392.1	391.78	391.83	218467.0
2021-02-24 18:00:00	SPY	ETF	391.84	393.1	391.77	392.94	176288.0
2021-02-24 19:00:00	SPY	ETF	392.94	392.96	392.37	392.63	67676.0
2021-02-24 04:00:00	QQQ	ETF	321.48	322.67	321.13	322.21	61697.0
2021-02-24 05:00:00	QQQ	ETF	322.22	322.83	321.5	322.26	86932.0
2021-02-24 06:00:00	QQQ	ETF	322.26	322.35	320.96	321.19	129103.0
2021-02-24 07:00:00	QQQ	ETF	321.25	324.13	321.23	323.76	478641.0
2021-02-24 08:00:00	QQQ	ETF	323.8	324.11	317.54	319.04	1589153.0
2021-02-24 09:00:00	QQQ	ETF	319.04	319.9	317.025	317.71	9828571.0
2021-02-24 10:00:00	QQQ	ETF	317.74	319.83	315.96	319.53	7442716.0
2021-02-24 11:00:00	QQQ	ETF	319.56	321.76	319.18	321.455	4614779.0
2021-02-24 12:00:00	QQQ	ETF	321.45	323.13	321.45	322.005	3513918.0
2021-02-24 13:00:00	QQQ	ETF	322.02	323.445	321.13	323.11	3389196.0
2021-02-24 14:00:00	QQQ	ETF	323.11	323.3	322.03	322.66	2933299.0
2021-02-24 15:00:00	QQQ	ETF	322.67	324.45	322.46	324.11	5282485.0
2021-02-24 16:00:00	QQQ	ETF	324.11	325.03	323.8056	324.57	1466711.0
2021-02-24 17:00:00	QQQ	ETF	324.57	325.0	323.8	323.85	211267.0
2021-02-24 18:00:00	QQQ	ETF	323.9	325.15	323.85	324.89	344616.0
2021-02-24 19:00:00	QQQ	ETF	324.94	325.01	324.39	324.63	80153.0
2021-02-24 04:00:00	IWM	ETF	222.0	223.38	222.0	223.38	13240.0
2021-02-24 05:00:00	IWM	ETF	223.28	223.68	222.98	223.29	14602.0
2021-02-24 06:00:00	IWM	ETF	223.23	223.52	223.14	223.52	7777.0
2021-02-24 07:00:00	IWM	ETF	223.39	224.55	223.32	224.18	131244.0
2021-02-24 08:00:00	IWM	ETF	223.78	224.4996	221.42	222.54	372070.0
2021-02-24 09:00:00	IWM	ETF	222.5	223.82	221.82	223.52	2891920.0
2021-02-24 10:00:00	IWM	ETF	223.55	224.595	221.71	224.56	3354715.0
2021-02-24 11:00:00	IWM	ETF	224.58	226.56	224.57	226.55	3169941.0
2021-02-24 12:00:00	IWM	ETF	226.531	226.955	226.17	226.17	1922806.0
2021-02-24 13:00:00	IWM	ETF	226.17	227.45	225.78	226.82	2099527.0
2021-02-24 14:00:00	IWM	ETF	226.83	226.92	225.9	226.145	1638909.0
2021-02-24 15:00:00	IWM	ETF	226.15	227.25	226.03	227.02	4639202.0
2021-02-24 16:00:00	IWM	ETF	227.0	228.12	221.6187	227.74	1399878.0
2021-02-24 17:00:00	IWM	ETF	227.92	228.41	227.0	227.63	198854.0
2021-02-24 18:00:00	IWM	ETF	227.6	228.74	227.59	228.57	49205.0
2021-02-24 19:00:00	IWM	ETF	228.66	228.78	228.13	228.54	36953.0
2021-02-24 04:00:00	DIA	ETF	315.39	315.53	315.39	315.53	2200.0
2021-02-24 06:00:00	DIA	ETF	315.75	315.75	315.49	315.49	8500.0

> showing 50 of 14,954 rows — these rows as CSV

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