PREVIEW / etf_1hour / 2021-07-02

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-02.parquet
  size:    410 KB
  rows:    14,227

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-02 04:00:00	SPY	ETF	430.54	431.0	430.38	430.47	2967.0
2021-07-02 05:00:00	SPY	ETF	430.53	430.78	430.49	430.67	7900.0
2021-07-02 06:00:00	SPY	ETF	430.78	430.87	430.55	430.72	18003.0
2021-07-02 07:00:00	SPY	ETF	430.8	431.02	430.79	430.94	79767.0
2021-07-02 08:00:00	SPY	ETF	430.8801	431.88	430.5	431.66	780216.0
2021-07-02 09:00:00	SPY	ETF	431.66	431.99	431.33	431.81	4787602.0
2021-07-02 10:00:00	SPY	ETF	431.815	431.97	431.61	431.9	4356174.0
2021-07-02 11:00:00	SPY	ETF	431.89	432.65	431.84	432.45	4107644.0
2021-07-02 12:00:00	SPY	ETF	432.45	433.3	432.34	433.27	3427506.0
2021-07-02 13:00:00	SPY	ETF	433.2601	433.49	433.03	433.3101	4177593.0
2021-07-02 14:00:00	SPY	ETF	433.3125	433.57	433.18	433.2675	3574689.0
2021-07-02 15:00:00	SPY	ETF	433.26	434.1	433.19	433.75	15062886.0
2021-07-02 16:00:00	SPY	ETF	433.73	433.7501	433.21	433.2701	4123012.0
2021-07-02 17:00:00	SPY	ETF	433.28	433.5	433.24	433.35	39453.0
2021-07-02 18:00:00	SPY	ETF	433.36	433.4299	433.33	433.34	1533.0
2021-07-02 19:00:00	SPY	ETF	433.34	433.47	433.28	433.28	13198.0
2021-07-02 04:00:00	QQQ	ETF	355.15	355.3	354.79	354.94	16222.0
2021-07-02 05:00:00	QQQ	ETF	354.9	355.21	354.85	355.08	20920.0
2021-07-02 06:00:00	QQQ	ETF	355.16	355.34	355.04	355.24	23440.0
2021-07-02 07:00:00	QQQ	ETF	355.2	355.83	355.2	355.72	89201.0
2021-07-02 08:00:00	QQQ	ETF	355.74	356.72	355.08	356.44	729507.0
2021-07-02 09:00:00	QQQ	ETF	356.46	357.415	356.28	357.1182	4229787.0
2021-07-02 10:00:00	QQQ	ETF	357.135	357.27	356.44	356.59	3699580.0
2021-07-02 11:00:00	QQQ	ETF	356.58	357.71	356.52	357.47	2513632.0
2021-07-02 12:00:00	QQQ	ETF	357.48	357.9902	357.175	357.9899	2021909.0
2021-07-02 13:00:00	QQQ	ETF	357.9887	358.11	357.651	358.0201	2404720.0
2021-07-02 14:00:00	QQQ	ETF	358.0214	358.2	357.835	358.0118	1554278.0
2021-07-02 15:00:00	QQQ	ETF	358.014	358.97	357.915	358.65	4878184.0
2021-07-02 16:00:00	QQQ	ETF	358.64	358.64	358.26	358.29	1136328.0
2021-07-02 17:00:00	QQQ	ETF	358.4	358.5	358.37	358.48	24567.0
2021-07-02 18:00:00	QQQ	ETF	358.5	358.5	358.39	358.42	11267.0
2021-07-02 19:00:00	QQQ	ETF	358.4	358.5	358.39	358.42	6962.0
2021-07-02 04:00:00	IWM	ETF	231.39	231.4	231.0	231.0	28100.0
2021-07-02 05:00:00	IWM	ETF	231.03	231.25	230.99	231.25	9510.0
2021-07-02 06:00:00	IWM	ETF	231.26	231.26	231.08	231.24	3450.0
2021-07-02 07:00:00	IWM	ETF	231.27	231.46	231.2	231.26	33505.0
2021-07-02 08:00:00	IWM	ETF	231.4696	232.31	231.1	232.13	333478.0
2021-07-02 09:00:00	IWM	ETF	232.1	232.33	229.49	229.59	2784056.0
2021-07-02 10:00:00	IWM	ETF	229.6	229.8684	228.83	228.94	3048632.0
2021-07-02 11:00:00	IWM	ETF	228.9389	229.52	228.66	229.2599	1989155.0
2021-07-02 12:00:00	IWM	ETF	229.25	229.255	228.56	229.11	1586631.0
2021-07-02 13:00:00	IWM	ETF	229.1	229.9	229.0875	229.43	1634646.0
2021-07-02 14:00:00	IWM	ETF	229.43	229.93	229.285	229.51	1400561.0
2021-07-02 15:00:00	IWM	ETF	229.51	229.62	228.905	229.0999	3642583.0
2021-07-02 16:00:00	IWM	ETF	229.1	229.306	229.0	229.1	1154430.0
2021-07-02 17:00:00	IWM	ETF	229.19	229.27	229.19	229.19	54432.0
2021-07-02 18:00:00	IWM	ETF	229.19	229.29	229.19	229.29	1270.0
2021-07-02 19:00:00	IWM	ETF	229.29	229.29	229.19	229.19	7473.0
2021-07-02 04:00:00	DIA	ETF	346.76	346.77	346.42	346.42	400.0
2021-07-02 06:00:00	DIA	ETF	346.45	346.45	346.25	346.25	3840.0

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

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