PREVIEW / etf_30min / 2021-06-22

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-22.parquet
  size:    601 KB
  rows:    22,897

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-06-22 04:00:00	SPY	ETF	420.74	420.74	420.21	420.35	10499.0
2021-06-22 04:30:00	SPY	ETF	420.31	420.36	420.07	420.2	8356.0
2021-06-22 05:00:00	SPY	ETF	420.35	420.7	420.3	420.61	20047.0
2021-06-22 05:30:00	SPY	ETF	420.7	420.7	420.17	420.36	10198.0
2021-06-22 06:00:00	SPY	ETF	420.4	420.93	420.4	420.53	9915.0
2021-06-22 06:30:00	SPY	ETF	420.68	421.0	420.66	420.85	12203.0
2021-06-22 07:00:00	SPY	ETF	420.89	421.42	420.83	421.42	47904.0
2021-06-22 07:30:00	SPY	ETF	421.44	421.57	421.25	421.5	58911.0
2021-06-22 08:00:00	SPY	ETF	421.29	421.65	420.5	421.28	95280.0
2021-06-22 08:30:00	SPY	ETF	421.29	421.42	420.62	420.78	107564.0
2021-06-22 09:00:00	SPY	ETF	420.78	421.22	420.71	420.85	167088.0
2021-06-22 09:30:00	SPY	ETF	420.85	421.14	420.16	420.4	5121144.0
2021-06-22 10:00:00	SPY	ETF	420.42	421.38	420.08	421.25	3856008.0
2021-06-22 10:30:00	SPY	ETF	421.265	421.89	421.21	421.87	2779495.0
2021-06-22 11:00:00	SPY	ETF	421.88	422.63	421.76	422.43	2987286.0
2021-06-22 11:30:00	SPY	ETF	422.445	422.55	421.98	422.03	1666930.0
2021-06-22 12:00:00	SPY	ETF	422.05	422.48	422.05	422.46	1576398.0
2021-06-22 12:30:00	SPY	ETF	422.45	422.47	422.18	422.3	1154228.0
2021-06-22 13:00:00	SPY	ETF	422.28	422.535	422.13	422.41	1387916.0
2021-06-22 13:30:00	SPY	ETF	422.415	422.48	422.33	422.4101	1183311.0
2021-06-22 14:00:00	SPY	ETF	422.41	422.63	422.23	422.48	3071304.0
2021-06-22 14:30:00	SPY	ETF	422.48	423.02	422.43	422.92	2240235.0
2021-06-22 15:00:00	SPY	ETF	422.93	424.0	422.91	423.82	4086724.0
2021-06-22 15:30:00	SPY	ETF	423.82	423.96	422.99	423.04	9588169.0
2021-06-22 16:00:00	SPY	ETF	423.05	423.25	422.83	423.06	3597654.0
2021-06-22 16:30:00	SPY	ETF	423.1	423.43	423.1	423.14	153915.0
2021-06-22 17:00:00	SPY	ETF	423.13	423.44	423.07	423.4	98293.0
2021-06-22 17:30:00	SPY	ETF	423.37	423.39	423.3	423.33	42321.0
2021-06-22 18:00:00	SPY	ETF	423.32	423.32	423.11	423.16	98176.0
2021-06-22 18:30:00	SPY	ETF	423.11	423.21	423.03	423.13	16766.0
2021-06-22 19:00:00	SPY	ETF	423.19	423.28	423.16	423.16	8237.0
2021-06-22 19:30:00	SPY	ETF	423.17	423.33	423.17	423.23	27738.0
2021-06-22 04:00:00	QQQ	ETF	343.86	343.86	343.06	343.16	15489.0
2021-06-22 04:30:00	QQQ	ETF	343.3	343.31	343.22	343.28	2709.0
2021-06-22 05:00:00	QQQ	ETF	343.46	343.94	343.45	343.87	6177.0
2021-06-22 05:30:00	QQQ	ETF	343.94	343.94	343.56	343.84	14550.0
2021-06-22 06:00:00	QQQ	ETF	344.0	344.35	343.98	344.15	14923.0
2021-06-22 06:30:00	QQQ	ETF	344.2	344.71	344.2	344.58	20910.0
2021-06-22 07:00:00	QQQ	ETF	344.58	345.35	344.58	345.35	61957.0
2021-06-22 07:30:00	QQQ	ETF	345.36	345.5	345.19	345.36	39859.0
2021-06-22 08:00:00	QQQ	ETF	344.58	345.5	343.02	344.83	137678.0
2021-06-22 08:30:00	QQQ	ETF	344.91	345.01	344.07	344.33	198181.0
2021-06-22 09:00:00	QQQ	ETF	344.3	344.63	343.96	344.13	150312.0
2021-06-22 09:30:00	QQQ	ETF	344.15	345.53	343.84	344.69	4204271.0
2021-06-22 10:00:00	QQQ	ETF	344.73	345.47	344.19	345.3172	2120963.0
2021-06-22 10:30:00	QQQ	ETF	345.295	345.73	344.815	345.38	1749400.0
2021-06-22 11:00:00	QQQ	ETF	345.39	346.475	345.32	346.28	1678274.0
2021-06-22 11:30:00	QQQ	ETF	346.2984	346.44	346.0	346.0818	961051.0
2021-06-22 12:00:00	QQQ	ETF	346.13	346.84	346.13	346.81	961906.0
2021-06-22 12:30:00	QQQ	ETF	346.82	346.9201	346.54	346.64	823685.0

> showing 50 of 22,897 rows — these rows as CSV

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