PREVIEW / etf_1hour / 2021-07-29

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-29.parquet
  size:    409 KB
  rows:    14,428

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-29 04:00:00	SPY	ETF	438.93	439.52	438.93	439.41	3742.0
2021-07-29 05:00:00	SPY	ETF	439.43	439.79	439.33	439.79	6773.0
2021-07-29 06:00:00	SPY	ETF	439.67	439.84	439.18	439.5	12790.0
2021-07-29 07:00:00	SPY	ETF	439.61	439.75	439.24	439.59	174453.0
2021-07-29 08:00:00	SPY	ETF	439.53	440.0	439.089	439.73	262997.0
2021-07-29 09:00:00	SPY	ETF	439.75	441.1	439.72	440.76	5488813.0
2021-07-29 10:00:00	SPY	ETF	440.76	441.5	440.38	441.5	5716573.0
2021-07-29 11:00:00	SPY	ETF	441.5	441.7	441.11	441.21	5756476.0
2021-07-29 12:00:00	SPY	ETF	441.2	441.745	441.18	441.3619	2666942.0
2021-07-29 13:00:00	SPY	ETF	441.37	441.8	441.34	441.52	2467123.0
2021-07-29 14:00:00	SPY	ETF	441.52	441.63	440.95	441.14	3098912.0
2021-07-29 15:00:00	SPY	ETF	441.15	441.155	440.65	440.68	8354554.0
2021-07-29 16:00:00	SPY	ETF	440.68	440.92	438.97	439.2	2903507.0
2021-07-29 17:00:00	SPY	ETF	439.05	440.7	438.8	438.85	394147.0
2021-07-29 18:00:00	SPY	ETF	438.85	440.65	438.85	439.12	128432.0
2021-07-29 19:00:00	SPY	ETF	439.1	439.18	438.14	438.2	66300.0
2021-07-29 04:00:00	QQQ	ETF	366.0	366.0	365.405	365.58	39811.0
2021-07-29 05:00:00	QQQ	ETF	365.6	365.85	365.49	365.84	10720.0
2021-07-29 06:00:00	QQQ	ETF	365.67	365.78	364.77	365.09	58465.0
2021-07-29 07:00:00	QQQ	ETF	365.07	365.61	365.07	365.61	160852.0
2021-07-29 08:00:00	QQQ	ETF	364.8496	366.13	364.7496	365.47	270521.0
2021-07-29 09:00:00	QQQ	ETF	365.56	367.59	365.25	366.96	3901113.0
2021-07-29 10:00:00	QQQ	ETF	366.97	367.595	366.17	367.37	3064070.0
2021-07-29 11:00:00	QQQ	ETF	367.38	367.6794	366.81	366.905	1838931.0
2021-07-29 12:00:00	QQQ	ETF	366.89	367.57	366.72	366.95	1629569.0
2021-07-29 13:00:00	QQQ	ETF	366.96	367.401	366.845	367.1901	1419153.0
2021-07-29 14:00:00	QQQ	ETF	367.21	367.33	366.6472	366.935	1863738.0
2021-07-29 15:00:00	QQQ	ETF	366.96	366.9808	366.37	366.48	3468933.0
2021-07-29 16:00:00	QQQ	ETF	366.46	366.75	363.3	363.45	2210315.0
2021-07-29 17:00:00	QQQ	ETF	363.4	363.54	363.05	363.05	116233.0
2021-07-29 18:00:00	QQQ	ETF	363.18	364.07	363.18	363.7	321493.0
2021-07-29 19:00:00	QQQ	ETF	363.72	363.74	362.31	362.47	140830.0
2021-07-29 04:00:00	IWM	ETF	221.91	222.64	221.88	222.59	14960.0
2021-07-29 05:00:00	IWM	ETF	222.6	222.92	222.5	222.89	4691.0
2021-07-29 06:00:00	IWM	ETF	223.0	223.2	222.81	223.03	37519.0
2021-07-29 07:00:00	IWM	ETF	223.07	223.16	222.77	222.83	71707.0
2021-07-29 08:00:00	IWM	ETF	223.0	223.32	222.62	222.92	153117.0
2021-07-29 09:00:00	IWM	ETF	222.88	223.515	222.14	223.05	3327030.0
2021-07-29 10:00:00	IWM	ETF	223.07	223.89	222.5	223.465	3065949.0
2021-07-29 11:00:00	IWM	ETF	223.47	224.14	223.31	224.13	2240540.0
2021-07-29 12:00:00	IWM	ETF	224.135	224.435	223.63	224.05	1815378.0
2021-07-29 13:00:00	IWM	ETF	224.05	224.375	223.62	223.77	1588781.0
2021-07-29 14:00:00	IWM	ETF	223.79	223.855	222.725	223.34	2398455.0
2021-07-29 15:00:00	IWM	ETF	223.34	223.355	222.54	222.57	3419859.0
2021-07-29 16:00:00	IWM	ETF	222.52	223.11	222.41	222.79	700671.0
2021-07-29 17:00:00	IWM	ETF	222.69	222.88	222.51	222.51	59958.0
2021-07-29 18:00:00	IWM	ETF	222.64	222.95	222.62	222.72	16925.0
2021-07-29 19:00:00	IWM	ETF	222.74	222.75	222.03	222.04	54669.0
2021-07-29 04:00:00	DIA	ETF	350.3	350.3	350.28	350.28	300.0
2021-07-29 05:00:00	DIA	ETF	350.56	350.82	350.55	350.8	3200.0

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

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