PREVIEW / etf_30min / 2023-01-26

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-26.parquet
  size:    695 KB
  rows:    27,792

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-01-26 04:00:00	SPY	ETF	401.37	401.87	401.14	401.3	27750.0
2023-01-26 04:30:00	SPY	ETF	401.2	401.2	400.73	400.84	30071.0
2023-01-26 05:00:00	SPY	ETF	400.96	401.2	400.93	401.0	6032.0
2023-01-26 05:30:00	SPY	ETF	401.21	401.52	401.21	401.34	20574.0
2023-01-26 06:00:00	SPY	ETF	401.28	401.54	401.28	401.48	9739.0
2023-01-26 06:30:00	SPY	ETF	401.34	401.34	401.05	401.24	35853.0
2023-01-26 07:00:00	SPY	ETF	401.25	401.48	401.17	401.48	32860.0
2023-01-26 07:30:00	SPY	ETF	401.34	402.96	401.34	402.55	175592.0
2023-01-26 08:00:00	SPY	ETF	401.32	402.8	400.95	402.4	411076.0
2023-01-26 08:30:00	SPY	ETF	402.31	403.01	401.12	402.73	723829.0
2023-01-26 09:00:00	SPY	ETF	402.74	403.54	402.73	403.12	437274.0
2023-01-26 09:30:00	SPY	ETF	403.12	404.07	400.8	401.4943	6834009.0
2023-01-26 10:00:00	SPY	ETF	401.55	403.25	400.9	402.69	4789929.0
2023-01-26 10:30:00	SPY	ETF	402.69	403.105	400.03	400.35	4156400.0
2023-01-26 11:00:00	SPY	ETF	400.345	401.59	400.06	401.0301	3843614.0
2023-01-26 11:30:00	SPY	ETF	401.0	401.7794	400.83	401.68	2373176.0
2023-01-26 12:00:00	SPY	ETF	401.71	402.82	401.66	402.27	3059693.0
2023-01-26 12:30:00	SPY	ETF	402.28	402.75	401.641	402.18	2262191.0
2023-01-26 13:00:00	SPY	ETF	402.17	402.53	401.598	402.29	1587592.0
2023-01-26 13:30:00	SPY	ETF	402.32	403.5197	402.295	402.905	2514663.0
2023-01-26 14:00:00	SPY	ETF	402.9	403.54	402.505	403.06	2912798.0
2023-01-26 14:30:00	SPY	ETF	403.07	403.7	402.96	403.45	2522448.0
2023-01-26 15:00:00	SPY	ETF	403.47	404.21	403.1299	403.86	2888156.0
2023-01-26 15:30:00	SPY	ETF	403.865	404.92	403.5	404.71	7664083.0
2023-01-26 16:00:00	SPY	ETF	404.71	404.9	404.2	404.33	3310080.0
2023-01-26 16:30:00	SPY	ETF	404.33	404.75	403.95	404.07	416494.0
2023-01-26 17:00:00	SPY	ETF	404.1	404.75	403.82	404.06	531219.0
2023-01-26 17:30:00	SPY	ETF	404.05	404.05	403.5	403.76	57661.0
2023-01-26 18:00:00	SPY	ETF	403.76	403.909	403.46	403.7	154615.0
2023-01-26 18:30:00	SPY	ETF	403.65	403.75	403.46	403.52	27833.0
2023-01-26 19:00:00	SPY	ETF	403.52	403.9	403.45	403.87	23089.0
2023-01-26 19:30:00	SPY	ETF	403.9	403.99	403.67	403.7	41223.0
2023-01-26 04:00:00	QQQ	ETF	289.06	289.86	289.06	289.35	34807.0
2023-01-26 04:30:00	QQQ	ETF	289.23	289.23	288.85	288.9	49232.0
2023-01-26 05:00:00	QQQ	ETF	288.89	289.3	288.84	289.09	12370.0
2023-01-26 05:30:00	QQQ	ETF	289.17	289.57	289.17	289.46	30983.0
2023-01-26 06:00:00	QQQ	ETF	289.4	289.72	289.37	289.6	6360.0
2023-01-26 06:30:00	QQQ	ETF	289.49	289.52	289.28	289.45	21574.0
2023-01-26 07:00:00	QQQ	ETF	289.52	289.8	289.52	289.62	49463.0
2023-01-26 07:30:00	QQQ	ETF	289.59	290.88	289.59	290.67	193381.0
2023-01-26 08:00:00	QQQ	ETF	289.6	290.87	287.945	290.36	249579.0
2023-01-26 08:30:00	QQQ	ETF	290.3	291.04	289.12	290.72	656948.0
2023-01-26 09:00:00	QQQ	ETF	290.74	291.41	290.74	291.19	470427.0
2023-01-26 09:30:00	QQQ	ETF	291.22	292.64	289.54	290.2147	6314726.0
2023-01-26 10:00:00	QQQ	ETF	290.22	291.9899	289.69	291.36	3542670.0
2023-01-26 10:30:00	QQQ	ETF	291.36	291.7	288.58	288.9	2756876.0
2023-01-26 11:00:00	QQQ	ETF	288.91	290.07	288.519	289.51	2364918.0
2023-01-26 11:30:00	QQQ	ETF	289.49	290.24	289.25	290.14	1675962.0
2023-01-26 12:00:00	QQQ	ETF	290.13	291.22	290.03	290.79	1863691.0
2023-01-26 12:30:00	QQQ	ETF	290.775	291.22	290.27	290.77	1351038.0

> showing 50 of 27,792 rows — these rows as CSV

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