PREVIEW / etf_1hour / 2021-07-12

all etf 1-hour files

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

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-12 04:00:00	SPY	ETF	433.95	435.68	433.8	434.9	20621.0
2021-07-12 05:00:00	SPY	ETF	434.75	434.75	434.35	434.57	7540.0
2021-07-12 06:00:00	SPY	ETF	434.48	434.48	433.83	433.92	136654.0
2021-07-12 07:00:00	SPY	ETF	433.94	434.97	433.94	434.68	148587.0
2021-07-12 08:00:00	SPY	ETF	434.3201	435.4	434.06	435.38	244199.0
2021-07-12 09:00:00	SPY	ETF	435.43	435.935	434.97	435.93	4700123.0
2021-07-12 10:00:00	SPY	ETF	435.94	436.74	435.6209	436.62	5540567.0
2021-07-12 11:00:00	SPY	ETF	436.62	436.66	436.07	436.59	3963230.0
2021-07-12 12:00:00	SPY	ETF	436.585	436.73	436.38	436.53	2536299.0
2021-07-12 13:00:00	SPY	ETF	436.5311	436.8	436.41	436.5699	2098577.0
2021-07-12 14:00:00	SPY	ETF	436.56	437.1	436.5201	436.88	4337880.0
2021-07-12 15:00:00	SPY	ETF	436.87	437.35	436.75	437.08	11987366.0
2021-07-12 16:00:00	SPY	ETF	437.08	437.5	437.04	437.05	4454891.0
2021-07-12 17:00:00	SPY	ETF	437.01	437.19	436.96	437.08	87893.0
2021-07-12 18:00:00	SPY	ETF	437.15	437.15	436.84	436.84	49593.0
2021-07-12 19:00:00	SPY	ETF	436.86	437.24	436.85	437.18	21825.0
2021-07-12 04:00:00	QQQ	ETF	358.77	361.99	358.77	361.9	35720.0
2021-07-12 05:00:00	QQQ	ETF	361.77	362.0	361.57	361.65	41553.0
2021-07-12 06:00:00	QQQ	ETF	361.68	361.83	361.08	361.61	38026.0
2021-07-12 07:00:00	QQQ	ETF	361.58	361.99	361.57	361.82	73199.0
2021-07-12 08:00:00	QQQ	ETF	361.76	362.63	360.8	362.63	147132.0
2021-07-12 09:00:00	QQQ	ETF	362.63	362.89	361.145	361.48	4015966.0
2021-07-12 10:00:00	QQQ	ETF	361.48	362.03	360.83	361.81	3747058.0
2021-07-12 11:00:00	QQQ	ETF	361.8	362.15	361.345	361.7599	1938324.0
2021-07-12 12:00:00	QQQ	ETF	361.76	361.945	361.51	361.69	1372338.0
2021-07-12 13:00:00	QQQ	ETF	361.71	361.765	361.32	361.65	1465856.0
2021-07-12 14:00:00	QQQ	ETF	361.64	362.26	361.59	362.005	1730160.0
2021-07-12 15:00:00	QQQ	ETF	362.01	362.53	361.9018	362.41	4132850.0
2021-07-12 16:00:00	QQQ	ETF	362.41	362.75	362.41	362.59	1890630.0
2021-07-12 17:00:00	QQQ	ETF	362.74	362.74	362.51	362.57	13311.0
2021-07-12 18:00:00	QQQ	ETF	362.6	362.63	362.42	362.42	26048.0
2021-07-12 19:00:00	QQQ	ETF	362.41	362.72	362.41	362.67	37265.0
2021-07-12 04:00:00	IWM	ETF	225.15	225.56	225.12	225.46	4955.0
2021-07-12 05:00:00	IWM	ETF	225.18	225.23	224.81	224.98	32382.0
2021-07-12 06:00:00	IWM	ETF	224.86	225.0	224.25	224.45	37648.0
2021-07-12 07:00:00	IWM	ETF	224.48	225.49	224.48	225.23	58985.0
2021-07-12 08:00:00	IWM	ETF	225.24	226.4	224.73	225.72	106075.0
2021-07-12 09:00:00	IWM	ETF	225.77	225.92	224.55	225.395	2676907.0
2021-07-12 10:00:00	IWM	ETF	225.41	225.8781	224.76	225.67	2462488.0
2021-07-12 11:00:00	IWM	ETF	225.68	226.14	225.2	226.07	1704260.0
2021-07-12 12:00:00	IWM	ETF	226.075	226.17	225.42	225.65	1696518.0
2021-07-12 13:00:00	IWM	ETF	225.65	226.125	225.35	226.0	986727.0
2021-07-12 14:00:00	IWM	ETF	225.99	226.8881	225.3	226.63	1394538.0
2021-07-12 15:00:00	IWM	ETF	226.63	226.79	226.245	226.64	2527697.0
2021-07-12 16:00:00	IWM	ETF	226.57	226.81	226.5	226.57	736189.0
2021-07-12 17:00:00	IWM	ETF	226.51	226.68	226.49	226.65	1270.0
2021-07-12 18:00:00	IWM	ETF	226.62	226.62	226.3	226.3	19717.0
2021-07-12 19:00:00	IWM	ETF	226.379	226.59	226.33	226.59	54855.0
2021-07-12 04:00:00	DIA	ETF	347.3	347.9	347.29	347.64	1471.0
2021-07-12 05:00:00	DIA	ETF	347.54	347.68	347.1	347.68	9724.0

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

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