PREVIEW / etf_30min / 2022-03-09

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-09.parquet
  size:    683 KB
  rows:    27,712

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
2022-03-09 04:00:00	SPY	ETF	421.5	422.94	419.11	422.73	78664.0
2022-03-09 04:30:00	SPY	ETF	422.75	423.93	422.55	423.87	92595.0
2022-03-09 05:00:00	SPY	ETF	423.84	424.18	423.21	423.88	76263.0
2022-03-09 05:30:00	SPY	ETF	424.0	424.3	422.56	423.06	66246.0
2022-03-09 06:00:00	SPY	ETF	422.86	424.38	422.73	423.5	39859.0
2022-03-09 06:30:00	SPY	ETF	423.43	423.76	422.33	422.98	85226.0
2022-03-09 07:00:00	SPY	ETF	422.81	423.75	422.4	423.33	239164.0
2022-03-09 07:30:00	SPY	ETF	423.4	424.2	423.04	424.04	287940.0
2022-03-09 08:00:00	SPY	ETF	422.9399	424.65	417.73	424.43	389831.0
2022-03-09 08:30:00	SPY	ETF	424.38	425.2	423.46	423.51	535162.0
2022-03-09 09:00:00	SPY	ETF	423.55	426.49	423.16	425.16	2150221.0
2022-03-09 09:30:00	SPY	ETF	425.14	425.7	422.82	424.1377	10709971.0
2022-03-09 10:00:00	SPY	ETF	424.14	426.37	423.96	425.75	8316929.0
2022-03-09 10:30:00	SPY	ETF	425.76	426.95	425.12	426.58	5616592.0
2022-03-09 11:00:00	SPY	ETF	426.58	426.75	424.73	425.39	4736572.0
2022-03-09 11:30:00	SPY	ETF	425.4	427.52	425.39	427.37	5107994.0
2022-03-09 12:00:00	SPY	ETF	427.38	428.0	426.78	427.52	5312986.0
2022-03-09 12:30:00	SPY	ETF	427.56	428.75	427.54	428.365	3797038.0
2022-03-09 13:00:00	SPY	ETF	428.38	428.38	427.245	428.2882	2634929.0
2022-03-09 13:30:00	SPY	ETF	428.31	428.35	426.29	426.7001	3368951.0
2022-03-09 14:00:00	SPY	ETF	426.72	427.755	426.57	427.23	2908776.0
2022-03-09 14:30:00	SPY	ETF	427.23	428.12	427.07	427.3199	3547575.0
2022-03-09 15:00:00	SPY	ETF	427.32	429.08	427.27	428.76	4656882.0
2022-03-09 15:30:00	SPY	ETF	428.77	429.51	426.63	427.41	15457464.0
2022-03-09 16:00:00	SPY	ETF	427.4	428.03	426.82	427.38	5831352.0
2022-03-09 16:30:00	SPY	ETF	427.36	428.31	427.03	427.72	528601.0
2022-03-09 17:00:00	SPY	ETF	427.72	427.8	427.41	427.67	66153.0
2022-03-09 17:30:00	SPY	ETF	427.6	427.67	427.46	427.51	21349.0
2022-03-09 18:00:00	SPY	ETF	427.65	427.87	426.91	427.1	158626.0
2022-03-09 18:30:00	SPY	ETF	427.14	427.32	426.91	427.24	70336.0
2022-03-09 19:00:00	SPY	ETF	427.3	427.49	426.8	427.41	58622.0
2022-03-09 19:30:00	SPY	ETF	427.4	427.65	427.16	427.24	42941.0
2022-03-09 04:00:00	QQQ	ETF	327.91	329.32	327.8	329.05	66754.0
2022-03-09 04:30:00	QQQ	ETF	329.03	330.55	329.03	330.41	68612.0
2022-03-09 05:00:00	QQQ	ETF	330.3	330.7	329.83	330.31	55526.0
2022-03-09 05:30:00	QQQ	ETF	330.23	330.84	329.42	329.5	136093.0
2022-03-09 06:00:00	QQQ	ETF	329.59	330.99	329.37	330.27	76311.0
2022-03-09 06:30:00	QQQ	ETF	330.11	330.43	329.19	329.55	107377.0
2022-03-09 07:00:00	QQQ	ETF	329.52	330.4	328.95	330.04	169098.0
2022-03-09 07:30:00	QQQ	ETF	330.17	330.92	329.76	330.82	231760.0
2022-03-09 08:00:00	QQQ	ETF	329.48	331.4	323.54	331.2	468850.0
2022-03-09 08:30:00	QQQ	ETF	331.29	331.85	330.4099	330.48	327788.0
2022-03-09 09:00:00	QQQ	ETF	330.55	332.67	330.21	331.7	1268092.0
2022-03-09 09:30:00	QQQ	ETF	331.76	332.1399	329.09	330.88	8718566.0
2022-03-09 10:00:00	QQQ	ETF	330.88	332.78	330.48	332.3499	5028658.0
2022-03-09 10:30:00	QQQ	ETF	332.35	333.63	331.77	333.2299	3139377.0
2022-03-09 11:00:00	QQQ	ETF	333.23	333.39	331.15	331.53	2599356.0
2022-03-09 11:30:00	QQQ	ETF	331.54	333.33	331.43	333.2499	2060950.0
2022-03-09 12:00:00	QQQ	ETF	333.24	333.76	332.48	333.3901	2159773.0
2022-03-09 12:30:00	QQQ	ETF	333.43	335.27	333.41	334.608	2624529.0

> showing 50 of 27,712 rows — these rows as CSV

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