PREVIEW / etf_1hour / 2021-09-08

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-08.parquet
  size:    421 KB
  rows:    14,655

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-08 04:00:00	SPY	ETF	450.5	450.5	449.39	450.19	40255.0
2021-09-08 05:00:00	SPY	ETF	450.17	451.12	450.15	451.08	9794.0
2021-09-08 06:00:00	SPY	ETF	451.09	451.5	450.99	451.4	52833.0
2021-09-08 07:00:00	SPY	ETF	451.24	451.78	451.18	451.35	81931.0
2021-09-08 08:00:00	SPY	ETF	451.1004	451.798	449.8	451.28	242472.0
2021-09-08 09:00:00	SPY	ETF	451.34	451.43	450.35	451.26	5919043.0
2021-09-08 10:00:00	SPY	ETF	451.27	451.67	448.86	449.43	10393591.0
2021-09-08 11:00:00	SPY	ETF	449.43	450.39	449.15	449.375	6429054.0
2021-09-08 12:00:00	SPY	ETF	449.375	450.86	449.15	450.26	4578481.0
2021-09-08 13:00:00	SPY	ETF	450.27	450.76	450.06	450.33	2979706.0
2021-09-08 14:00:00	SPY	ETF	450.33	451.05	450.3	450.76	4079954.0
2021-09-08 15:00:00	SPY	ETF	450.78	451.13	450.39	450.95	7428705.0
2021-09-08 16:00:00	SPY	ETF	450.96	450.96	450.4935	450.8	1630100.0
2021-09-08 17:00:00	SPY	ETF	450.76	450.92	450.65	450.71	43738.0
2021-09-08 18:00:00	SPY	ETF	450.74	450.91	450.45	450.46	44883.0
2021-09-08 19:00:00	SPY	ETF	450.45	450.54	450.29	450.41	35684.0
2021-09-08 04:00:00	QQQ	ETF	381.55	381.55	380.65	381.18	31809.0
2021-09-08 05:00:00	QQQ	ETF	381.23	381.91	381.22	381.85	36124.0
2021-09-08 06:00:00	QQQ	ETF	381.86	382.0	381.79	381.84	54200.0
2021-09-08 07:00:00	QQQ	ETF	381.77	382.22	381.77	382.03	134912.0
2021-09-08 08:00:00	QQQ	ETF	381.83	382.23	380.54	382.02	147938.0
2021-09-08 09:00:00	QQQ	ETF	382.04	382.04	380.62	381.1601	4181596.0
2021-09-08 10:00:00	QQQ	ETF	381.17	381.74	378.72	379.1	6449406.0
2021-09-08 11:00:00	QQQ	ETF	379.08	380.085	378.5503	378.89	3522143.0
2021-09-08 12:00:00	QQQ	ETF	378.89	380.42	378.45	379.72	3444596.0
2021-09-08 13:00:00	QQQ	ETF	379.72	380.61	379.705	380.1	1945720.0
2021-09-08 14:00:00	QQQ	ETF	380.1	380.92	380.09	380.39	2002112.0
2021-09-08 15:00:00	QQQ	ETF	380.39	380.86	380.09	380.83	3492481.0
2021-09-08 16:00:00	QQQ	ETF	380.84	380.84	380.46	380.52	595630.0
2021-09-08 17:00:00	QQQ	ETF	380.47	380.52	380.42	380.47	8793.0
2021-09-08 18:00:00	QQQ	ETF	380.52	380.55	380.26	380.3	30458.0
2021-09-08 19:00:00	QQQ	ETF	380.28	380.36	380.13	380.29	40351.0
2021-09-08 04:00:00	IWM	ETF	225.5	225.5	224.5	225.16	15795.0
2021-09-08 05:00:00	IWM	ETF	225.2	226.04	225.2	226.04	5425.0
2021-09-08 06:00:00	IWM	ETF	226.04	226.41	225.92	226.33	16091.0
2021-09-08 07:00:00	IWM	ETF	226.39	226.67	226.17	226.17	97482.0
2021-09-08 08:00:00	IWM	ETF	226.16	226.7	225.08	226.0	184497.0
2021-09-08 09:00:00	IWM	ETF	226.0	226.08	225.005	225.44	2883760.0
2021-09-08 10:00:00	IWM	ETF	225.45	225.97	222.63	223.31	5991870.0
2021-09-08 11:00:00	IWM	ETF	223.31	224.108	223.08	223.3801	2566411.0
2021-09-08 12:00:00	IWM	ETF	223.38	224.62	223.23	224.16	1786987.0
2021-09-08 13:00:00	IWM	ETF	224.155	224.35	223.7	223.81	1430214.0
2021-09-08 14:00:00	IWM	ETF	223.82	224.4	223.4422	223.825	1591799.0
2021-09-08 15:00:00	IWM	ETF	223.83	224.03	223.58	223.9	3094100.0
2021-09-08 16:00:00	IWM	ETF	223.91	223.93	223.75	223.93	1018739.0
2021-09-08 17:00:00	IWM	ETF	223.79	223.92	223.79	223.91	193532.0
2021-09-08 18:00:00	IWM	ETF	223.81	223.81	223.4	223.47	40415.0
2021-09-08 19:00:00	IWM	ETF	223.35	223.59	223.33	223.38	20142.0
2021-09-08 04:00:00	DIA	ETF	350.0	350.27	349.45	350.2	3470.0
2021-09-08 05:00:00	DIA	ETF	350.0	350.71	350.0	350.71	2900.0

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

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