PREVIEW / etf_30min / 2023-09-15

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-15.parquet
  size:    696 KB
  rows:    27,471

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-09-15 04:00:00	SPY	ETF	445.0	449.68	445.0	449.18	22469.0
2023-09-15 04:30:00	SPY	ETF	449.16	449.26	449.1	449.1	19132.0
2023-09-15 05:00:00	SPY	ETF	449.11	449.39	449.06	449.21	24683.0
2023-09-15 05:30:00	SPY	ETF	449.2	449.44	449.2	449.44	4985.0
2023-09-15 06:00:00	SPY	ETF	449.34	449.59	449.22	449.45	18958.0
2023-09-15 06:30:00	SPY	ETF	449.44	449.6	449.36	449.6	11887.0
2023-09-15 07:00:00	SPY	ETF	449.59	449.6	449.2	449.36	49229.0
2023-09-15 07:30:00	SPY	ETF	449.34	449.4	449.06	449.09	126520.0
2023-09-15 08:00:00	SPY	ETF	449.4182	449.93	448.95	449.06	231239.0
2023-09-15 08:30:00	SPY	ETF	449.04	449.06	448.18	448.22	471450.0
2023-09-15 09:00:00	SPY	ETF	448.21	448.49	446.86	447.12	1041518.0
2023-09-15 09:30:00	SPY	ETF	447.15	447.48	446.0	446.3965	8460195.0
2023-09-15 10:00:00	SPY	ETF	446.4	446.935	445.57	445.98	6942664.0
2023-09-15 10:30:00	SPY	ETF	446.0	446.2399	444.53	444.55	5816907.0
2023-09-15 11:00:00	SPY	ETF	444.551	445.01	444.28	445.0	5198361.0
2023-09-15 11:30:00	SPY	ETF	444.995	445.32	444.6	445.095	3359055.0
2023-09-15 12:00:00	SPY	ETF	445.1	445.28	444.86	444.9391	2490607.0
2023-09-15 12:30:00	SPY	ETF	444.93	445.38	444.83	445.18	2264599.0
2023-09-15 13:00:00	SPY	ETF	445.18	445.19	443.331	443.445	3965506.0
2023-09-15 13:30:00	SPY	ETF	443.43	444.1795	443.02	443.97	4384685.0
2023-09-15 14:00:00	SPY	ETF	443.98	443.99	443.18	443.29	4792207.0
2023-09-15 14:30:00	SPY	ETF	443.28	443.91	443.2	443.87	3375736.0
2023-09-15 15:00:00	SPY	ETF	443.875	443.9	443.27	443.72	4003270.0
2023-09-15 15:30:00	SPY	ETF	443.72	443.99	442.92	443.29	17618416.0
2023-09-15 16:00:00	SPY	ETF	443.29	446.1295	443.0	443.61	8145394.0
2023-09-15 16:30:00	SPY	ETF	443.62	443.73	443.37	443.47	354517.0
2023-09-15 17:00:00	SPY	ETF	443.4	443.74	443.37	443.63	93221.0
2023-09-15 17:30:00	SPY	ETF	443.53	443.9	443.45	443.45	72933.0
2023-09-15 18:00:00	SPY	ETF	443.59	443.6098	443.49	443.58	16424.0
2023-09-15 18:30:00	SPY	ETF	443.58	443.66	443.55	443.55	6047.0
2023-09-15 19:00:00	SPY	ETF	443.63	443.63	443.55	443.56	2639.0
2023-09-15 19:30:00	SPY	ETF	443.59	443.59	443.29	443.29	23363.0
2023-09-15 04:00:00	QQQ	ETF	377.47	377.57	377.15	377.23	43916.0
2023-09-15 04:30:00	QQQ	ETF	377.2	377.32	376.93	376.97	10781.0
2023-09-15 05:00:00	QQQ	ETF	376.94	377.17	376.7	376.9	23794.0
2023-09-15 05:30:00	QQQ	ETF	376.87	377.16	376.84	377.07	10201.0
2023-09-15 06:00:00	QQQ	ETF	376.96	377.24	376.91	377.16	11444.0
2023-09-15 06:30:00	QQQ	ETF	377.07	377.32	377.07	377.31	7837.0
2023-09-15 07:00:00	QQQ	ETF	377.27	377.4	376.94	377.07	28652.0
2023-09-15 07:30:00	QQQ	ETF	377.06	377.17	376.84	376.85	67371.0
2023-09-15 08:00:00	QQQ	ETF	377.36	378.42	376.8	376.91	115306.0
2023-09-15 08:30:00	QQQ	ETF	376.9	376.91	376.11	376.14	326369.0
2023-09-15 09:00:00	QQQ	ETF	376.14	376.45	375.45	375.96	708014.0
2023-09-15 09:30:00	QQQ	ETF	375.91	376.32	373.05	373.61	5469870.0
2023-09-15 10:00:00	QQQ	ETF	373.65	374.07	372.57	373.2	4146501.0
2023-09-15 10:30:00	QQQ	ETF	373.21	373.45	371.45	371.452	3890771.0
2023-09-15 11:00:00	QQQ	ETF	371.46	372.078	371.24	371.63	2711299.0
2023-09-15 11:30:00	QQQ	ETF	371.62	372.02	371.19	371.6888	3313533.0
2023-09-15 12:00:00	QQQ	ETF	371.7	372.0499	371.485	371.76	2467770.0
2023-09-15 12:30:00	QQQ	ETF	371.775	372.5085	371.64	372.37	1557171.0

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

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