PREVIEW / etf_30min / 2021-08-09

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-09.parquet
  size:    608 KB
  rows:    23,085

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-08-09 04:00:00	SPY	ETF	441.67	441.77	441.4	441.71	18335.0
2021-08-09 04:30:00	SPY	ETF	441.71	441.89	441.64	441.88	4800.0
2021-08-09 05:00:00	SPY	ETF	441.8	441.84	441.65	441.69	7242.0
2021-08-09 05:30:00	SPY	ETF	441.64	441.88	441.64	441.85	4398.0
2021-08-09 06:00:00	SPY	ETF	442.06	442.09	441.69	441.77	4450.0
2021-08-09 06:30:00	SPY	ETF	441.69	441.88	441.68	441.77	19983.0
2021-08-09 07:00:00	SPY	ETF	441.72	442.0	441.61	441.96	101586.0
2021-08-09 07:30:00	SPY	ETF	441.97	442.01	441.82	441.93	89269.0
2021-08-09 08:00:00	SPY	ETF	441.93	442.0	441.63	441.81	88222.0
2021-08-09 08:30:00	SPY	ETF	441.82	442.1699	441.76	442.09	94939.0
2021-08-09 09:00:00	SPY	ETF	442.1	442.49	442.08	442.45	238861.0
2021-08-09 09:30:00	SPY	ETF	442.45	442.795	441.31	441.75	4771994.0
2021-08-09 10:00:00	SPY	ETF	441.75	441.92	441.4532	441.79	2535025.0
2021-08-09 10:30:00	SPY	ETF	441.785	442.28	441.68	441.83	2481048.0
2021-08-09 11:00:00	SPY	ETF	441.83	442.03	441.72	441.9699	1609894.0
2021-08-09 11:30:00	SPY	ETF	441.96	442.36	441.91	442.35	1266066.0
2021-08-09 12:00:00	SPY	ETF	442.349	442.36	442.03	442.06	1058321.0
2021-08-09 12:30:00	SPY	ETF	442.07	442.235	442.06	442.18	963085.0
2021-08-09 13:00:00	SPY	ETF	442.18	442.3	442.1	442.142	878822.0
2021-08-09 13:30:00	SPY	ETF	442.145	442.33	442.063	442.24	959395.0
2021-08-09 14:00:00	SPY	ETF	442.2469	442.63	442.24	442.63	951133.0
2021-08-09 14:30:00	SPY	ETF	442.63	442.77	442.45	442.49	1446814.0
2021-08-09 15:00:00	SPY	ETF	442.48	442.53	442.19	442.3201	1435497.0
2021-08-09 15:30:00	SPY	ETF	442.33	442.65	441.98	442.14	4053768.0
2021-08-09 16:00:00	SPY	ETF	442.15	442.49	442.13	442.26	1742434.0
2021-08-09 16:30:00	SPY	ETF	442.26	442.34	442.13	442.34	132143.0
2021-08-09 17:00:00	SPY	ETF	442.39	442.7	442.31	442.43	151183.0
2021-08-09 17:30:00	SPY	ETF	442.43	442.44	442.38	442.39	24747.0
2021-08-09 18:00:00	SPY	ETF	442.37	442.43	442.13	442.148	34330.0
2021-08-09 18:30:00	SPY	ETF	442.19	442.23	442.11	442.13	26067.0
2021-08-09 19:00:00	SPY	ETF	442.13	442.15	441.99	442.02	144938.0
2021-08-09 19:30:00	SPY	ETF	442.05	442.13	441.84	442.1	129895.0
2021-08-09 04:00:00	QQQ	ETF	367.71	368.05	367.61	367.95	23542.0
2021-08-09 04:30:00	QQQ	ETF	367.97	368.27	367.92	368.16	9762.0
2021-08-09 05:00:00	QQQ	ETF	368.2	368.29	368.12	368.12	15489.0
2021-08-09 05:30:00	QQQ	ETF	368.15	368.17	368.05	368.16	11896.0
2021-08-09 06:00:00	QQQ	ETF	368.22	368.54	368.22	368.25	36440.0
2021-08-09 06:30:00	QQQ	ETF	368.25	368.56	368.24	368.44	25829.0
2021-08-09 07:00:00	QQQ	ETF	368.42	368.77	368.25	368.61	125834.0
2021-08-09 07:30:00	QQQ	ETF	368.6	368.72	368.47	368.52	63291.0
2021-08-09 08:00:00	QQQ	ETF	368.6401	368.74	366.93	368.29	60669.0
2021-08-09 08:30:00	QQQ	ETF	368.35	368.5	368.33	368.34	48756.0
2021-08-09 09:00:00	QQQ	ETF	368.34	368.53	368.05	368.52	40999.0
2021-08-09 09:30:00	QQQ	ETF	368.52	369.0801	367.39	368.4	2778072.0
2021-08-09 10:00:00	QQQ	ETF	368.4	368.78	367.8376	368.675	1660425.0
2021-08-09 10:30:00	QQQ	ETF	368.71	369.09	368.19	368.36	1541855.0
2021-08-09 11:00:00	QQQ	ETF	368.36	368.7199	367.92	368.49	1448200.0
2021-08-09 11:30:00	QQQ	ETF	368.49	368.67	368.22	368.655	959114.0
2021-08-09 12:00:00	QQQ	ETF	368.65	368.815	368.285	368.31	808547.0
2021-08-09 12:30:00	QQQ	ETF	368.32	368.61	368.25	368.53	761242.0

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

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