PREVIEW / etf_30min / 2021-06-09

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-09.parquet
  size:    590 KB
  rows:    22,704

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-06-09 04:00:00	SPY	ETF	422.35	422.65	422.35	422.5	3770.0
2021-06-09 04:30:00	SPY	ETF	422.67	422.75	422.67	422.72	1900.0
2021-06-09 05:00:00	SPY	ETF	422.68	422.68	422.37	422.54	1800.0
2021-06-09 05:30:00	SPY	ETF	422.48	422.5	422.35	422.48	955.0
2021-06-09 06:00:00	SPY	ETF	422.6	422.63	422.4	422.48	3835.0
2021-06-09 06:30:00	SPY	ETF	422.43	422.71	422.43	422.6	5394.0
2021-06-09 07:00:00	SPY	ETF	422.68	422.84	422.52	422.62	53834.0
2021-06-09 07:30:00	SPY	ETF	422.61	422.99	422.14	422.97	68072.0
2021-06-09 08:00:00	SPY	ETF	422.95	423.02	422.19	422.79	174170.0
2021-06-09 08:30:00	SPY	ETF	422.79	423.12	422.77	422.95	181363.0
2021-06-09 09:00:00	SPY	ETF	422.99	423.22	422.91	423.17	143983.0
2021-06-09 09:30:00	SPY	ETF	423.18	423.26	422.43	422.83	4466621.0
2021-06-09 10:00:00	SPY	ETF	422.84	422.9919	422.32	422.9	2656449.0
2021-06-09 10:30:00	SPY	ETF	422.9	423.0699	422.7	422.8382	1690817.0
2021-06-09 11:00:00	SPY	ETF	422.83	423.12	422.79	422.93	1481304.0
2021-06-09 11:30:00	SPY	ETF	422.94	422.96	422.21	422.475	1748327.0
2021-06-09 12:00:00	SPY	ETF	422.47	422.68	422.39	422.65	1113558.0
2021-06-09 12:30:00	SPY	ETF	422.66	422.7901	422.625	422.74	917788.0
2021-06-09 13:00:00	SPY	ETF	422.75	422.9717	422.65	422.845	1105375.0
2021-06-09 13:30:00	SPY	ETF	422.8419	422.9	422.52	422.64	1401926.0
2021-06-09 14:00:00	SPY	ETF	422.65	422.85	422.52	422.8104	1520165.0
2021-06-09 14:30:00	SPY	ETF	422.812	422.88	422.36	422.43	1899555.0
2021-06-09 15:00:00	SPY	ETF	422.43	422.435	421.81	421.83	2317917.0
2021-06-09 15:30:00	SPY	ETF	421.83	422.055	421.41	421.62	7380982.0
2021-06-09 16:00:00	SPY	ETF	421.61	422.05	421.5338	421.92	2883746.0
2021-06-09 16:30:00	SPY	ETF	421.92	421.95	421.85	421.92	191580.0
2021-06-09 17:00:00	SPY	ETF	421.86	421.93	421.8	421.84	63735.0
2021-06-09 17:30:00	SPY	ETF	421.84	421.92	421.65	421.87	62097.0
2021-06-09 18:00:00	SPY	ETF	421.92	422.09	421.92	421.98	56664.0
2021-06-09 18:30:00	SPY	ETF	421.65	422.05	421.65	422.02	12456.0
2021-06-09 19:00:00	SPY	ETF	422.02	422.02	421.83	422.0	9506.0
2021-06-09 19:30:00	SPY	ETF	422.05	422.1	421.78	421.85	20914.0
2021-06-09 04:00:00	QQQ	ETF	337.06	337.4	337.03	337.13	9980.0
2021-06-09 04:30:00	QQQ	ETF	337.09	337.32	337.09	337.32	3315.0
2021-06-09 05:00:00	QQQ	ETF	337.26	337.26	336.9	337.11	6322.0
2021-06-09 05:30:00	QQQ	ETF	337.1	337.19	336.92	337.06	12029.0
2021-06-09 06:00:00	QQQ	ETF	337.23	337.32	337.14	337.14	6833.0
2021-06-09 06:30:00	QQQ	ETF	337.19	337.77	337.19	337.7	13771.0
2021-06-09 07:00:00	QQQ	ETF	337.71	337.98	337.64	337.84	32242.0
2021-06-09 07:30:00	QQQ	ETF	337.7	337.9	337.2	337.85	57812.0
2021-06-09 08:00:00	QQQ	ETF	337.7204	337.88	336.66	337.69	119026.0
2021-06-09 08:30:00	QQQ	ETF	337.68	338.19	337.63	337.99	127360.0
2021-06-09 09:00:00	QQQ	ETF	337.9896	338.33	337.98	338.17	81968.0
2021-06-09 09:30:00	QQQ	ETF	338.18	338.97	337.51	338.2	4012380.0
2021-06-09 10:00:00	QQQ	ETF	338.16	338.38	337.06	337.84	1729092.0
2021-06-09 10:30:00	QQQ	ETF	337.825	338.061	337.33	337.61	1003400.0
2021-06-09 11:00:00	QQQ	ETF	337.595	338.05	337.5	337.7	685243.0
2021-06-09 11:30:00	QQQ	ETF	337.69	337.7201	336.86	337.19	776363.0
2021-06-09 12:00:00	QQQ	ETF	337.18	337.87	337.07	337.8516	780907.0
2021-06-09 12:30:00	QQQ	ETF	337.8616	338.13	337.83	338.09	1149501.0

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

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