PREVIEW / etf_30min / 2023-11-15

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-15.parquet
  size:    766 KB
  rows:    30,527

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
2023-11-15 04:00:00	SPY	ETF	450.66	450.67	449.86	449.98	69252.0
2023-11-15 04:30:00	SPY	ETF	449.94	449.98	449.65	449.79	9454.0
2023-11-15 05:00:00	SPY	ETF	449.77	450.14	449.77	450.04	4128.0
2023-11-15 05:30:00	SPY	ETF	450.17	450.61	450.17	450.54	11578.0
2023-11-15 06:00:00	SPY	ETF	450.5	450.5	450.15	450.38	6620.0
2023-11-15 06:30:00	SPY	ETF	450.35	450.76	450.35	450.76	80670.0
2023-11-15 07:00:00	SPY	ETF	450.71	451.04	450.45	450.81	76784.0
2023-11-15 07:30:00	SPY	ETF	450.83	451.05	450.61	451.0	126335.0
2023-11-15 08:00:00	SPY	ETF	451.01	451.09	449.65	450.86	108287.0
2023-11-15 08:30:00	SPY	ETF	451.04	451.76	449.68	450.28	681017.0
2023-11-15 09:00:00	SPY	ETF	450.36	450.38	449.64	450.09	402084.0
2023-11-15 09:30:00	SPY	ETF	450.09	450.75	449.4	449.92	6297658.0
2023-11-15 10:00:00	SPY	ETF	449.92	451.24	449.76	450.7	4941915.0
2023-11-15 10:30:00	SPY	ETF	450.7	451.37	450.47	451.09	4305334.0
2023-11-15 11:00:00	SPY	ETF	451.09	451.38	450.581	450.8	3308908.0
2023-11-15 11:30:00	SPY	ETF	450.81	450.815	449.6	449.8273	4034915.0
2023-11-15 12:00:00	SPY	ETF	449.825	450.185	449.54	450.1699	2865834.0
2023-11-15 12:30:00	SPY	ETF	450.16	450.37	449.685	449.77	2193651.0
2023-11-15 13:00:00	SPY	ETF	449.77	449.84	448.8	449.739	3957923.0
2023-11-15 13:30:00	SPY	ETF	449.735	450.31	449.5922	450.225	2281572.0
2023-11-15 14:00:00	SPY	ETF	450.23	450.475	449.61	450.44	3545733.0
2023-11-15 14:30:00	SPY	ETF	450.44	450.69	449.915	450.24	2930479.0
2023-11-15 15:00:00	SPY	ETF	450.24	450.38	449.745	450.07	3207705.0
2023-11-15 15:30:00	SPY	ETF	450.08	450.37	449.21	449.63	10902165.0
2023-11-15 16:00:00	SPY	ETF	449.63	450.4835	448.9	449.01	4171477.0
2023-11-15 16:30:00	SPY	ETF	449.02	449.68	448.93	449.17	397248.0
2023-11-15 17:00:00	SPY	ETF	449.18	449.68	448.99	449.0001	70453.0
2023-11-15 17:30:00	SPY	ETF	449.0001	449.1	449.0	449.03	16230.0
2023-11-15 18:00:00	SPY	ETF	449.1	449.33	449.1	449.26	22641.0
2023-11-15 18:30:00	SPY	ETF	449.27	449.38	449.25	449.3793	19815.0
2023-11-15 19:00:00	SPY	ETF	449.36	449.68	449.31	449.54	86264.0
2023-11-15 19:30:00	SPY	ETF	449.54	449.66	449.44	449.5501	13089.0
2023-11-15 04:00:00	QQQ	ETF	386.32	387.34	386.32	386.82	37991.0
2023-11-15 04:30:00	QQQ	ETF	386.86	386.86	386.55	386.63	9804.0
2023-11-15 05:00:00	QQQ	ETF	386.64	387.09	386.64	387.09	15269.0
2023-11-15 05:30:00	QQQ	ETF	387.12	387.58	387.12	387.51	23618.0
2023-11-15 06:00:00	QQQ	ETF	387.45	387.47	387.2	387.44	13168.0
2023-11-15 06:30:00	QQQ	ETF	387.4	387.71	387.32	387.68	32563.0
2023-11-15 07:00:00	QQQ	ETF	387.66	388.04	387.51	387.73	119345.0
2023-11-15 07:30:00	QQQ	ETF	387.76	388.03	387.64	388.02	60783.0
2023-11-15 08:00:00	QQQ	ETF	387.99	388.31	385.618	388.23	204714.0
2023-11-15 08:30:00	QQQ	ETF	388.2	389.49	386.79	387.48	836927.0
2023-11-15 09:00:00	QQQ	ETF	387.5	387.6	386.86	387.24	443482.0
2023-11-15 09:30:00	QQQ	ETF	387.24	387.65	385.9906	386.285	5926332.0
2023-11-15 10:00:00	QQQ	ETF	386.29	387.4	386.07	386.7692	3406890.0
2023-11-15 10:30:00	QQQ	ETF	386.81	387.75	386.353	387.33	3102901.0
2023-11-15 11:00:00	QQQ	ETF	387.3292	387.52	386.7	387.26	2661666.0
2023-11-15 11:30:00	QQQ	ETF	387.27	387.27	385.692	385.83	2892472.0
2023-11-15 12:00:00	QQQ	ETF	385.85	386.16	385.492	386.02	2047374.0
2023-11-15 12:30:00	QQQ	ETF	386.01	386.28	385.56	385.6448	1769826.0

> showing 50 of 30,527 rows — these rows as CSV

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