PREVIEW / etf_1hour / 2021-05-28

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-28.parquet
  size:    403 KB
  rows:    14,080

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-05-28 04:00:00	SPY	ETF	420.95	421.1	420.95	421.07	4702.0
2021-05-28 05:00:00	SPY	ETF	421.13	421.24	420.95	421.16	14892.0
2021-05-28 06:00:00	SPY	ETF	421.22	421.39	421.04	421.36	30965.0
2021-05-28 07:00:00	SPY	ETF	421.35	421.43	421.0	421.0	125701.0
2021-05-28 08:00:00	SPY	ETF	421.36	421.42	420.52	420.61	253057.0
2021-05-28 09:00:00	SPY	ETF	420.61	421.09	420.34	420.87	4682861.0
2021-05-28 10:00:00	SPY	ETF	420.86	421.04	419.9655	420.4681	5424609.0
2021-05-28 11:00:00	SPY	ETF	420.465	421.04	420.35	420.95	3490601.0
2021-05-28 12:00:00	SPY	ETF	420.95	421.25	420.835	420.89	2783212.0
2021-05-28 13:00:00	SPY	ETF	420.88	421.0036	420.5301	420.69	3575159.0
2021-05-28 14:00:00	SPY	ETF	420.695	420.91	420.47	420.7689	3842033.0
2021-05-28 15:00:00	SPY	ETF	420.77	420.96	419.79	420.03	14802011.0
2021-05-28 16:00:00	SPY	ETF	420.03	420.35	419.8372	420.04	3682665.0
2021-05-28 17:00:00	SPY	ETF	420.02	420.17	419.98	420.12	560308.0
2021-05-28 18:00:00	SPY	ETF	420.05	420.12	419.95	420.0	20878.0
2021-05-28 19:00:00	SPY	ETF	419.98	420.05	419.95	420.04	9120.0
2021-05-28 04:00:00	QQQ	ETF	333.51	334.02	333.51	333.95	14468.0
2021-05-28 05:00:00	QQQ	ETF	333.96	334.37	333.86	334.24	13569.0
2021-05-28 06:00:00	QQQ	ETF	334.36	334.66	334.19	334.65	145851.0
2021-05-28 07:00:00	QQQ	ETF	334.65	334.65	334.26	334.43	137879.0
2021-05-28 08:00:00	QQQ	ETF	334.38	334.58	333.32	333.73	273495.0
2021-05-28 09:00:00	QQQ	ETF	333.7	334.985	333.68	334.599	2947632.0
2021-05-28 10:00:00	QQQ	ETF	334.59	334.82	333.91	334.39	3198365.0
2021-05-28 11:00:00	QQQ	ETF	334.4	335.24	334.23	335.22	2263662.0
2021-05-28 12:00:00	QQQ	ETF	335.235	335.5699	335.13	335.39	1762484.0
2021-05-28 13:00:00	QQQ	ETF	335.4	335.51	334.18	334.43	2346886.0
2021-05-28 14:00:00	QQQ	ETF	334.43	334.96	334.21	334.785	2180536.0
2021-05-28 15:00:00	QQQ	ETF	334.78	334.81	333.6	333.79	5052837.0
2021-05-28 16:00:00	QQQ	ETF	333.8	333.99	332.9169	333.73	1562242.0
2021-05-28 17:00:00	QQQ	ETF	333.7	333.84	333.7	333.82	7963.0
2021-05-28 18:00:00	QQQ	ETF	333.82	333.82	333.72	333.79	3951.0
2021-05-28 19:00:00	QQQ	ETF	333.79	333.85	333.75	333.8001	10325.0
2021-05-28 04:00:00	IWM	ETF	226.73	227.1	226.72	227.1	7680.0
2021-05-28 05:00:00	IWM	ETF	227.07	227.1	226.88	226.92	4846.0
2021-05-28 06:00:00	IWM	ETF	227.1	227.17	226.88	227.0	79600.0
2021-05-28 07:00:00	IWM	ETF	227.0	227.12	226.95	226.96	105463.0
2021-05-28 08:00:00	IWM	ETF	226.99	227.09	226.75	226.82	151669.0
2021-05-28 09:00:00	IWM	ETF	226.82	227.19	225.9	226.55	2566299.0
2021-05-28 10:00:00	IWM	ETF	226.55	226.63	225.05	225.48	2820973.0
2021-05-28 11:00:00	IWM	ETF	225.49	226.01	225.48	225.8	1595804.0
2021-05-28 12:00:00	IWM	ETF	225.8	226.09	225.37	225.8783	1010603.0
2021-05-28 13:00:00	IWM	ETF	225.88	226.32	225.88	225.97	977856.0
2021-05-28 14:00:00	IWM	ETF	225.97	226.115	225.5	225.51	1141220.0
2021-05-28 15:00:00	IWM	ETF	225.52	225.8	225.16	225.6002	3726195.0
2021-05-28 16:00:00	IWM	ETF	225.6	225.73	225.41	225.57	1641345.0
2021-05-28 17:00:00	IWM	ETF	225.84	225.84	225.5	225.6	174749.0
2021-05-28 18:00:00	IWM	ETF	225.67	225.67	225.6	225.6	600.0
2021-05-28 19:00:00	IWM	ETF	225.6	225.65	225.6	225.6	2913.0
2021-05-28 04:00:00	DIA	ETF	346.49	346.64	346.49	346.59	2680.0
2021-05-28 05:00:00	DIA	ETF	346.62	346.62	346.62	346.62	200.0

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

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