PREVIEW / etf_1hour / 2021-09-09

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-09.parquet
  size:    420 KB
  rows:    14,480

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-09-09 04:00:00	SPY	ETF	450.3	450.3	449.54	449.56	29702.0
2021-09-09 05:00:00	SPY	ETF	449.5	450.1	449.3	449.86	12142.0
2021-09-09 06:00:00	SPY	ETF	449.85	449.93	449.59	449.69	41188.0
2021-09-09 07:00:00	SPY	ETF	449.72	450.69	449.42	450.63	147937.0
2021-09-09 08:00:00	SPY	ETF	450.68	451.208	448.3	450.68	437743.0
2021-09-09 09:00:00	SPY	ETF	450.73	452.02	450.48	451.8	4598616.0
2021-09-09 10:00:00	SPY	ETF	451.8	452.57	451.61	451.87	5660842.0
2021-09-09 11:00:00	SPY	ETF	451.87	451.97	450.75	451.22	4751503.0
2021-09-09 12:00:00	SPY	ETF	451.22	451.25	450.45	450.585	3789628.0
2021-09-09 13:00:00	SPY	ETF	450.585	451.05	448.97	449.32	7635082.0
2021-09-09 14:00:00	SPY	ETF	449.3199	449.92	448.72	449.81	5974758.0
2021-09-09 15:00:00	SPY	ETF	449.81	450.14	448.74	448.96	11306541.0
2021-09-09 16:00:00	SPY	ETF	448.96	450.8912	448.38	448.72	2740415.0
2021-09-09 17:00:00	SPY	ETF	448.73	449.08	448.53	448.9	279747.0
2021-09-09 18:00:00	SPY	ETF	448.89	448.98	448.55	448.84	339145.0
2021-09-09 19:00:00	SPY	ETF	448.83	448.93	448.57	448.79	46576.0
2021-09-09 04:00:00	QQQ	ETF	380.25	380.25	379.7	379.7	24230.0
2021-09-09 05:00:00	QQQ	ETF	379.65	380.22	379.65	379.99	13734.0
2021-09-09 06:00:00	QQQ	ETF	380.03	380.12	379.92	379.97	15469.0
2021-09-09 07:00:00	QQQ	ETF	380.02	380.95	379.67	380.85	179157.0
2021-09-09 08:00:00	QQQ	ETF	380.87	381.11	379.32	380.83	265275.0
2021-09-09 09:00:00	QQQ	ETF	380.85	382.15	380.82	381.75	3117573.0
2021-09-09 10:00:00	QQQ	ETF	381.74	382.14	381.27	381.465	2961550.0
2021-09-09 11:00:00	QQQ	ETF	381.47	381.63	380.575	381.02	3045263.0
2021-09-09 12:00:00	QQQ	ETF	381.0222	381.2601	380.67	380.765	1705440.0
2021-09-09 13:00:00	QQQ	ETF	380.775	381.2201	379.29	379.815	3956640.0
2021-09-09 14:00:00	QQQ	ETF	379.8397	380.36	379.41	380.25	2754424.0
2021-09-09 15:00:00	QQQ	ETF	380.27	380.47	379.22	379.43	4503678.0
2021-09-09 16:00:00	QQQ	ETF	379.43	379.49	379.0	379.39	758497.0
2021-09-09 17:00:00	QQQ	ETF	379.41	379.5	379.25	379.43	40247.0
2021-09-09 18:00:00	QQQ	ETF	379.43	379.52	379.2	379.37	38562.0
2021-09-09 19:00:00	QQQ	ETF	379.39	379.48	379.25	379.42	34733.0
2021-09-09 04:00:00	IWM	ETF	222.59	223.07	222.59	222.64	5400.0
2021-09-09 05:00:00	IWM	ETF	222.57	223.04	222.43	222.8	6054.0
2021-09-09 06:00:00	IWM	ETF	222.88	222.99	222.6	222.65	6391.0
2021-09-09 07:00:00	IWM	ETF	222.71	223.5	222.5	223.43	60017.0
2021-09-09 08:00:00	IWM	ETF	223.49	223.94	222.25	223.76	100739.0
2021-09-09 09:00:00	IWM	ETF	223.78	224.45	222.962	224.42	2598348.0
2021-09-09 10:00:00	IWM	ETF	224.43	226.0799	224.39	225.8699	3249842.0
2021-09-09 11:00:00	IWM	ETF	225.86	226.285	225.295	225.81	2174330.0
2021-09-09 12:00:00	IWM	ETF	225.81	225.9	225.095	225.5	1885312.0
2021-09-09 13:00:00	IWM	ETF	225.51	225.74	224.06	224.5	3196994.0
2021-09-09 14:00:00	IWM	ETF	224.5	224.75	223.9	224.5	2438930.0
2021-09-09 15:00:00	IWM	ETF	224.5	225.48	223.83	223.89	4814555.0
2021-09-09 16:00:00	IWM	ETF	223.9	224.05	223.33	223.86	1961758.0
2021-09-09 17:00:00	IWM	ETF	223.7	223.96	223.7	223.9	37191.0
2021-09-09 18:00:00	IWM	ETF	223.9	224.23	223.81	224.15	46749.0
2021-09-09 19:00:00	IWM	ETF	224.1	224.27	223.95	224.19	23513.0
2021-09-09 04:00:00	DIA	ETF	349.67	350.06	349.67	349.86	2911.0
2021-09-09 05:00:00	DIA	ETF	349.78	349.99	349.78	349.99	200.0

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

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