PREVIEW / etf_30min / 2023-11-01

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-01.parquet
  size:    731 KB
  rows:    29,436

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-01 04:00:00	SPY	ETF	417.5	417.8	416.95	416.95	12404.0
2023-11-01 04:30:00	SPY	ETF	417.0	417.32	416.65	416.88	6081.0
2023-11-01 05:00:00	SPY	ETF	416.89	417.2	416.65	416.65	6760.0
2023-11-01 05:30:00	SPY	ETF	416.93	416.93	416.51	416.66	4576.0
2023-11-01 06:00:00	SPY	ETF	416.71	416.71	416.39	416.68	4605.0
2023-11-01 06:30:00	SPY	ETF	416.68	417.08	416.58	416.86	86852.0
2023-11-01 07:00:00	SPY	ETF	416.86	417.0	416.5	416.58	59980.0
2023-11-01 07:30:00	SPY	ETF	416.54	416.84	416.24	416.5	172297.0
2023-11-01 08:00:00	SPY	ETF	416.68	418.13	416.28	417.01	235329.0
2023-11-01 08:30:00	SPY	ETF	417.05	418.78	417.05	418.44	650754.0
2023-11-01 09:00:00	SPY	ETF	418.42	419.51	417.82	419.22	486039.0
2023-11-01 09:30:00	SPY	ETF	419.2	419.88	418.6499	419.475	5927518.0
2023-11-01 10:00:00	SPY	ETF	419.49	421.46	419.17	421.165	7362789.0
2023-11-01 10:30:00	SPY	ETF	421.16	421.9	421.04	421.25	5002098.0
2023-11-01 11:00:00	SPY	ETF	421.26	421.615	420.2282	420.39	4458452.0
2023-11-01 11:30:00	SPY	ETF	420.39	420.88	420.235	420.7209	2614411.0
2023-11-01 12:00:00	SPY	ETF	420.735	420.735	419.83	420.02	2786165.0
2023-11-01 12:30:00	SPY	ETF	420.02	420.36	419.3	419.75	2764873.0
2023-11-01 13:00:00	SPY	ETF	419.755	420.41	419.45	419.82	2557928.0
2023-11-01 13:30:00	SPY	ETF	419.81	420.26	419.375	420.14	2532569.0
2023-11-01 14:00:00	SPY	ETF	420.1	420.96	419.31	420.4	5196829.0
2023-11-01 14:30:00	SPY	ETF	420.42	421.76	419.08	421.3543	11223483.0
2023-11-01 15:00:00	SPY	ETF	421.36	423.35	421.34	422.83	10179447.0
2023-11-01 15:30:00	SPY	ETF	422.82	423.5	422.51	422.7	12765178.0
2023-11-01 16:00:00	SPY	ETF	422.7	422.83	420.4233	422.51	2608985.0
2023-11-01 16:30:00	SPY	ETF	422.53	422.88	422.52	422.84	310489.0
2023-11-01 17:00:00	SPY	ETF	422.87	422.99	422.7	422.98	49649.0
2023-11-01 17:30:00	SPY	ETF	422.99	423.1	422.91	422.98	16925.0
2023-11-01 18:00:00	SPY	ETF	422.97	423.15	422.85	422.86	29841.0
2023-11-01 18:30:00	SPY	ETF	422.9	423.1	422.87	423.05	10095.0
2023-11-01 19:00:00	SPY	ETF	423.06	423.62	423.01	423.4783	49622.0
2023-11-01 19:30:00	SPY	ETF	423.45	423.63	423.38	423.63	78367.0
2023-11-01 04:00:00	QQQ	ETF	350.41	350.5	349.73	349.73	35424.0
2023-11-01 04:30:00	QQQ	ETF	349.79	350.1	349.53	349.77	33897.0
2023-11-01 05:00:00	QQQ	ETF	349.75	350.0	349.36	349.47	7739.0
2023-11-01 05:30:00	QQQ	ETF	349.7	349.71	349.35	349.49	17700.0
2023-11-01 06:00:00	QQQ	ETF	349.51	349.63	349.27	349.51	27859.0
2023-11-01 06:30:00	QQQ	ETF	349.53	349.88	349.53	349.65	11706.0
2023-11-01 07:00:00	QQQ	ETF	349.71	349.87	349.38	349.41	70479.0
2023-11-01 07:30:00	QQQ	ETF	349.36	349.609	349.1	349.28	73477.0
2023-11-01 08:00:00	QQQ	ETF	349.7	351.133	349.1499	349.8	197897.0
2023-11-01 08:30:00	QQQ	ETF	349.82	351.56	349.82	351.16	526194.0
2023-11-01 09:00:00	QQQ	ETF	351.16	352.05	350.48	351.72	384610.0
2023-11-01 09:30:00	QQQ	ETF	351.72	353.2	351.62	352.38	4614231.0
2023-11-01 10:00:00	QQQ	ETF	352.41	354.58	351.94	354.4	4981287.0
2023-11-01 10:30:00	QQQ	ETF	354.39	354.83	353.99	354.195	2960559.0
2023-11-01 11:00:00	QQQ	ETF	354.19	354.66	353.22	353.4196	2122610.0
2023-11-01 11:30:00	QQQ	ETF	353.39	354.11	353.08	353.89	1517163.0
2023-11-01 12:00:00	QQQ	ETF	353.9	354.0187	353.22	353.55	1446020.0
2023-11-01 12:30:00	QQQ	ETF	353.53	353.94	352.73	353.3099	1616054.0

> showing 50 of 29,436 rows — these rows as CSV

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