PREVIEW / etf_1hour / 2021-03-30

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-30.parquet
  size:    408 KB
  rows:    14,261

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-03-30 04:00:00	SPY	ETF	395.5	395.62	395.1	395.31	9820.0
2021-03-30 05:00:00	SPY	ETF	395.26	395.6	395.18	395.59	18352.0
2021-03-30 06:00:00	SPY	ETF	395.58	395.78	394.91	395.03	141135.0
2021-03-30 07:00:00	SPY	ETF	395.04	395.04	393.98	394.15	203419.0
2021-03-30 08:00:00	SPY	ETF	394.7201	396.769	393.93	394.23	311795.0
2021-03-30 09:00:00	SPY	ETF	394.2	394.73	393.43	394.09	7015260.0
2021-03-30 10:00:00	SPY	ETF	394.09	394.84	393.02	394.27	10603125.0
2021-03-30 11:00:00	SPY	ETF	394.265	394.94	393.94	394.04	6530132.0
2021-03-30 12:00:00	SPY	ETF	394.03	394.3	393.48	393.96	4544414.0
2021-03-30 13:00:00	SPY	ETF	393.97	394.35	393.4	394.0	3860318.0
2021-03-30 14:00:00	SPY	ETF	394.0	395.2	393.69	395.1214	5607986.0
2021-03-30 15:00:00	SPY	ETF	395.12	395.45	393.42	394.78	16243912.0
2021-03-30 16:00:00	SPY	ETF	394.77	394.86	394.37	394.5	4228367.0
2021-03-30 17:00:00	SPY	ETF	394.52	394.53	394.35	394.45	96526.0
2021-03-30 18:00:00	SPY	ETF	394.45	394.73	393.89	394.12	124641.0
2021-03-30 19:00:00	SPY	ETF	394.08	394.8	393.95	394.63	58247.0
2021-03-30 04:00:00	QQQ	ETF	314.4	314.4	313.49	313.9	59698.0
2021-03-30 05:00:00	QQQ	ETF	313.85	314.56	313.79	314.43	35975.0
2021-03-30 06:00:00	QQQ	ETF	314.36	314.59	313.26	313.69	79758.0
2021-03-30 07:00:00	QQQ	ETF	313.84	313.85	313.08	313.25	259591.0
2021-03-30 08:00:00	QQQ	ETF	313.27	315.48	312.99	313.6	303236.0
2021-03-30 09:00:00	QQQ	ETF	313.61	314.23	312.22	312.89	5807440.0
2021-03-30 10:00:00	QQQ	ETF	312.87	313.91	311.54	313.56	7573298.0
2021-03-30 11:00:00	QQQ	ETF	313.56	314.91	313.14	313.53	5138304.0
2021-03-30 12:00:00	QQQ	ETF	313.52	313.84	312.86	313.29	2624239.0
2021-03-30 13:00:00	QQQ	ETF	313.3	314.035	312.72	313.36	2731666.0
2021-03-30 14:00:00	QQQ	ETF	313.365	314.49	312.94	314.38	3188813.0
2021-03-30 15:00:00	QQQ	ETF	314.38	314.86	313.06	314.4	5793995.0
2021-03-30 16:00:00	QQQ	ETF	314.38	314.53	314.0	314.24	1369601.0
2021-03-30 17:00:00	QQQ	ETF	314.23	314.32	314.1	314.13	11582.0
2021-03-30 18:00:00	QQQ	ETF	314.25	314.29	313.55	313.84	108638.0
2021-03-30 19:00:00	QQQ	ETF	313.72	314.5	313.65	314.37	53564.0
2021-03-30 04:00:00	IWM	ETF	215.5	215.63	214.92	215.15	15662.0
2021-03-30 05:00:00	IWM	ETF	215.12	215.36	215.12	215.3	6415.0
2021-03-30 06:00:00	IWM	ETF	215.3	215.3	214.59	214.8	16500.0
2021-03-30 07:00:00	IWM	ETF	214.8	214.8	213.16	213.49	171950.0
2021-03-30 08:00:00	IWM	ETF	213.46	215.56	213.34	214.01	158798.0
2021-03-30 09:00:00	IWM	ETF	213.9999	215.12	213.1399	214.6085	2495535.0
2021-03-30 10:00:00	IWM	ETF	214.62	217.04	214.175	216.96	5761530.0
2021-03-30 11:00:00	IWM	ETF	216.995	218.19	216.49	216.63	4241774.0
2021-03-30 12:00:00	IWM	ETF	216.62	218.02	216.51	217.7	2314374.0
2021-03-30 13:00:00	IWM	ETF	217.71	217.7201	216.43	216.44	2315810.0
2021-03-30 14:00:00	IWM	ETF	216.44	218.28	216.17	218.23	1999320.0
2021-03-30 15:00:00	IWM	ETF	218.24	218.68	217.29	218.04	4748504.0
2021-03-30 16:00:00	IWM	ETF	218.03	218.39	217.84	218.17	2046905.0
2021-03-30 17:00:00	IWM	ETF	218.05	218.12	218.01	218.03	15442.0
2021-03-30 18:00:00	IWM	ETF	218.03	218.19	217.7	217.96	26997.0
2021-03-30 19:00:00	IWM	ETF	217.94	218.7	217.89	218.62	52910.0
2021-03-30 04:00:00	DIA	ETF	332.07	332.2	332.07	332.08	796.0
2021-03-30 06:00:00	DIA	ETF	332.21	332.3	331.8	331.83	8502.0

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

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