PREVIEW / etf_30min / 2023-03-10

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-10.parquet
  size:    702 KB
  rows:    28,738

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-03-10 04:00:00	SPY	ETF	389.34	390.49	389.25	390.49	46989.0
2023-03-10 04:30:00	SPY	ETF	390.56	390.76	389.57	389.92	25988.0
2023-03-10 05:00:00	SPY	ETF	389.91	390.99	389.86	390.79	31539.0
2023-03-10 05:30:00	SPY	ETF	390.82	390.82	390.17	390.21	93546.0
2023-03-10 06:00:00	SPY	ETF	390.26	390.59	389.72	390.38	128686.0
2023-03-10 06:30:00	SPY	ETF	390.49	391.67	390.45	391.09	192005.0
2023-03-10 07:00:00	SPY	ETF	391.06	391.4	390.7	391.31	125956.0
2023-03-10 07:30:00	SPY	ETF	391.35	391.42	390.5	391.01	337581.0
2023-03-10 08:00:00	SPY	ETF	391.0	391.55	388.12	390.86	1042265.0
2023-03-10 08:30:00	SPY	ETF	390.96	393.8	388.45	392.58	3648415.0
2023-03-10 09:00:00	SPY	ETF	392.62	392.99	390.59	390.98	2868597.0
2023-03-10 09:30:00	SPY	ETF	390.99	391.2	387.48	389.15	21209087.0
2023-03-10 10:00:00	SPY	ETF	389.18	390.63	388.4	388.86	11822309.0
2023-03-10 10:30:00	SPY	ETF	388.87	391.38	388.44	391.265	8712692.0
2023-03-10 11:00:00	SPY	ETF	391.265	392.54	390.17	392.4	8187654.0
2023-03-10 11:30:00	SPY	ETF	392.395	393.16	389.7	389.87	9528829.0
2023-03-10 12:00:00	SPY	ETF	389.87	390.31	388.27	388.97	6420877.0
2023-03-10 12:30:00	SPY	ETF	388.98	390.25	387.7	387.835	5845164.0
2023-03-10 13:00:00	SPY	ETF	387.84	388.43	385.52	385.95	6635951.0
2023-03-10 13:30:00	SPY	ETF	385.94	386.13	384.32	384.91	7496415.0
2023-03-10 14:00:00	SPY	ETF	384.91	387.51	384.86	385.36	9103541.0
2023-03-10 14:30:00	SPY	ETF	385.36	388.42	385.31	387.44	8830012.0
2023-03-10 15:00:00	SPY	ETF	387.46	387.95	385.84	386.7	8431898.0
2023-03-10 15:30:00	SPY	ETF	386.7	386.88	384.66	385.92	17305391.0
2023-03-10 16:00:00	SPY	ETF	385.92	391.6112	385.62	386.12	7350994.0
2023-03-10 16:30:00	SPY	ETF	386.12	387.53	385.91	387.51	1549093.0
2023-03-10 17:00:00	SPY	ETF	387.59	387.65	386.9	386.99	339732.0
2023-03-10 17:30:00	SPY	ETF	386.97	387.01	386.95	386.95	65023.0
2023-03-10 18:00:00	SPY	ETF	386.9	387.01	386.75	386.78	55749.0
2023-03-10 18:30:00	SPY	ETF	386.8	386.84	386.77	386.78	22238.0
2023-03-10 19:00:00	SPY	ETF	386.78	386.9	386.6	386.8	31026.0
2023-03-10 19:30:00	SPY	ETF	386.76	387.22	386.75	387.06	36286.0
2023-03-10 04:00:00	QQQ	ETF	291.67	292.52	291.48	292.52	55035.0
2023-03-10 04:30:00	QQQ	ETF	292.66	292.92	292.1	292.41	39461.0
2023-03-10 05:00:00	QQQ	ETF	292.3	292.96	292.3	292.83	17139.0
2023-03-10 05:30:00	QQQ	ETF	292.84	292.87	292.24	292.37	26566.0
2023-03-10 06:00:00	QQQ	ETF	292.51	292.54	292.03	292.48	49295.0
2023-03-10 06:30:00	QQQ	ETF	292.45	293.63	292.45	293.0	121595.0
2023-03-10 07:00:00	QQQ	ETF	293.0	293.12	292.67	292.96	106488.0
2023-03-10 07:30:00	QQQ	ETF	292.9	293.0	292.16	292.62	239420.0
2023-03-10 08:00:00	QQQ	ETF	292.62	293.4804	290.67	292.73	690332.0
2023-03-10 08:30:00	QQQ	ETF	292.81	295.05	290.89	294.11	2738552.0
2023-03-10 09:00:00	QQQ	ETF	294.15	294.54	292.47	292.83	1120962.0
2023-03-10 09:30:00	QQQ	ETF	292.83	293.06	289.13	290.1969	11480447.0
2023-03-10 10:00:00	QQQ	ETF	290.2	292.12	289.96	290.49	6387811.0
2023-03-10 10:30:00	QQQ	ETF	290.5	292.86	290.21	292.74	5190177.0
2023-03-10 11:00:00	QQQ	ETF	292.75	293.67	291.65	293.5	5236358.0
2023-03-10 11:30:00	QQQ	ETF	293.5	294.35	291.55	291.71	4692194.0
2023-03-10 12:00:00	QQQ	ETF	291.75	292.12	290.5101	291.0793	3253280.0
2023-03-10 12:30:00	QQQ	ETF	291.08	292.16	289.825	289.94	3502190.0

> showing 50 of 28,738 rows — these rows as CSV

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