PREVIEW / etf_30min / 2023-01-13

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-13.parquet
  size:    694 KB
  rows:    27,474

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-13 04:00:00	SPY	ETF	396.92	397.2	396.5	396.5	26794.0
2023-01-13 04:30:00	SPY	ETF	396.51	397.23	396.51	397.05	24621.0
2023-01-13 05:00:00	SPY	ETF	397.06	397.31	396.99	397.06	16335.0
2023-01-13 05:30:00	SPY	ETF	397.03	397.12	396.84	397.07	5487.0
2023-01-13 06:00:00	SPY	ETF	397.0	397.0	396.24	396.27	36343.0
2023-01-13 06:30:00	SPY	ETF	396.26	396.26	395.38	395.51	109894.0
2023-01-13 07:00:00	SPY	ETF	395.56	395.79	394.14	394.18	96219.0
2023-01-13 07:30:00	SPY	ETF	394.18	394.62	393.43	393.5	237507.0
2023-01-13 08:00:00	SPY	ETF	395.65	397.1504	393.16	393.3	282906.0
2023-01-13 08:30:00	SPY	ETF	393.25	393.61	392.97	393.34	225657.0
2023-01-13 09:00:00	SPY	ETF	393.5	393.75	393.02	393.64	255987.0
2023-01-13 09:30:00	SPY	ETF	393.62	395.22	393.34	394.73	5376205.0
2023-01-13 10:00:00	SPY	ETF	394.75	396.56	394.33	396.49	5289551.0
2023-01-13 10:30:00	SPY	ETF	396.5	396.76	395.86	396.38	3208173.0
2023-01-13 11:00:00	SPY	ETF	396.3799	396.58	395.37	395.99	2821641.0
2023-01-13 11:30:00	SPY	ETF	396.01	396.06	395.23	395.8	2337478.0
2023-01-13 12:00:00	SPY	ETF	395.81	396.59	395.715	396.48	1774791.0
2023-01-13 12:30:00	SPY	ETF	396.48	396.835	396.02	396.7	1741349.0
2023-01-13 13:00:00	SPY	ETF	396.695	396.92	396.0901	396.4499	1930195.0
2023-01-13 13:30:00	SPY	ETF	396.45	397.67	396.33	397.52	2834272.0
2023-01-13 14:00:00	SPY	ETF	397.5125	397.77	397.16	397.58	2496351.0
2023-01-13 14:30:00	SPY	ETF	397.59	397.84	397.31	397.64	2667838.0
2023-01-13 15:00:00	SPY	ETF	397.66	398.3	397.6	398.2806	3092575.0
2023-01-13 15:30:00	SPY	ETF	398.3	399.1	398.17	398.47	8433936.0
2023-01-13 16:00:00	SPY	ETF	398.48	398.59	398.11	398.49	2327088.0
2023-01-13 16:30:00	SPY	ETF	398.47	398.66	398.46	398.6	478219.0
2023-01-13 17:00:00	SPY	ETF	398.5	398.61	398.39	398.39	682280.0
2023-01-13 17:30:00	SPY	ETF	398.41	398.7	398.3	398.4	52807.0
2023-01-13 18:00:00	SPY	ETF	398.4	398.49	398.27	398.27	9839.0
2023-01-13 18:30:00	SPY	ETF	398.35	398.35	398.25	398.3	7701.0
2023-01-13 19:00:00	SPY	ETF	398.3	398.34	398.23	398.3	2436.0
2023-01-13 19:30:00	SPY	ETF	398.26	398.5	398.2	398.4	13293.0
2023-01-13 04:00:00	QQQ	ETF	278.95	279.0	278.29	278.45	26652.0
2023-01-13 04:30:00	QQQ	ETF	278.29	278.93	278.29	278.93	9446.0
2023-01-13 05:00:00	QQQ	ETF	278.74	279.075	278.74	278.87	6737.0
2023-01-13 05:30:00	QQQ	ETF	278.84	278.86	278.58	278.75	16453.0
2023-01-13 06:00:00	QQQ	ETF	278.62	278.62	278.02	278.1	26227.0
2023-01-13 06:30:00	QQQ	ETF	278.03	278.14	277.36	277.74	162034.0
2023-01-13 07:00:00	QQQ	ETF	277.74	277.9	276.76	276.86	139475.0
2023-01-13 07:30:00	QQQ	ETF	276.8	277.21	276.06	276.2	191698.0
2023-01-13 08:00:00	QQQ	ETF	276.25	278.88	275.81	276.08	322261.0
2023-01-13 08:30:00	QQQ	ETF	276.04	276.3	275.82	276.05	306306.0
2023-01-13 09:00:00	QQQ	ETF	276.08	276.58	275.71	276.54	512929.0
2023-01-13 09:30:00	QQQ	ETF	276.52	277.81	276.16	277.32	4582818.0
2023-01-13 10:00:00	QQQ	ETF	277.3	278.88	276.97	278.7901	3752974.0
2023-01-13 10:30:00	QQQ	ETF	278.8	279.27	278.26	278.77	2181423.0
2023-01-13 11:00:00	QQQ	ETF	278.76	278.96	277.445	277.98	1968535.0
2023-01-13 11:30:00	QQQ	ETF	278.01	278.05	277.2301	277.9999	1780420.0
2023-01-13 12:00:00	QQQ	ETF	277.98	278.86	277.8899	278.74	1203040.0
2023-01-13 12:30:00	QQQ	ETF	278.75	279.04	278.37	278.95	1232817.0

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

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