PREVIEW / etf_30min / 2021-09-07

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-07.parquet
  size:    616 KB
  rows:    23,709

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-07 04:00:00	SPY	ETF	452.0	453.61	452.0	453.25	7791.0
2021-09-07 04:30:00	SPY	ETF	453.37	453.47	453.31	453.36	2236.0
2021-09-07 05:00:00	SPY	ETF	453.16	453.36	452.76	452.87	8594.0
2021-09-07 05:30:00	SPY	ETF	452.81	452.81	452.6	452.67	4251.0
2021-09-07 06:00:00	SPY	ETF	452.85	453.09	452.8	452.9	6191.0
2021-09-07 06:30:00	SPY	ETF	452.99	453.05	452.85	452.98	6833.0
2021-09-07 07:00:00	SPY	ETF	453.03	453.43	452.99	453.34	32652.0
2021-09-07 07:30:00	SPY	ETF	453.35	453.39	453.26	453.32	33398.0
2021-09-07 08:00:00	SPY	ETF	453.2699	453.5	452.8296	453.26	70947.0
2021-09-07 08:30:00	SPY	ETF	453.25	453.29	452.87	453.0	82326.0
2021-09-07 09:00:00	SPY	ETF	452.99	453.07	452.57	452.7	157605.0
2021-09-07 09:30:00	SPY	ETF	452.71	452.81	451.31	451.745	5566422.0
2021-09-07 10:00:00	SPY	ETF	451.74	451.82	450.7423	451.1212	4396745.0
2021-09-07 10:30:00	SPY	ETF	451.13	451.76	450.94	451.685	2559103.0
2021-09-07 11:00:00	SPY	ETF	451.68	451.72	450.805	451.09	2967785.0
2021-09-07 11:30:00	SPY	ETF	451.09	451.54	451.03	451.28	1732935.0
2021-09-07 12:00:00	SPY	ETF	451.29	451.87	451.23	451.795	1548327.0
2021-09-07 12:30:00	SPY	ETF	451.8	452.24	451.7	452.19	1823434.0
2021-09-07 13:00:00	SPY	ETF	452.19	452.39	452.031	452.18	2052862.0
2021-09-07 13:30:00	SPY	ETF	452.18	452.43	452.13	452.345	1552869.0
2021-09-07 14:00:00	SPY	ETF	452.35	452.36	451.87	451.91	1602833.0
2021-09-07 14:30:00	SPY	ETF	451.9	452.175	451.74	452.11	1455103.0
2021-09-07 15:00:00	SPY	ETF	452.11	452.28	451.82	451.83	1597054.0
2021-09-07 15:30:00	SPY	ETF	451.82	451.9254	451.4	451.52	6825530.0
2021-09-07 16:00:00	SPY	ETF	451.52	451.57	451.16	451.35	1578731.0
2021-09-07 16:30:00	SPY	ETF	451.35	451.4	451.28	451.4	42122.0
2021-09-07 17:00:00	SPY	ETF	451.36	451.46	451.36	451.4	55931.0
2021-09-07 17:30:00	SPY	ETF	451.38	451.4	451.34	451.34	3271.0
2021-09-07 18:00:00	SPY	ETF	451.39	451.6	451.36	451.45	63131.0
2021-09-07 18:30:00	SPY	ETF	451.46	451.53	451.37	451.42	71887.0
2021-09-07 19:00:00	SPY	ETF	451.48	451.48	451.23	451.25	11151.0
2021-09-07 19:30:00	SPY	ETF	451.26	451.45	451.0	451.11	34564.0
2021-09-07 04:00:00	QQQ	ETF	381.5	382.32	381.5	382.04	40060.0
2021-09-07 04:30:00	QQQ	ETF	382.07	382.16	381.88	381.88	13328.0
2021-09-07 05:00:00	QQQ	ETF	381.85	381.93	381.2	381.45	20160.0
2021-09-07 05:30:00	QQQ	ETF	381.37	381.37	380.85	381.27	52672.0
2021-09-07 06:00:00	QQQ	ETF	381.29	381.4	381.09	381.15	15318.0
2021-09-07 06:30:00	QQQ	ETF	381.33	381.33	380.96	381.13	11948.0
2021-09-07 07:00:00	QQQ	ETF	381.18	381.48	381.13	381.47	85403.0
2021-09-07 07:30:00	QQQ	ETF	381.51	381.6	381.41	381.54	61983.0
2021-09-07 08:00:00	QQQ	ETF	381.55	381.76	380.9696	381.76	76287.0
2021-09-07 08:30:00	QQQ	ETF	381.8	381.81	381.34	381.5	56906.0
2021-09-07 09:00:00	QQQ	ETF	381.5	381.66	381.2	381.65	160484.0
2021-09-07 09:30:00	QQQ	ETF	381.65	381.97	380.65	381.36	3320792.0
2021-09-07 10:00:00	QQQ	ETF	381.34	381.39	380.4882	381.08	2154035.0
2021-09-07 10:30:00	QQQ	ETF	381.09	382.19	381.0302	382.12	1609737.0
2021-09-07 11:00:00	QQQ	ETF	382.11	382.1784	381.11	381.355	1276559.0
2021-09-07 11:30:00	QQQ	ETF	381.37	382.095	381.27	382.0	1013414.0
2021-09-07 12:00:00	QQQ	ETF	381.96	382.52	381.93	382.5101	810621.0
2021-09-07 12:30:00	QQQ	ETF	382.53	382.778	382.36	382.53	767515.0

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

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