PREVIEW / etf_1hour / 2021-02-18

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-18.parquet
  size:    419 KB
  rows:    14,576

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-18 04:00:00	SPY	ETF	392.16	392.16	391.09	391.5	10390.0
2021-02-18 05:00:00	SPY	ETF	391.54	391.58	390.94	391.02	13749.0
2021-02-18 06:00:00	SPY	ETF	391.02	391.02	390.18	390.95	139417.0
2021-02-18 07:00:00	SPY	ETF	391.04	391.32	390.87	391.05	273635.0
2021-02-18 08:00:00	SPY	ETF	391.0601	391.87	389.58	389.85	978450.0
2021-02-18 09:00:00	SPY	ETF	389.85	390.29	388.89	389.83	6087212.0
2021-02-18 10:00:00	SPY	ETF	389.82	389.87	387.74	388.992	9934857.0
2021-02-18 11:00:00	SPY	ETF	388.985	389.86	388.68	388.93	4433941.0
2021-02-18 12:00:00	SPY	ETF	388.93	389.43	388.2	389.165	3238079.0
2021-02-18 13:00:00	SPY	ETF	389.1619	390.54	388.82	390.255	4402768.0
2021-02-18 14:00:00	SPY	ETF	390.259	391.13	390.23	391.05	5631079.0
2021-02-18 15:00:00	SPY	ETF	391.04	391.515	390.39	390.75	9141676.0
2021-02-18 16:00:00	SPY	ETF	390.76	391.04	390.51	390.7	3070641.0
2021-02-18 17:00:00	SPY	ETF	390.57	390.77	390.57	390.74	57057.0
2021-02-18 18:00:00	SPY	ETF	390.74	391.03	390.04	390.2	159433.0
2021-02-18 19:00:00	SPY	ETF	390.22	390.4999	390.14	390.45	35979.0
2021-02-18 04:00:00	QQQ	ETF	332.7	332.75	331.94	332.28	35241.0
2021-02-18 05:00:00	QQQ	ETF	332.23	332.31	331.64	331.73	32813.0
2021-02-18 06:00:00	QQQ	ETF	331.6	331.66	330.82	331.5	87076.0
2021-02-18 07:00:00	QQQ	ETF	331.5	331.88	331.4	331.61	100013.0
2021-02-18 08:00:00	QQQ	ETF	331.3504	332.54	330.41	330.63	497853.0
2021-02-18 09:00:00	QQQ	ETF	330.58	331.13	329.69	330.78	3843078.0
2021-02-18 10:00:00	QQQ	ETF	330.74	330.8049	328.36	329.81	5586885.0
2021-02-18 11:00:00	QQQ	ETF	329.81	330.851	329.48	329.9099	2487970.0
2021-02-18 12:00:00	QQQ	ETF	329.905	330.76	329.04	330.51	1716903.0
2021-02-18 13:00:00	QQQ	ETF	330.51	331.87	330.072	331.55	2103559.0
2021-02-18 14:00:00	QQQ	ETF	331.5599	332.685	331.5	332.58	2286853.0
2021-02-18 15:00:00	QQQ	ETF	332.578	333.209	332.18	332.44	4064086.0
2021-02-18 16:00:00	QQQ	ETF	332.43	332.71	331.7509	332.49	1624351.0
2021-02-18 17:00:00	QQQ	ETF	332.49	332.49	331.81	332.34	57702.0
2021-02-18 18:00:00	QQQ	ETF	332.38	332.87	331.7	331.9499	136966.0
2021-02-18 19:00:00	QQQ	ETF	331.89	332.09	331.72	332.09	58650.0
2021-02-18 04:00:00	IWM	ETF	223.94	223.99	223.55	223.55	4685.0
2021-02-18 05:00:00	IWM	ETF	223.91	223.91	223.38	223.55	10400.0
2021-02-18 06:00:00	IWM	ETF	223.43	223.43	222.83	223.27	42598.0
2021-02-18 07:00:00	IWM	ETF	223.3	223.62	223.11	223.38	81056.0
2021-02-18 08:00:00	IWM	ETF	223.21	223.54	222.25	222.37	141193.0
2021-02-18 09:00:00	IWM	ETF	222.29	222.67	221.57	222.2	2052202.0
2021-02-18 10:00:00	IWM	ETF	222.15	222.15	219.385	220.37	4602137.0
2021-02-18 11:00:00	IWM	ETF	220.37	222.9	220.055	220.31	2880680.0
2021-02-18 12:00:00	IWM	ETF	220.31	220.75	219.79	220.025	1495806.0
2021-02-18 13:00:00	IWM	ETF	220.01	221.36	219.64	220.93	1757410.0
2021-02-18 14:00:00	IWM	ETF	220.91	221.78	220.91	221.365	1361802.0
2021-02-18 15:00:00	IWM	ETF	221.365	221.78	220.32	220.52	3568191.0
2021-02-18 16:00:00	IWM	ETF	220.59	220.96	220.56	220.68	1772191.0
2021-02-18 17:00:00	IWM	ETF	220.76	220.8	220.6	220.61	10773.0
2021-02-18 18:00:00	IWM	ETF	220.61	221.0	220.31	220.51	33767.0
2021-02-18 19:00:00	IWM	ETF	220.45	220.62	220.45	220.53	20842.0
2021-02-18 04:00:00	DIA	ETF	316.6	316.6	316.6	316.6	175.0
2021-02-18 05:00:00	DIA	ETF	316.09	316.09	315.95	315.95	524.0

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

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