PREVIEW / etf_1hour / 2021-02-19

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-19.parquet
  size:    423 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-02-19 04:00:00	SPY	ETF	391.08	392.03	390.74	391.59	37853.0
2021-02-19 05:00:00	SPY	ETF	391.69	392.17	391.22	391.94	38672.0
2021-02-19 06:00:00	SPY	ETF	391.89	391.93	391.3	391.44	37114.0
2021-02-19 07:00:00	SPY	ETF	391.34	392.51	391.34	392.14	363989.0
2021-02-19 08:00:00	SPY	ETF	391.6701	392.76	390.0	392.59	396225.0
2021-02-19 09:00:00	SPY	ETF	392.57	392.57	391.06	392.01	4124514.0
2021-02-19 10:00:00	SPY	ETF	392.03	392.165	391.3	392.0	4714936.0
2021-02-19 11:00:00	SPY	ETF	392.0011	392.38	391.71	391.75	3284742.0
2021-02-19 12:00:00	SPY	ETF	391.75	391.81	390.1022	390.61	8936433.0
2021-02-19 13:00:00	SPY	ETF	390.6	390.87	389.85	390.82	5464474.0
2021-02-19 14:00:00	SPY	ETF	390.8242	391.05	389.66	390.4	5087876.0
2021-02-19 15:00:00	SPY	ETF	390.39	390.94	389.55	390.02	13537073.0
2021-02-19 16:00:00	SPY	ETF	390.02	390.07	389.36	389.6	8716874.0
2021-02-19 17:00:00	SPY	ETF	389.65	390.03	389.37	389.68	249309.0
2021-02-19 18:00:00	SPY	ETF	389.61	390.03	389.46	389.56	73033.0
2021-02-19 19:00:00	SPY	ETF	389.65	389.78	389.56	389.7	22695.0
2021-02-19 04:00:00	QQQ	ETF	332.69	333.64	332.56	333.3	49437.0
2021-02-19 05:00:00	QQQ	ETF	333.28	333.75	332.95	333.7	34005.0
2021-02-19 06:00:00	QQQ	ETF	333.8	333.8	333.31	333.46	28226.0
2021-02-19 07:00:00	QQQ	ETF	333.44	334.27	333.44	334.099	279534.0
2021-02-19 08:00:00	QQQ	ETF	334.1	334.62	331.6	334.59	232588.0
2021-02-19 09:00:00	QQQ	ETF	334.55	334.55	332.55	333.28	2894598.0
2021-02-19 10:00:00	QQQ	ETF	333.29	333.53	332.25	333.4	3032378.0
2021-02-19 11:00:00	QQQ	ETF	333.39	333.955	333.08	333.11	1739519.0
2021-02-19 12:00:00	QQQ	ETF	333.09	333.25	330.46	331.12	4148549.0
2021-02-19 13:00:00	QQQ	ETF	331.12	331.46	329.97	331.31	3124690.0
2021-02-19 14:00:00	QQQ	ETF	331.31	331.67	330.39	331.3	2379428.0
2021-02-19 15:00:00	QQQ	ETF	331.29	331.78	330.59	331.04	4386166.0
2021-02-19 16:00:00	QQQ	ETF	331.0	331.9185	330.65	330.87	1679763.0
2021-02-19 17:00:00	QQQ	ETF	330.99	331.06	330.83	331.0	275315.0
2021-02-19 18:00:00	QQQ	ETF	330.99	331.05	330.9301	331.0	11354.0
2021-02-19 19:00:00	QQQ	ETF	331.0	331.05	330.85	330.97	16733.0
2021-02-19 04:00:00	IWM	ETF	220.97	222.63	220.97	222.5	26435.0
2021-02-19 05:00:00	IWM	ETF	222.64	222.97	222.44	222.69	21533.0
2021-02-19 06:00:00	IWM	ETF	222.64	222.64	222.09	222.33	31068.0
2021-02-19 07:00:00	IWM	ETF	222.36	223.17	222.28	222.78	63574.0
2021-02-19 08:00:00	IWM	ETF	222.74	223.12	220.7	222.84	96407.0
2021-02-19 09:00:00	IWM	ETF	222.85	223.82	222.17	223.7	3077997.0
2021-02-19 10:00:00	IWM	ETF	223.69	225.2	223.39	225.065	2602592.0
2021-02-19 11:00:00	IWM	ETF	225.07	226.3	225.07	225.76	2639318.0
2021-02-19 12:00:00	IWM	ETF	225.74	226.15	224.24	224.74	2347352.0
2021-02-19 13:00:00	IWM	ETF	224.74	225.74	224.28	225.65	1377957.0
2021-02-19 14:00:00	IWM	ETF	225.68	225.84	224.63	224.93	1679783.0
2021-02-19 15:00:00	IWM	ETF	224.92	225.23	224.24	225.15	5485258.0
2021-02-19 16:00:00	IWM	ETF	225.19	225.23	224.63	224.7	2051489.0
2021-02-19 17:00:00	IWM	ETF	224.82	225.19	224.42	224.56	236054.0
2021-02-19 18:00:00	IWM	ETF	224.75	225.19	224.65	224.99	18175.0
2021-02-19 19:00:00	IWM	ETF	225.08	225.08	224.76	225.06	8191.0
2021-02-19 04:00:00	DIA	ETF	314.9	315.13	314.9	315.0	700.0
2021-02-19 05:00:00	DIA	ETF	315.4	315.43	315.37	315.43	558.0

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

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