PREVIEW / etf_30min / 2021-01-07

all etf 30-min files

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

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-01-07 04:00:00	SPY	ETF	375.77	376.02	375.3	375.67	33798.0
2021-01-07 04:30:00	SPY	ETF	375.25	375.37	374.81	375.31	16514.0
2021-01-07 05:00:00	SPY	ETF	375.19	375.51	375.0	375.28	4329.0
2021-01-07 05:30:00	SPY	ETF	375.15	375.3	374.52	374.52	7615.0
2021-01-07 06:00:00	SPY	ETF	374.56	374.94	374.3	374.9	11652.0
2021-01-07 06:30:00	SPY	ETF	375.05	375.19	374.56	374.6	18603.0
2021-01-07 07:00:00	SPY	ETF	374.58	375.24	374.549	375.18	137269.0
2021-01-07 07:30:00	SPY	ETF	375.2	375.8	375.15	375.57	212092.0
2021-01-07 08:00:00	SPY	ETF	374.81	377.0	374.5496	375.64	246095.0
2021-01-07 08:30:00	SPY	ETF	375.78	375.78	375.16	375.4	260671.0
2021-01-07 09:00:00	SPY	ETF	375.49	376.16	375.49	376.09	296239.0
2021-01-07 09:30:00	SPY	ETF	376.1	377.93	375.91	377.8601	9316665.0
2021-01-07 10:00:00	SPY	ETF	377.88	379.28	377.7522	379.013	7615114.0
2021-01-07 10:30:00	SPY	ETF	379.015	379.54	378.82	379.48	4842124.0
2021-01-07 11:00:00	SPY	ETF	379.48	379.86	378.78	378.94	3786979.0
2021-01-07 11:30:00	SPY	ETF	378.93	379.32	378.64	378.785	3574212.0
2021-01-07 12:00:00	SPY	ETF	378.79	378.97	378.315	378.3755	3265755.0
2021-01-07 12:30:00	SPY	ETF	378.38	378.995	378.38	378.9101	1336305.0
2021-01-07 13:00:00	SPY	ETF	378.92	379.1681	378.44	378.48	2037201.0
2021-01-07 13:30:00	SPY	ETF	378.51	379.0364	378.48	378.971	1470821.0
2021-01-07 14:00:00	SPY	ETF	378.9782	379.23	378.68	378.725	3288841.0
2021-01-07 14:30:00	SPY	ETF	378.73	379.3	378.73	379.2989	2035542.0
2021-01-07 15:00:00	SPY	ETF	379.29	379.61	378.83	379.465	3671964.0
2021-01-07 15:30:00	SPY	ETF	379.465	379.9	378.95	379.06	10407215.0
2021-01-07 16:00:00	SPY	ETF	379.07	379.38	377.45	379.18	5395825.0
2021-01-07 16:30:00	SPY	ETF	379.25	379.39	378.95	379.08	932986.0
2021-01-07 17:00:00	SPY	ETF	379.11	379.32	379.06	379.22	455448.0
2021-01-07 17:30:00	SPY	ETF	379.3	379.4	379.1	379.39	292624.0
2021-01-07 18:00:00	SPY	ETF	379.35	379.35	373.4526	378.98	233964.0
2021-01-07 18:30:00	SPY	ETF	378.96	379.67	378.9	379.54	49371.0
2021-01-07 19:00:00	SPY	ETF	379.41	379.78	379.25	379.78	73950.0
2021-01-07 19:30:00	SPY	ETF	379.78	379.88	379.46	379.88	38525.0
2021-01-07 04:00:00	QQQ	ETF	309.22	309.9	308.94	309.76	22798.0
2021-01-07 04:30:00	QQQ	ETF	309.65	309.65	308.92	309.26	16835.0
2021-01-07 05:00:00	QQQ	ETF	309.07	309.58	309.06	309.5	6825.0
2021-01-07 05:30:00	QQQ	ETF	309.37	309.76	308.88	308.88	15200.0
2021-01-07 06:00:00	QQQ	ETF	308.79	309.4	308.7	309.37	33202.0
2021-01-07 06:30:00	QQQ	ETF	309.44	309.48	309.12	309.23	16518.0
2021-01-07 07:00:00	QQQ	ETF	309.26	310.0	309.2	309.79	134954.0
2021-01-07 07:30:00	QQQ	ETF	309.75	310.15	309.68	309.92	80337.0
2021-01-07 08:00:00	QQQ	ETF	309.7	310.31	308.82	310.1	118739.0
2021-01-07 08:30:00	QQQ	ETF	310.17	310.19	309.71	309.83	119515.0
2021-01-07 09:00:00	QQQ	ETF	309.858	310.51	309.858	310.28	340983.0
2021-01-07 09:30:00	QQQ	ETF	310.28	312.95	310.25	312.925	5366378.0
2021-01-07 10:00:00	QQQ	ETF	312.95	314.17	312.81	313.76	2617957.0
2021-01-07 10:30:00	QQQ	ETF	313.77	314.55	313.735	314.43	1481248.0
2021-01-07 11:00:00	QQQ	ETF	314.43	314.7	313.82	314.36	1405065.0
2021-01-07 11:30:00	QQQ	ETF	314.36	314.9	314.06	314.2082	1254148.0
2021-01-07 12:00:00	QQQ	ETF	314.21	314.34	313.66	313.855	951918.0
2021-01-07 12:30:00	QQQ	ETF	313.86	314.44	313.86	314.28	530429.0

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

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