PREVIEW / etf_1hour / 2021-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-28.parquet
  size:    408 KB
  rows:    14,298

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-04-28 04:00:00	SPY	ETF	417.52	417.87	417.42	417.87	19471.0
2021-04-28 05:00:00	SPY	ETF	417.69	417.93	417.65	417.79	8583.0
2021-04-28 06:00:00	SPY	ETF	417.78	417.98	417.7	417.9	26899.0
2021-04-28 07:00:00	SPY	ETF	417.87	418.08	417.19	417.46	150114.0
2021-04-28 08:00:00	SPY	ETF	417.9101	418.07	417.36	417.68	74022.0
2021-04-28 09:00:00	SPY	ETF	417.71	418.41	417.32	418.38	4411563.0
2021-04-28 10:00:00	SPY	ETF	418.39	418.45	417.74	418.0319	4764832.0
2021-04-28 11:00:00	SPY	ETF	418.035	418.105	417.23	417.2919	3821334.0
2021-04-28 12:00:00	SPY	ETF	417.3	417.89	417.12	417.809	2325492.0
2021-04-28 13:00:00	SPY	ETF	417.81	417.84	417.23	417.31	2331672.0
2021-04-28 14:00:00	SPY	ETF	417.31	419.01	416.9	418.33	9117762.0
2021-04-28 15:00:00	SPY	ETF	418.33	418.54	417.02	417.35	12001361.0
2021-04-28 16:00:00	SPY	ETF	417.35	418.39	416.97	418.08	2654667.0
2021-04-28 17:00:00	SPY	ETF	418.0	418.0	417.76	418.0	172964.0
2021-04-28 18:00:00	SPY	ETF	418.0	418.26	417.4	418.22	123891.0
2021-04-28 19:00:00	SPY	ETF	418.22	418.5	418.16	418.47	38647.0
2021-04-28 04:00:00	QQQ	ETF	339.79	339.9	339.38	339.83	19885.0
2021-04-28 05:00:00	QQQ	ETF	339.86	339.86	339.36	339.51	40020.0
2021-04-28 06:00:00	QQQ	ETF	339.5	339.84	339.5	339.79	38861.0
2021-04-28 07:00:00	QQQ	ETF	339.77	340.09	339.3	339.49	299580.0
2021-04-28 08:00:00	QQQ	ETF	339.85	340.52	339.37	339.59	212923.0
2021-04-28 09:00:00	QQQ	ETF	339.58	340.64	338.51	340.63	4415970.0
2021-04-28 10:00:00	QQQ	ETF	340.64	340.81	338.87	339.4213	4250719.0
2021-04-28 11:00:00	QQQ	ETF	339.43	339.61	338.56	338.6225	2546282.0
2021-04-28 12:00:00	QQQ	ETF	338.62	339.45	338.3301	339.3072	1698720.0
2021-04-28 13:00:00	QQQ	ETF	339.315	339.48	338.93	338.98	1253999.0
2021-04-28 14:00:00	QQQ	ETF	339.03	340.85	338.42	340.155	5440672.0
2021-04-28 15:00:00	QQQ	ETF	340.17	340.32	338.5	338.74	4577828.0
2021-04-28 16:00:00	QQQ	ETF	338.76	341.09	338.581	340.55	1408446.0
2021-04-28 17:00:00	QQQ	ETF	340.55	340.84	338.66	340.51	1872346.0
2021-04-28 18:00:00	QQQ	ETF	340.48	340.53	340.13	340.37	124455.0
2021-04-28 19:00:00	QQQ	ETF	340.39	340.64	340.33	340.64	45784.0
2021-04-28 04:00:00	IWM	ETF	228.2	228.2	227.89	228.09	11229.0
2021-04-28 05:00:00	IWM	ETF	228.2	228.31	228.0	228.31	9715.0
2021-04-28 06:00:00	IWM	ETF	228.21	228.21	227.97	228.12	10300.0
2021-04-28 07:00:00	IWM	ETF	228.1	228.23	226.9	227.34	51728.0
2021-04-28 08:00:00	IWM	ETF	228.2001	228.28	227.24	228.06	61373.0
2021-04-28 09:00:00	IWM	ETF	228.08	228.25	227.1	227.58	2107056.0
2021-04-28 10:00:00	IWM	ETF	227.57	228.655	227.14	228.58	2193259.0
2021-04-28 11:00:00	IWM	ETF	228.58	228.61	228.02	228.15	1294510.0
2021-04-28 12:00:00	IWM	ETF	228.16	228.52	227.87	228.24	681026.0
2021-04-28 13:00:00	IWM	ETF	228.2478	228.66	228.17	228.35	812495.0
2021-04-28 14:00:00	IWM	ETF	228.37	229.49	228.05	229.205	2250579.0
2021-04-28 15:00:00	IWM	ETF	229.2	229.4	228.38	228.86	2375661.0
2021-04-28 16:00:00	IWM	ETF	228.84	229.12	227.81	228.11	400422.0
2021-04-28 17:00:00	IWM	ETF	228.19	228.84	228.13	228.4	30055.0
2021-04-28 18:00:00	IWM	ETF	228.31	228.84	228.2	228.52	12707.0
2021-04-28 19:00:00	IWM	ETF	228.45	228.69	228.4	228.69	10296.0
2021-04-28 04:00:00	DIA	ETF	339.07	339.43	339.01	339.43	470.0
2021-04-28 05:00:00	DIA	ETF	339.39	339.45	339.39	339.45	1754.0

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

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