PREVIEW / etf_30min / 2022-08-18

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-18.parquet
  size:    650 KB
  rows:    25,178

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
2022-08-18 04:00:00	SPY	ETF	425.67	426.0	425.41	425.5	21157.0
2022-08-18 04:30:00	SPY	ETF	425.52	426.41	425.43	426.38	13436.0
2022-08-18 05:00:00	SPY	ETF	426.43	426.94	426.4	426.89	9915.0
2022-08-18 05:30:00	SPY	ETF	426.84	427.3	426.77	427.28	17454.0
2022-08-18 06:00:00	SPY	ETF	427.35	427.78	427.3	427.37	31441.0
2022-08-18 06:30:00	SPY	ETF	427.4	427.59	427.05	427.18	13744.0
2022-08-18 07:00:00	SPY	ETF	427.13	427.4	426.95	426.96	69884.0
2022-08-18 07:30:00	SPY	ETF	427.0	427.67	426.98	427.67	107483.0
2022-08-18 08:00:00	SPY	ETF	425.55	428.35	425.42	427.53	650033.0
2022-08-18 08:30:00	SPY	ETF	427.51	427.59	426.95	427.32	204043.0
2022-08-18 09:00:00	SPY	ETF	427.48	427.54	426.74	426.84	203483.0
2022-08-18 09:30:00	SPY	ETF	426.86	427.02	425.81	426.0201	3414813.0
2022-08-18 10:00:00	SPY	ETF	426.01	426.64	425.5	426.147	2894542.0
2022-08-18 10:30:00	SPY	ETF	426.1675	427.3598	425.7813	426.736	2508951.0
2022-08-18 11:00:00	SPY	ETF	426.74	427.64	426.13	427.511	2128417.0
2022-08-18 11:30:00	SPY	ETF	427.525	428.14	427.33	427.6499	2200529.0
2022-08-18 12:00:00	SPY	ETF	427.6406	427.92	426.4201	426.6	2196475.0
2022-08-18 12:30:00	SPY	ETF	426.5951	426.74	425.88	426.39	1508296.0
2022-08-18 13:00:00	SPY	ETF	426.39	427.16	426.19	427.02	2092766.0
2022-08-18 13:30:00	SPY	ETF	427.04	427.39	426.76	426.9957	1584888.0
2022-08-18 14:00:00	SPY	ETF	426.99	427.54	426.755	427.41	1403265.0
2022-08-18 14:30:00	SPY	ETF	427.4	427.85	426.94	427.6328	1567357.0
2022-08-18 15:00:00	SPY	ETF	427.64	428.46	427.52	428.34	2450407.0
2022-08-18 15:30:00	SPY	ETF	428.35	428.61	427.27	427.83	6706256.0
2022-08-18 16:00:00	SPY	ETF	427.83	428.0	427.52	427.8	3941718.0
2022-08-18 16:30:00	SPY	ETF	427.8	427.91	427.79	427.88	79308.0
2022-08-18 17:00:00	SPY	ETF	427.91	427.91	427.74	427.85	42653.0
2022-08-18 17:30:00	SPY	ETF	427.81	427.82	427.75	427.75	9435.0
2022-08-18 18:00:00	SPY	ETF	427.75	427.8	427.43	427.67	41812.0
2022-08-18 18:30:00	SPY	ETF	427.66	427.7	427.48	427.48	16417.0
2022-08-18 19:00:00	SPY	ETF	427.57	427.6	427.5	427.6	46935.0
2022-08-18 19:30:00	SPY	ETF	427.59	427.65	427.41	427.62	42734.0
2022-08-18 04:00:00	QQQ	ETF	327.46	327.75	327.2	327.23	17129.0
2022-08-18 04:30:00	QQQ	ETF	327.26	328.12	327.26	328.09	26839.0
2022-08-18 05:00:00	QQQ	ETF	328.08	328.51	328.02	328.51	13993.0
2022-08-18 05:30:00	QQQ	ETF	328.45	329.07	328.39	328.86	20987.0
2022-08-18 06:00:00	QQQ	ETF	329.03	329.37	328.76	328.93	19325.0
2022-08-18 06:30:00	QQQ	ETF	328.99	329.12	328.55	328.65	17707.0
2022-08-18 07:00:00	QQQ	ETF	328.59	328.96	328.54	328.65	92909.0
2022-08-18 07:30:00	QQQ	ETF	328.62	329.38	328.6	329.37	84726.0
2022-08-18 08:00:00	QQQ	ETF	328.5113	330.06	326.9	329.4	262950.0
2022-08-18 08:30:00	QQQ	ETF	329.35	329.35	328.66	329.12	191742.0
2022-08-18 09:00:00	QQQ	ETF	329.12	329.13	328.27	328.44	218296.0
2022-08-18 09:30:00	QQQ	ETF	328.44	328.72	327.12	327.5001	3517963.0
2022-08-18 10:00:00	QQQ	ETF	327.49	328.62	326.79	327.91	2146789.0
2022-08-18 10:30:00	QQQ	ETF	327.92	329.4801	327.54	328.9191	2088407.0
2022-08-18 11:00:00	QQQ	ETF	328.92	330.1	328.36	329.96	2046871.0
2022-08-18 11:30:00	QQQ	ETF	329.98	330.49	329.74	330.0	1507484.0
2022-08-18 12:00:00	QQQ	ETF	330.03	330.31	328.77	329.035	1635602.0
2022-08-18 12:30:00	QQQ	ETF	329.04	329.19	328.2601	328.94	1282269.0

> showing 50 of 25,178 rows — these rows as CSV

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