PREVIEW / etf_1hour / 2021-07-27

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-27.parquet
  size:    418 KB
  rows:    14,590

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-07-27 04:00:00	SPY	ETF	439.38	439.8	438.72	439.3	45096.0
2021-07-27 05:00:00	SPY	ETF	439.25	439.7	438.8	439.55	42930.0
2021-07-27 06:00:00	SPY	ETF	439.59	440.05	439.54	440.05	20365.0
2021-07-27 07:00:00	SPY	ETF	440.09	440.71	440.09	440.18	125346.0
2021-07-27 08:00:00	SPY	ETF	440.32	440.6	438.82	440.28	300318.0
2021-07-27 09:00:00	SPY	ETF	440.29	440.35	438.53	439.25	6114183.0
2021-07-27 10:00:00	SPY	ETF	439.25	439.64	437.93	438.5617	9224697.0
2021-07-27 11:00:00	SPY	ETF	438.56	439.09	436.76	437.61	8387518.0
2021-07-27 12:00:00	SPY	ETF	437.6	437.61	436.37	436.81	5445828.0
2021-07-27 13:00:00	SPY	ETF	436.795	437.2	435.99	436.339	4614041.0
2021-07-27 14:00:00	SPY	ETF	436.33	438.06	436.28	438.025	5523081.0
2021-07-27 15:00:00	SPY	ETF	438.02	439.06	437.69	438.99	11524652.0
2021-07-27 16:00:00	SPY	ETF	438.99	439.02	437.73	437.77	3008423.0
2021-07-27 17:00:00	SPY	ETF	437.72	437.99	437.11	437.41	100894.0
2021-07-27 18:00:00	SPY	ETF	437.45	439.01	437.45	438.44	67018.0
2021-07-27 19:00:00	SPY	ETF	438.44	438.74	438.27	438.74	41161.0
2021-07-27 04:00:00	QQQ	ETF	368.0	368.0	367.27	367.59	29046.0
2021-07-27 05:00:00	QQQ	ETF	367.51	368.12	367.41	368.03	21538.0
2021-07-27 06:00:00	QQQ	ETF	368.05	368.28	367.96	368.28	16979.0
2021-07-27 07:00:00	QQQ	ETF	368.29	368.82	368.29	368.51	95878.0
2021-07-27 08:00:00	QQQ	ETF	367.9804	368.8	367.13	368.62	203937.0
2021-07-27 09:00:00	QQQ	ETF	368.57	368.57	366.52	366.65	4184841.0
2021-07-27 10:00:00	QQQ	ETF	366.65	367.038	362.8675	363.52	8971721.0
2021-07-27 11:00:00	QQQ	ETF	363.47	364.08	361.22	362.16	7374223.0
2021-07-27 12:00:00	QQQ	ETF	362.15	362.25	360.87	361.29	6232689.0
2021-07-27 13:00:00	QQQ	ETF	361.26	361.61	360.16	360.98	5758699.0
2021-07-27 14:00:00	QQQ	ETF	360.97	363.7472	360.97	363.715	5513081.0
2021-07-27 15:00:00	QQQ	ETF	363.71	364.52	363.051	364.44	6704184.0
2021-07-27 16:00:00	QQQ	ETF	364.45	364.87	362.34	362.77	2388022.0
2021-07-27 17:00:00	QQQ	ETF	362.81	362.81	361.8	362.38	209963.0
2021-07-27 18:00:00	QQQ	ETF	362.48	363.76	362.48	363.62	211929.0
2021-07-27 19:00:00	QQQ	ETF	363.6	363.81	363.44	363.74	157464.0
2021-07-27 04:00:00	IWM	ETF	218.59	219.02	218.0	218.53	24000.0
2021-07-27 05:00:00	IWM	ETF	218.41	218.87	218.18	218.79	8711.0
2021-07-27 06:00:00	IWM	ETF	218.8	219.25	218.75	219.11	24698.0
2021-07-27 07:00:00	IWM	ETF	219.2	219.75	219.13	219.18	77505.0
2021-07-27 08:00:00	IWM	ETF	219.4801	219.6299	218.33	218.86	323178.0
2021-07-27 09:00:00	IWM	ETF	218.89	219.2	216.77	216.86	4380389.0
2021-07-27 10:00:00	IWM	ETF	216.86	217.65	215.945	217.31	6155669.0
2021-07-27 11:00:00	IWM	ETF	217.29	217.62	215.3819	216.51	4323871.0
2021-07-27 12:00:00	IWM	ETF	216.5	216.68	215.61	216.06	3207843.0
2021-07-27 13:00:00	IWM	ETF	216.04	216.55	215.45	216.22	2375257.0
2021-07-27 14:00:00	IWM	ETF	216.22	217.44	216.11	217.35	2753339.0
2021-07-27 15:00:00	IWM	ETF	217.35	217.8	217.0	217.63	3880650.0
2021-07-27 16:00:00	IWM	ETF	217.62	218.31	217.19	217.25	1944997.0
2021-07-27 17:00:00	IWM	ETF	217.1	217.37	216.77	217.0	56890.0
2021-07-27 18:00:00	IWM	ETF	217.15	217.52	217.0	217.47	77796.0
2021-07-27 19:00:00	IWM	ETF	217.51	217.79	217.46	217.73	109799.0
2021-07-27 04:00:00	DIA	ETF	349.76	350.11	349.23	349.39	1624.0
2021-07-27 05:00:00	DIA	ETF	349.61	349.66	349.61	349.66	200.0

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

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