PREVIEW / etf_30min / 2023-06-01

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-01.parquet
  size:    708 KB
  rows:    27,931

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-01 04:00:00	SPY	ETF	418.5	418.57	418.2	418.57	6977.0
2023-06-01 04:30:00	SPY	ETF	418.67	419.08	418.66	419.0	15157.0
2023-06-01 05:00:00	SPY	ETF	418.94	418.97	418.73	418.76	19095.0
2023-06-01 05:30:00	SPY	ETF	418.7	418.98	418.64	418.97	80713.0
2023-06-01 06:00:00	SPY	ETF	418.97	419.17	418.81	419.17	30738.0
2023-06-01 06:30:00	SPY	ETF	419.22	419.34	418.85	418.85	23410.0
2023-06-01 07:00:00	SPY	ETF	418.84	419.24	418.81	418.82	100622.0
2023-06-01 07:30:00	SPY	ETF	418.85	419.0	418.6	418.68	112507.0
2023-06-01 08:00:00	SPY	ETF	418.8805	419.22	417.6	418.39	417434.0
2023-06-01 08:30:00	SPY	ETF	418.45	418.84	417.84	418.05	307622.0
2023-06-01 09:00:00	SPY	ETF	418.04	418.3582	417.8	418.12	177984.0
2023-06-01 09:30:00	SPY	ETF	418.09	418.28	416.79	417.2	6465721.0
2023-06-01 10:00:00	SPY	ETF	417.27	418.75	417.21	418.01	5917203.0
2023-06-01 10:30:00	SPY	ETF	418.01	419.75	417.87	419.37	5710290.0
2023-06-01 11:00:00	SPY	ETF	419.38	420.31	419.18	420.17	4933207.0
2023-06-01 11:30:00	SPY	ETF	420.18	421.0942	420.09	421.055	4589713.0
2023-06-01 12:00:00	SPY	ETF	421.06	421.845	421.06	421.74	5324868.0
2023-06-01 12:30:00	SPY	ETF	421.75	421.81	421.2625	421.662	2947414.0
2023-06-01 13:00:00	SPY	ETF	421.67	421.9399	421.27	421.5	2570062.0
2023-06-01 13:30:00	SPY	ETF	421.5	422.08	421.31	422.08	2142157.0
2023-06-01 14:00:00	SPY	ETF	422.08	422.22	421.73	422.04	2508487.0
2023-06-01 14:30:00	SPY	ETF	422.045	422.5	421.795	422.43	2680089.0
2023-06-01 15:00:00	SPY	ETF	422.432	422.92	421.79	421.9	5378183.0
2023-06-01 15:30:00	SPY	ETF	421.895	421.98	420.87	421.81	13765858.0
2023-06-01 16:00:00	SPY	ETF	421.81	422.2	421.59	422.07	3680980.0
2023-06-01 16:30:00	SPY	ETF	422.01	422.2	421.82	422.13	150658.0
2023-06-01 17:00:00	SPY	ETF	422.11	422.5	421.82	422.35	103111.0
2023-06-01 17:30:00	SPY	ETF	422.32	422.38	422.21	422.21	19140.0
2023-06-01 18:00:00	SPY	ETF	422.18	422.22	422.08	422.08	39664.0
2023-06-01 18:30:00	SPY	ETF	422.1	422.19	422.05	422.19	25526.0
2023-06-01 19:00:00	SPY	ETF	422.18	422.18	422.04	422.1	12951.0
2023-06-01 19:30:00	SPY	ETF	422.09	422.12	421.95	422.0	61563.0
2023-06-01 04:00:00	QQQ	ETF	347.75	347.84	347.3	347.61	16345.0
2023-06-01 04:30:00	QQQ	ETF	347.77	348.12	347.74	348.08	16847.0
2023-06-01 05:00:00	QQQ	ETF	348.05	348.05	347.7	347.7	7422.0
2023-06-01 05:30:00	QQQ	ETF	347.68	347.94	347.65	347.93	7706.0
2023-06-01 06:00:00	QQQ	ETF	347.87	348.07	347.79	348.07	7849.0
2023-06-01 06:30:00	QQQ	ETF	348.09	348.53	348.09	348.25	33843.0
2023-06-01 07:00:00	QQQ	ETF	348.18	348.68	348.12	348.36	37676.0
2023-06-01 07:30:00	QQQ	ETF	348.31	348.33	347.94	348.02	104502.0
2023-06-01 08:00:00	QQQ	ETF	348.2988	348.6	347.1	347.41	327926.0
2023-06-01 08:30:00	QQQ	ETF	347.61	348.27	347.38	347.71	258770.0
2023-06-01 09:00:00	QQQ	ETF	347.63	348.3	347.45	347.72	298706.0
2023-06-01 09:30:00	QQQ	ETF	347.73	348.37	346.66	348.06	5187128.0
2023-06-01 10:00:00	QQQ	ETF	348.07	348.82	347.17	347.87	3821370.0
2023-06-01 10:30:00	QQQ	ETF	347.87	349.84	347.54	349.22	2974263.0
2023-06-01 11:00:00	QQQ	ETF	349.23	350.315	348.92	349.84	2163709.0
2023-06-01 11:30:00	QQQ	ETF	349.83	350.82	349.74	350.81	2075879.0
2023-06-01 12:00:00	QQQ	ETF	350.805	351.8	350.805	351.6	2180465.0
2023-06-01 12:30:00	QQQ	ETF	351.6	351.85	351.32	351.76	1765954.0

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

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