PREVIEW / etf_30min / 2021-02-09

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-02-09.parquet
  size:    633 KB
  rows:    23,943

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-02-09 04:00:00	SPY	ETF	390.28	390.33	389.88	390.17	21804.0
2021-02-09 04:30:00	SPY	ETF	390.12	390.15	389.95	390.15	11395.0
2021-02-09 05:00:00	SPY	ETF	390.18	390.2	390.09	390.09	6057.0
2021-02-09 05:30:00	SPY	ETF	390.16	390.16	389.93	389.93	6236.0
2021-02-09 06:00:00	SPY	ETF	389.83	389.84	389.49	389.73	56591.0
2021-02-09 06:30:00	SPY	ETF	389.8	390.06	389.78	390.01	15032.0
2021-02-09 07:00:00	SPY	ETF	390.04	390.11	389.86	390.03	68156.0
2021-02-09 07:30:00	SPY	ETF	390.01	390.19	389.7	389.75	198713.0
2021-02-09 08:00:00	SPY	ETF	389.76	390.52	389.6	389.86	146775.0
2021-02-09 08:30:00	SPY	ETF	389.85	389.93	389.61	389.92	211560.0
2021-02-09 09:00:00	SPY	ETF	389.9	389.9	389.4	389.54	194446.0
2021-02-09 09:30:00	SPY	ETF	389.61	390.28	389.17	390.13	3923963.0
2021-02-09 10:00:00	SPY	ETF	390.12	390.43	389.82	390.22	2181249.0
2021-02-09 10:30:00	SPY	ETF	390.21	390.46	389.96	390.045	1337565.0
2021-02-09 11:00:00	SPY	ETF	390.04	390.04	389.3901	389.7151	1771876.0
2021-02-09 11:30:00	SPY	ETF	389.72	390.3	389.585	390.05	1187805.0
2021-02-09 12:00:00	SPY	ETF	390.07	390.63	390.02	390.4919	1443571.0
2021-02-09 12:30:00	SPY	ETF	390.495	390.82	390.49	390.695	1081867.0
2021-02-09 13:00:00	SPY	ETF	390.6981	390.747	390.19	390.22	1031083.0
2021-02-09 13:30:00	SPY	ETF	390.21	390.44	390.18	390.365	870216.0
2021-02-09 14:00:00	SPY	ETF	390.36	390.707	390.36	390.6257	1151874.0
2021-02-09 14:30:00	SPY	ETF	390.62	390.88	390.62	390.79	1200451.0
2021-02-09 15:00:00	SPY	ETF	390.79	390.85	390.46	390.485	2010695.0
2021-02-09 15:30:00	SPY	ETF	390.48	390.89	389.89	390.25	5463252.0
2021-02-09 16:00:00	SPY	ETF	390.25	390.65	390.1433	390.6	2147925.0
2021-02-09 16:30:00	SPY	ETF	390.59	390.77	390.25	390.77	177525.0
2021-02-09 17:00:00	SPY	ETF	390.78	390.85	390.25	390.8	96616.0
2021-02-09 17:30:00	SPY	ETF	390.77	390.84	390.7	390.84	40090.0
2021-02-09 18:00:00	SPY	ETF	390.84	390.89	390.54	390.57	49149.0
2021-02-09 18:30:00	SPY	ETF	390.25	390.8	390.25	390.6	24174.0
2021-02-09 19:00:00	SPY	ETF	390.6	390.7	390.41	390.7	28832.0
2021-02-09 19:30:00	SPY	ETF	390.61	390.7	390.56	390.68	8160.0
2021-02-09 04:00:00	QQQ	ETF	333.26	333.28	333.05	333.27	9644.0
2021-02-09 04:30:00	QQQ	ETF	333.26	333.28	333.08	333.18	15891.0
2021-02-09 05:00:00	QQQ	ETF	333.22	333.3	333.16	333.18	5350.0
2021-02-09 05:30:00	QQQ	ETF	333.18	333.33	333.1	333.1	12646.0
2021-02-09 06:00:00	QQQ	ETF	333.0	333.01	332.86	332.94	10102.0
2021-02-09 06:30:00	QQQ	ETF	332.99	333.18	332.97	333.17	7198.0
2021-02-09 07:00:00	QQQ	ETF	333.18	333.34	333.08	333.3	25981.0
2021-02-09 07:30:00	QQQ	ETF	333.29	333.39	333.11	333.16	28511.0
2021-02-09 08:00:00	QQQ	ETF	333.1601	333.6	332.8204	333.0	58169.0
2021-02-09 08:30:00	QQQ	ETF	333.01	333.08	332.89	332.99	51440.0
2021-02-09 09:00:00	QQQ	ETF	332.89	332.9	332.35	332.64	136382.0
2021-02-09 09:30:00	QQQ	ETF	332.62	334.14	332.61	334.02	2417452.0
2021-02-09 10:00:00	QQQ	ETF	334.07	334.62	333.9	334.3	1704225.0
2021-02-09 10:30:00	QQQ	ETF	334.31	334.81	334.08	334.18	1047787.0
2021-02-09 11:00:00	QQQ	ETF	334.17	334.19	333.1601	333.38	1104923.0
2021-02-09 11:30:00	QQQ	ETF	333.37	333.97	333.34	333.73	582718.0
2021-02-09 12:00:00	QQQ	ETF	333.71	334.09	333.4328	333.8291	497380.0
2021-02-09 12:30:00	QQQ	ETF	333.86	333.945	333.605	333.8	571453.0

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

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