PREVIEW / etf_30min / 2021-10-15

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-15.parquet
  size:    624 KB
  rows:    23,901

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-10-15 04:00:00	SPY	ETF	443.57	444.14	443.57	443.88	11633.0
2021-10-15 04:30:00	SPY	ETF	444.09	444.09	443.76	443.76	4521.0
2021-10-15 05:00:00	SPY	ETF	443.71	443.73	443.58	443.73	7086.0
2021-10-15 05:30:00	SPY	ETF	443.66	443.93	443.4	443.84	21336.0
2021-10-15 06:00:00	SPY	ETF	443.91	444.2	443.83	444.19	23301.0
2021-10-15 06:30:00	SPY	ETF	444.24	444.25	443.77	443.81	55998.0
2021-10-15 07:00:00	SPY	ETF	443.82	444.21	443.8	444.18	116186.0
2021-10-15 07:30:00	SPY	ETF	444.21	444.37	444.09	444.11	252100.0
2021-10-15 08:00:00	SPY	ETF	443.94	444.36	442.831	443.88	400169.0
2021-10-15 08:30:00	SPY	ETF	444.12	444.88	443.74	444.4504	613534.0
2021-10-15 09:00:00	SPY	ETF	444.45	445.0	444.3	444.76	388097.0
2021-10-15 09:30:00	SPY	ETF	444.76	445.2575	444.09	445.2575	7079593.0
2021-10-15 10:00:00	SPY	ETF	445.25	445.7	444.34	444.469	4753300.0
2021-10-15 10:30:00	SPY	ETF	444.44	445.46	444.44	445.4384	2680158.0
2021-10-15 11:00:00	SPY	ETF	445.43	445.54	445.13	445.21	2022117.0
2021-10-15 11:30:00	SPY	ETF	445.2	445.36	444.59	444.8	2017781.0
2021-10-15 12:00:00	SPY	ETF	444.79	445.24	444.78	444.99	1466210.0
2021-10-15 12:30:00	SPY	ETF	444.991	445.4	444.8101	445.32	1228193.0
2021-10-15 13:00:00	SPY	ETF	445.31	445.43	444.98	445.1199	1347274.0
2021-10-15 13:30:00	SPY	ETF	445.12	445.7064	445.12	445.58	1362761.0
2021-10-15 14:00:00	SPY	ETF	445.5972	446.26	445.59	446.07	3595779.0
2021-10-15 14:30:00	SPY	ETF	446.07	446.13	445.64	446.04	3025177.0
2021-10-15 15:00:00	SPY	ETF	446.03	446.1199	445.36	445.825	3773779.0
2021-10-15 15:30:00	SPY	ETF	445.82	445.94	445.38	445.83	8011464.0
2021-10-15 16:00:00	SPY	ETF	445.83	446.0	445.66	445.93	3006234.0
2021-10-15 16:30:00	SPY	ETF	445.93	446.05	445.87	446.01	296046.0
2021-10-15 17:00:00	SPY	ETF	445.87	445.99	445.85	445.87	53106.0
2021-10-15 17:30:00	SPY	ETF	445.87	445.89	445.8	445.87	22958.0
2021-10-15 18:00:00	SPY	ETF	445.85	445.87	445.8	445.87	14653.0
2021-10-15 18:30:00	SPY	ETF	445.87	445.97	445.8	445.9	5050.0
2021-10-15 19:00:00	SPY	ETF	445.94	445.94	445.87	445.94	2991.0
2021-10-15 19:30:00	SPY	ETF	445.87	445.97	445.87	445.87	7021.0
2021-10-15 04:00:00	QQQ	ETF	367.13	367.71	367.13	367.44	26134.0
2021-10-15 04:30:00	QQQ	ETF	367.74	367.81	367.52	367.52	6778.0
2021-10-15 05:00:00	QQQ	ETF	367.54	367.58	367.41	367.53	10002.0
2021-10-15 05:30:00	QQQ	ETF	367.54	367.65	367.15	367.59	13272.0
2021-10-15 06:00:00	QQQ	ETF	367.6	367.91	367.49	367.88	9733.0
2021-10-15 06:30:00	QQQ	ETF	367.91	367.91	367.51	367.55	11254.0
2021-10-15 07:00:00	QQQ	ETF	367.56	367.95	367.5	367.94	55900.0
2021-10-15 07:30:00	QQQ	ETF	367.95	368.07	367.79	367.89	110627.0
2021-10-15 08:00:00	QQQ	ETF	367.6596	368.49	366.81	367.82	72067.0
2021-10-15 08:30:00	QQQ	ETF	367.75	368.27	367.56	367.76	160175.0
2021-10-15 09:00:00	QQQ	ETF	367.77	368.0796	367.3	367.93	266310.0
2021-10-15 09:30:00	QQQ	ETF	367.88	368.16	366.91	367.6	3748976.0
2021-10-15 10:00:00	QQQ	ETF	367.6	367.78	366.82	366.9369	2073099.0
2021-10-15 10:30:00	QQQ	ETF	366.94	368.4	366.94	368.385	1599296.0
2021-10-15 11:00:00	QQQ	ETF	368.3899	368.63	368.12	368.26	1498712.0
2021-10-15 11:30:00	QQQ	ETF	368.25	368.4099	367.125	367.21	2334888.0
2021-10-15 12:00:00	QQQ	ETF	367.21	367.9	367.21	367.8	1323125.0
2021-10-15 12:30:00	QQQ	ETF	367.8	368.14	367.605	368.06	735787.0

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

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