PREVIEW / etf_1hour / 2021-03-17

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-17.parquet
  size:    417 KB
  rows:    14,272

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-03-17 04:00:00	SPY	ETF	395.96	396.16	395.6	395.92	8465.0
2021-03-17 05:00:00	SPY	ETF	395.79	395.99	395.64	395.64	8950.0
2021-03-17 06:00:00	SPY	ETF	395.76	396.01	395.64	395.65	19174.0
2021-03-17 07:00:00	SPY	ETF	395.58	395.64	394.36	394.56	238089.0
2021-03-17 08:00:00	SPY	ETF	395.1201	396.899	394.31	394.84	292144.0
2021-03-17 09:00:00	SPY	ETF	394.81	394.89	393.8	394.57	6832462.0
2021-03-17 10:00:00	SPY	ETF	394.58	394.98	393.42	393.65	8819808.0
2021-03-17 11:00:00	SPY	ETF	393.64	394.41	393.3	394.155	5330245.0
2021-03-17 12:00:00	SPY	ETF	394.15	394.69	393.8	393.92	4441817.0
2021-03-17 13:00:00	SPY	ETF	393.92	394.37	393.7	393.975	3881001.0
2021-03-17 14:00:00	SPY	ETF	394.0	397.79	393.975	397.66	18601464.0
2021-03-17 15:00:00	SPY	ETF	397.66	398.12	396.41	397.22	15959742.0
2021-03-17 16:00:00	SPY	ETF	397.21	397.43	396.8396	396.92	5672775.0
2021-03-17 17:00:00	SPY	ETF	396.85	397.26	396.85	396.97	112800.0
2021-03-17 18:00:00	SPY	ETF	396.97	397.7	396.97	397.42	333209.0
2021-03-17 19:00:00	SPY	ETF	397.5	398.1	397.31	398.01	122861.0
2021-03-17 04:00:00	QQQ	ETF	320.19	320.42	319.91	320.25	22316.0
2021-03-17 05:00:00	QQQ	ETF	320.2	320.34	319.66	319.69	32263.0
2021-03-17 06:00:00	QQQ	ETF	319.72	320.12	319.39	319.45	37931.0
2021-03-17 07:00:00	QQQ	ETF	319.47	319.47	316.78	317.0	475971.0
2021-03-17 08:00:00	QQQ	ETF	316.97	320.58	316.52	317.28	609125.0
2021-03-17 09:00:00	QQQ	ETF	317.31	318.34	315.68	318.15	6792150.0
2021-03-17 10:00:00	QQQ	ETF	318.1572	319.07	317.06	317.57	7731635.0
2021-03-17 11:00:00	QQQ	ETF	317.56	317.84	316.0318	316.56	6014166.0
2021-03-17 12:00:00	QQQ	ETF	316.55	317.79	315.815	316.4	5200498.0
2021-03-17 13:00:00	QQQ	ETF	316.39	317.6896	316.13	317.14	3760446.0
2021-03-17 14:00:00	QQQ	ETF	317.15	323.04	317.145	323.02	16462761.0
2021-03-17 15:00:00	QQQ	ETF	322.991	323.85	321.04	321.95	11511819.0
2021-03-17 16:00:00	QQQ	ETF	321.95	322.07	321.3	321.43	1836720.0
2021-03-17 17:00:00	QQQ	ETF	321.43	321.87	321.34	321.73	51349.0
2021-03-17 18:00:00	QQQ	ETF	321.62	322.36	321.62	321.82	126380.0
2021-03-17 19:00:00	QQQ	ETF	322.0	322.73	321.8	322.66	101704.0
2021-03-17 04:00:00	IWM	ETF	229.69	229.69	229.25	229.34	4501.0
2021-03-17 05:00:00	IWM	ETF	229.36	229.4	229.35	229.4	892.0
2021-03-17 06:00:00	IWM	ETF	229.5	229.62	229.46	229.46	5808.0
2021-03-17 07:00:00	IWM	ETF	229.32	229.42	229.0	229.08	63317.0
2021-03-17 08:00:00	IWM	ETF	229.0701	229.88	228.98	229.45	85072.0
2021-03-17 09:00:00	IWM	ETF	229.36	229.36	228.15	228.62	2829869.0
2021-03-17 10:00:00	IWM	ETF	228.6	229.0211	227.36	227.87	2641579.0
2021-03-17 11:00:00	IWM	ETF	227.88	229.3711	227.57	228.82	1754447.0
2021-03-17 12:00:00	IWM	ETF	228.81	229.42	228.54	228.89	2201974.0
2021-03-17 13:00:00	IWM	ETF	228.9	229.37	228.56	228.79	1351664.0
2021-03-17 14:00:00	IWM	ETF	229.16	232.409	228.8	232.06	5688782.0
2021-03-17 15:00:00	IWM	ETF	232.05	232.82	231.22	232.39	4920512.0
2021-03-17 16:00:00	IWM	ETF	232.31	232.38	231.83	231.89	704693.0
2021-03-17 17:00:00	IWM	ETF	231.85	232.19	231.85	232.02	12224.0
2021-03-17 18:00:00	IWM	ETF	232.12	232.62	232.01	232.34	64990.0
2021-03-17 19:00:00	IWM	ETF	232.4	232.86	232.33	232.79	31836.0
2021-03-17 04:00:00	DIA	ETF	329.5	329.5	328.78	328.78	850.0
2021-03-17 06:00:00	DIA	ETF	329.18	329.31	329.01	329.31	7000.0

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

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