PREVIEW / etf_30min / 2021-09-02

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-02.parquet
  size:    603 KB
  rows:    22,983

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-09-02 04:00:00	SPY	ETF	452.23	452.75	450.0	452.65	11052.0
2021-09-02 04:30:00	SPY	ETF	452.67	452.86	452.67	452.79	2400.0
2021-09-02 05:00:00	SPY	ETF	452.81	452.81	452.52	452.63	5709.0
2021-09-02 05:30:00	SPY	ETF	452.7	452.78	452.48	452.48	4975.0
2021-09-02 06:00:00	SPY	ETF	452.62	452.62	452.5	452.5	4336.0
2021-09-02 06:30:00	SPY	ETF	452.63	452.67	452.45	452.55	9850.0
2021-09-02 07:00:00	SPY	ETF	452.57	452.63	452.47	452.55	23096.0
2021-09-02 07:30:00	SPY	ETF	452.58	452.69	452.58	452.64	23760.0
2021-09-02 08:00:00	SPY	ETF	452.6101	452.75	452.15	452.59	104319.0
2021-09-02 08:30:00	SPY	ETF	452.6	453.08	452.6	453.02	85942.0
2021-09-02 09:00:00	SPY	ETF	453.08	453.35	452.93	453.33	139010.0
2021-09-02 09:30:00	SPY	ETF	453.32	454.05	453.24	453.4	5226255.0
2021-09-02 10:00:00	SPY	ETF	453.4	453.59	453.05	453.54	2571262.0
2021-09-02 10:30:00	SPY	ETF	453.54	453.715	453.29	453.46	2316451.0
2021-09-02 11:00:00	SPY	ETF	453.47	453.75	453.27	453.65	1666405.0
2021-09-02 11:30:00	SPY	ETF	453.6594	453.77	453.44	453.48	2456294.0
2021-09-02 12:00:00	SPY	ETF	453.47	453.525	453.13	453.22	1205415.0
2021-09-02 12:30:00	SPY	ETF	453.2205	453.43	453.08	453.38	983901.0
2021-09-02 13:00:00	SPY	ETF	453.38	453.44	452.72	452.74	1597774.0
2021-09-02 13:30:00	SPY	ETF	452.73	453.0	452.2401	452.36	2236350.0
2021-09-02 14:00:00	SPY	ETF	452.36	452.5399	451.91	452.11	2634689.0
2021-09-02 14:30:00	SPY	ETF	452.12	452.79	451.985	452.7117	1959529.0
2021-09-02 15:00:00	SPY	ETF	452.72	452.865	452.2101	452.32	1949632.0
2021-09-02 15:30:00	SPY	ETF	452.33	453.22	452.12	453.2	6496568.0
2021-09-02 16:00:00	SPY	ETF	453.2	453.33	452.94	453.24	1380756.0
2021-09-02 16:30:00	SPY	ETF	453.25	453.31	453.0	453.27	207681.0
2021-09-02 17:00:00	SPY	ETF	453.28	453.35	453.25	453.3	37444.0
2021-09-02 17:30:00	SPY	ETF	453.27	453.27	453.23	453.27	5989.0
2021-09-02 18:00:00	SPY	ETF	453.28	453.33	453.15	453.33	39446.0
2021-09-02 18:30:00	SPY	ETF	453.19	453.39	453.19	453.32	10750.0
2021-09-02 19:00:00	SPY	ETF	453.3	453.31	453.15	453.15	27507.0
2021-09-02 19:30:00	SPY	ETF	453.18	453.21	453.07	453.13	23090.0
2021-09-02 04:00:00	QQQ	ETF	380.99	381.39	380.99	381.3	7732.0
2021-09-02 04:30:00	QQQ	ETF	381.32	381.47	381.32	381.37	8991.0
2021-09-02 05:00:00	QQQ	ETF	381.45	381.45	381.29	381.35	7313.0
2021-09-02 05:30:00	QQQ	ETF	381.4	381.57	381.18	381.24	20919.0
2021-09-02 06:00:00	QQQ	ETF	381.24	381.4	381.24	381.4	13885.0
2021-09-02 06:30:00	QQQ	ETF	381.41	381.42	381.24	381.29	14475.0
2021-09-02 07:00:00	QQQ	ETF	381.27	381.52	381.27	381.44	15907.0
2021-09-02 07:30:00	QQQ	ETF	381.47	381.7	381.47	381.53	28315.0
2021-09-02 08:00:00	QQQ	ETF	381.54	381.68	381.03	381.56	48767.0
2021-09-02 08:30:00	QQQ	ETF	381.52	381.83	381.51	381.67	56050.0
2021-09-02 09:00:00	QQQ	ETF	381.7	381.97	381.56	381.97	73004.0
2021-09-02 09:30:00	QQQ	ETF	381.97	382.31	381.39	381.5201	2610144.0
2021-09-02 10:00:00	QQQ	ETF	381.54	381.82	380.71	381.15	2213013.0
2021-09-02 10:30:00	QQQ	ETF	381.13	381.51	380.88	381.368	1316319.0
2021-09-02 11:00:00	QQQ	ETF	381.38	381.695	380.8	381.595	1130407.0
2021-09-02 11:30:00	QQQ	ETF	381.6	381.68	381.0532	381.075	746141.0
2021-09-02 12:00:00	QQQ	ETF	381.08	381.1474	380.46	380.7	1030002.0
2021-09-02 12:30:00	QQQ	ETF	380.68	380.87	380.39	380.81	1064815.0

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

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