PREVIEW / etf_30min / 2023-06-08

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-08.parquet
  size:    692 KB
  rows:    27,099

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-06-08 04:00:00	SPY	ETF	426.53	427.08	426.41	427.04	15370.0
2023-06-08 04:30:00	SPY	ETF	427.0	427.07	426.8	426.81	18478.0
2023-06-08 05:00:00	SPY	ETF	426.92	426.95	426.81	426.85	8305.0
2023-06-08 05:30:00	SPY	ETF	426.75	427.09	426.75	427.06	3261.0
2023-06-08 06:00:00	SPY	ETF	427.05	427.21	426.97	427.05	5390.0
2023-06-08 06:30:00	SPY	ETF	427.06	427.15	426.72	426.77	16354.0
2023-06-08 07:00:00	SPY	ETF	426.68	426.82	426.6	426.64	63503.0
2023-06-08 07:30:00	SPY	ETF	426.72	426.83	426.46	426.8	66019.0
2023-06-08 08:00:00	SPY	ETF	426.63	427.04	425.75	426.57	84698.0
2023-06-08 08:30:00	SPY	ETF	426.65	427.23	426.48	426.98	218307.0
2023-06-08 09:00:00	SPY	ETF	426.94	427.11	426.41	426.6	185032.0
2023-06-08 09:30:00	SPY	ETF	426.62	427.12	425.82	426.5	4906591.0
2023-06-08 10:00:00	SPY	ETF	426.505	427.46	426.31	427.39	3891710.0
2023-06-08 10:30:00	SPY	ETF	427.4	428.03	426.94	427.97	3739495.0
2023-06-08 11:00:00	SPY	ETF	427.98	428.2673	427.78	428.26	2610975.0
2023-06-08 11:30:00	SPY	ETF	428.25	428.35	427.9	428.0	2607296.0
2023-06-08 12:00:00	SPY	ETF	428.0	429.2	427.71	429.1	3352154.0
2023-06-08 12:30:00	SPY	ETF	429.095	429.12	428.335	428.6215	2741238.0
2023-06-08 13:00:00	SPY	ETF	428.63	428.83	428.3201	428.39	1835867.0
2023-06-08 13:30:00	SPY	ETF	428.39	428.48	427.71	428.21	2924357.0
2023-06-08 14:00:00	SPY	ETF	428.215	428.71	427.99	428.675	2067162.0
2023-06-08 14:30:00	SPY	ETF	428.68	429.08	428.68	428.95	2830058.0
2023-06-08 15:00:00	SPY	ETF	428.96	429.21	428.81	428.9516	3129655.0
2023-06-08 15:30:00	SPY	ETF	428.97	429.6	428.815	429.125	8481946.0
2023-06-08 16:00:00	SPY	ETF	429.11	429.14	428.84	428.97	3613295.0
2023-06-08 16:30:00	SPY	ETF	428.99	429.31	428.99	429.13	180675.0
2023-06-08 17:00:00	SPY	ETF	429.15	429.35	429.07	429.1	34033.0
2023-06-08 17:30:00	SPY	ETF	429.13	429.15	428.87	429.04	152149.0
2023-06-08 18:00:00	SPY	ETF	429.07	429.07	428.82	428.89	198667.0
2023-06-08 18:30:00	SPY	ETF	428.9	428.98	428.9	428.98	44880.0
2023-06-08 19:00:00	SPY	ETF	428.98	428.99	428.8396	428.9	18879.0
2023-06-08 19:30:00	SPY	ETF	428.91	428.97	428.8	428.84	46870.0
2023-06-08 04:00:00	QQQ	ETF	348.03	348.94	347.9	348.7	26035.0
2023-06-08 04:30:00	QQQ	ETF	348.84	349.0	348.66	348.76	28648.0
2023-06-08 05:00:00	QQQ	ETF	348.79	348.96	348.72	348.93	12872.0
2023-06-08 05:30:00	QQQ	ETF	348.89	349.34	348.76	349.29	26279.0
2023-06-08 06:00:00	QQQ	ETF	349.3	349.45	349.2	349.24	62976.0
2023-06-08 06:30:00	QQQ	ETF	349.27	349.39	348.81	348.99	38389.0
2023-06-08 07:00:00	QQQ	ETF	348.92	349.06	348.77	349.01	54909.0
2023-06-08 07:30:00	QQQ	ETF	348.91	348.96	348.45	348.7	82439.0
2023-06-08 08:00:00	QQQ	ETF	349.01	349.3104	347.36	348.31	240300.0
2023-06-08 08:30:00	QQQ	ETF	348.33	349.92	348.33	349.64	713013.0
2023-06-08 09:00:00	QQQ	ETF	349.74	349.89	349.09	349.13	324428.0
2023-06-08 09:30:00	QQQ	ETF	349.12	350.555	348.89	350.09	5701050.0
2023-06-08 10:00:00	QQQ	ETF	350.1	351.17	349.8	350.95	3527638.0
2023-06-08 10:30:00	QQQ	ETF	350.965	352.069	350.53	352.01	2580707.0
2023-06-08 11:00:00	QQQ	ETF	352.02	352.89	351.94	352.83	2620888.0
2023-06-08 11:30:00	QQQ	ETF	352.83	353.41	352.54	352.93	2596032.0
2023-06-08 12:00:00	QQQ	ETF	352.93	353.62	352.53	353.57	1933629.0
2023-06-08 12:30:00	QQQ	ETF	353.565	353.6	352.35	352.6077	2017591.0

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

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