PREVIEW / etf_30min / 2021-07-01

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-01.parquet
  size:    607 KB
  rows:    23,362

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-07-01 04:00:00	SPY	ETF	429.65	429.95	429.47	429.47	2902.0
2021-07-01 04:30:00	SPY	ETF	429.41	429.46	429.28	429.28	1399.0
2021-07-01 05:00:00	SPY	ETF	429.32	429.33	428.85	429.03	67307.0
2021-07-01 05:30:00	SPY	ETF	429.01	429.1	428.61	428.71	8895.0
2021-07-01 06:00:00	SPY	ETF	428.84	428.84	428.34	428.34	127173.0
2021-07-01 06:30:00	SPY	ETF	428.42	428.55	428.15	428.24	121700.0
2021-07-01 07:00:00	SPY	ETF	428.32	428.46	428.18	428.44	78068.0
2021-07-01 07:30:00	SPY	ETF	428.43	429.0	428.42	429.0	42992.0
2021-07-01 08:00:00	SPY	ETF	428.21	429.24	428.19	428.83	200351.0
2021-07-01 08:30:00	SPY	ETF	428.87	428.97	428.67	428.7601	118757.0
2021-07-01 09:00:00	SPY	ETF	428.81	428.98	428.7	428.88	211315.0
2021-07-01 09:30:00	SPY	ETF	428.83	429.485	428.8	429.3325	4433493.0
2021-07-01 10:00:00	SPY	ETF	429.34	429.66	429.1	429.37	2948977.0
2021-07-01 10:30:00	SPY	ETF	429.38	429.74	429.2401	429.48	2429053.0
2021-07-01 11:00:00	SPY	ETF	429.48	429.71	428.86	429.34	2964331.0
2021-07-01 11:30:00	SPY	ETF	429.33	429.66	429.28	429.54	1555882.0
2021-07-01 12:00:00	SPY	ETF	429.54	429.66	429.41	429.545	1035998.0
2021-07-01 12:30:00	SPY	ETF	429.55	429.65	429.41	429.5	2158147.0
2021-07-01 13:00:00	SPY	ETF	429.49	429.78	429.43	429.7501	1163230.0
2021-07-01 13:30:00	SPY	ETF	429.75	430.2099	429.71	429.91	2228540.0
2021-07-01 14:00:00	SPY	ETF	429.92	430.205	429.8298	430.19	1586074.0
2021-07-01 14:30:00	SPY	ETF	430.18	430.41	430.15	430.39	2015809.0
2021-07-01 15:00:00	SPY	ETF	430.38	430.52	430.23	430.27	3231362.0
2021-07-01 15:30:00	SPY	ETF	430.28	430.6	430.04	430.47	9813886.0
2021-07-01 16:00:00	SPY	ETF	430.47	430.58	430.21	430.25	3599116.0
2021-07-01 16:30:00	SPY	ETF	430.25	430.49	430.25	430.4	167748.0
2021-07-01 17:00:00	SPY	ETF	430.4	430.5	430.35	430.35	67131.0
2021-07-01 17:30:00	SPY	ETF	430.42	430.42	430.35	430.36	4127.0
2021-07-01 18:00:00	SPY	ETF	430.4	430.47	430.26	430.45	16335.0
2021-07-01 18:30:00	SPY	ETF	430.43	430.5	430.4	430.48	26669.0
2021-07-01 19:00:00	SPY	ETF	430.5	430.59	430.5	430.53	10467.0
2021-07-01 19:30:00	SPY	ETF	430.52	430.53	430.38	430.38	25347.0
2021-07-01 04:00:00	QQQ	ETF	354.82	355.57	354.82	355.07	28196.0
2021-07-01 04:30:00	QQQ	ETF	355.08	355.16	355.03	355.04	7828.0
2021-07-01 05:00:00	QQQ	ETF	355.03	355.03	354.26	354.56	28181.0
2021-07-01 05:30:00	QQQ	ETF	354.53	354.65	354.16	354.46	25120.0
2021-07-01 06:00:00	QQQ	ETF	354.42	354.42	353.75	353.97	37561.0
2021-07-01 06:30:00	QQQ	ETF	353.78	354.11	353.36	353.62	178446.0
2021-07-01 07:00:00	QQQ	ETF	353.63	354.05	353.58	354.05	140935.0
2021-07-01 07:30:00	QQQ	ETF	354.07	354.57	354.04	354.47	47390.0
2021-07-01 08:00:00	QQQ	ETF	354.48	355.49	353.35	354.3	126463.0
2021-07-01 08:30:00	QQQ	ETF	354.25	354.53	354.12	354.14	60897.0
2021-07-01 09:00:00	QQQ	ETF	354.15	354.43	354.0	354.05	196738.0
2021-07-01 09:30:00	QQQ	ETF	354.07	355.09	353.45	354.47	4249671.0
2021-07-01 10:00:00	QQQ	ETF	354.47	354.74	353.6	354.2	2313693.0
2021-07-01 10:30:00	QQQ	ETF	354.2	354.64	353.9	354.22	1926323.0
2021-07-01 11:00:00	QQQ	ETF	354.225	354.37	352.68	353.2	2827611.0
2021-07-01 11:30:00	QQQ	ETF	353.19	353.91	353.1584	353.8099	1845100.0
2021-07-01 12:00:00	QQQ	ETF	353.8	353.969	353.47	353.74	1021185.0
2021-07-01 12:30:00	QQQ	ETF	353.73	353.7799	353.11	353.29	1331452.0

> showing 50 of 23,362 rows — these rows as CSV

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