PREVIEW / etf_30min / 2023-12-05

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-05.parquet
  size:    763 KB
  rows:    30,595

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-12-05 04:00:00	SPY	ETF	455.63	455.88	455.6	455.86	5132.0
2023-12-05 04:30:00	SPY	ETF	455.85	455.85	455.59	455.75	8800.0
2023-12-05 05:00:00	SPY	ETF	455.58	455.58	455.21	455.38	7767.0
2023-12-05 05:30:00	SPY	ETF	455.39	455.64	454.9	455.06	17284.0
2023-12-05 06:00:00	SPY	ETF	455.06	455.44	455.06	455.2	6377.0
2023-12-05 06:30:00	SPY	ETF	455.08	455.12	454.7	454.72	56361.0
2023-12-05 07:00:00	SPY	ETF	454.71	455.24	454.67	454.95	47148.0
2023-12-05 07:30:00	SPY	ETF	455.0	455.12	454.62	454.99	51002.0
2023-12-05 08:00:00	SPY	ETF	454.84	455.9104	454.68	455.46	172528.0
2023-12-05 08:30:00	SPY	ETF	455.46	455.66	455.01	455.04	102767.0
2023-12-05 09:00:00	SPY	ETF	455.03	455.36	454.63	455.26	256790.0
2023-12-05 09:30:00	SPY	ETF	455.26	455.7883	454.87	455.475	4411986.0
2023-12-05 10:00:00	SPY	ETF	455.46	457.0	455.38	456.3799	6341302.0
2023-12-05 10:30:00	SPY	ETF	456.38	457.41	456.175	457.3895	3748584.0
2023-12-05 11:00:00	SPY	ETF	457.39	457.59	455.58	456.27	4439563.0
2023-12-05 11:30:00	SPY	ETF	456.3	456.69	455.365	456.045	3149910.0
2023-12-05 12:00:00	SPY	ETF	456.06	456.44	455.86	456.275	2298318.0
2023-12-05 12:30:00	SPY	ETF	456.28	456.35	455.23	456.2362	2788857.0
2023-12-05 13:00:00	SPY	ETF	456.23	456.57	455.87	456.33	2287617.0
2023-12-05 13:30:00	SPY	ETF	456.33	456.54	455.98	456.19	2390729.0
2023-12-05 14:00:00	SPY	ETF	456.2	456.7	455.9	456.47	2239907.0
2023-12-05 14:30:00	SPY	ETF	456.47	456.7	455.985	456.6482	2387489.0
2023-12-05 15:00:00	SPY	ETF	456.65	456.79	456.425	456.53	2531312.0
2023-12-05 15:30:00	SPY	ETF	456.54	456.63	456.09	456.58	9690032.0
2023-12-05 16:00:00	SPY	ETF	456.58	456.83	456.4044	456.49	2538784.0
2023-12-05 16:30:00	SPY	ETF	456.53	456.53	456.27	456.32	103973.0
2023-12-05 17:00:00	SPY	ETF	456.35	456.43	456.26	456.41	38667.0
2023-12-05 17:30:00	SPY	ETF	456.42	456.5	456.34	456.41	15495.0
2023-12-05 18:00:00	SPY	ETF	456.4	456.45	456.2	456.4201	13039.0
2023-12-05 18:30:00	SPY	ETF	456.47	456.84	456.47	456.84	14542.0
2023-12-05 19:00:00	SPY	ETF	456.85	457.39	456.84	457.26	35785.0
2023-12-05 19:30:00	SPY	ETF	457.28	457.49	457.2	457.47	42618.0
2023-12-05 04:00:00	QQQ	ETF	384.69	385.08	384.69	384.87	14206.0
2023-12-05 04:30:00	QQQ	ETF	384.8	384.8	384.46	384.62	16186.0
2023-12-05 05:00:00	QQQ	ETF	384.55	384.55	383.94	384.25	22779.0
2023-12-05 05:30:00	QQQ	ETF	384.45	384.61	383.75	384.01	11955.0
2023-12-05 06:00:00	QQQ	ETF	383.98	384.45	383.93	384.16	10437.0
2023-12-05 06:30:00	QQQ	ETF	384.13	384.2	383.67	383.71	83572.0
2023-12-05 07:00:00	QQQ	ETF	383.78	384.47	383.73	384.16	78287.0
2023-12-05 07:30:00	QQQ	ETF	384.22	384.3	383.76	384.17	60579.0
2023-12-05 08:00:00	QQQ	ETF	384.71	386.609	383.71	384.92	149454.0
2023-12-05 08:30:00	QQQ	ETF	384.86	385.0	384.4841	384.56	86170.0
2023-12-05 09:00:00	QQQ	ETF	384.6	384.77	383.89	384.39	209498.0
2023-12-05 09:30:00	QQQ	ETF	384.38	386.15	384.21	385.9267	4037819.0
2023-12-05 10:00:00	QQQ	ETF	385.89	387.92	385.8	386.8309	4821462.0
2023-12-05 10:30:00	QQQ	ETF	386.84	388.49	386.735	388.28	3035899.0
2023-12-05 11:00:00	QQQ	ETF	388.28	388.5	386.02	386.475	3283401.0
2023-12-05 11:30:00	QQQ	ETF	386.47	387.1107	385.4	386.27	2017017.0
2023-12-05 12:00:00	QQQ	ETF	386.29	386.96	386.1577	386.691	1632183.0
2023-12-05 12:30:00	QQQ	ETF	386.71	386.76	385.29	386.3799	1590542.0

> showing 50 of 30,595 rows — these rows as CSV

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