PREVIEW / etf_30min / 2021-12-13

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-13.parquet
  size:    645 KB
  rows:    24,933

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
2021-12-13 04:00:00	SPY	ETF	471.53	472.4	471.53	472.33	13950.0
2021-12-13 04:30:00	SPY	ETF	472.4	472.53	472.2	472.2	4824.0
2021-12-13 05:00:00	SPY	ETF	472.29	472.4	471.82	471.93	13919.0
2021-12-13 05:30:00	SPY	ETF	472.03	472.23	471.94	472.08	7866.0
2021-12-13 06:00:00	SPY	ETF	472.16	472.54	472.16	472.29	5712.0
2021-12-13 06:30:00	SPY	ETF	472.28	472.28	471.7	472.05	33974.0
2021-12-13 07:00:00	SPY	ETF	472.08	472.1	471.5	471.75	87406.0
2021-12-13 07:30:00	SPY	ETF	471.74	471.86	471.48	471.55	57343.0
2021-12-13 08:00:00	SPY	ETF	471.8101	472.3	471.42	471.66	105030.0
2021-12-13 08:30:00	SPY	ETF	471.68	471.89	471.31	471.44	153420.0
2021-12-13 09:00:00	SPY	ETF	471.4	471.41	470.19	470.19	319729.0
2021-12-13 09:30:00	SPY	ETF	470.19	470.56	468.38	468.71	7202498.0
2021-12-13 10:00:00	SPY	ETF	468.7	469.39	467.385	467.81	4944264.0
2021-12-13 10:30:00	SPY	ETF	467.815	468.4499	467.25	467.78	4096230.0
2021-12-13 11:00:00	SPY	ETF	467.78	468.0	466.78	466.99	4956794.0
2021-12-13 11:30:00	SPY	ETF	467.0	467.53	466.76	467.335	3784082.0
2021-12-13 12:00:00	SPY	ETF	467.32	467.98	466.76	467.86	2895718.0
2021-12-13 12:30:00	SPY	ETF	467.85	468.13	467.25	467.52	1733781.0
2021-12-13 13:00:00	SPY	ETF	467.52	467.92	467.32	467.49	1335871.0
2021-12-13 13:30:00	SPY	ETF	467.51	467.85	467.0	467.75	1884017.0
2021-12-13 14:00:00	SPY	ETF	467.74	468.3	467.39	467.98	2654653.0
2021-12-13 14:30:00	SPY	ETF	467.97	468.25	467.72	468.23	1975355.0
2021-12-13 15:00:00	SPY	ETF	468.23	468.63	467.855	467.88	4857885.0
2021-12-13 15:30:00	SPY	ETF	467.87	468.61	466.27	466.61	13877258.0
2021-12-13 16:00:00	SPY	ETF	466.62	466.87	466.1	466.66	4377967.0
2021-12-13 16:30:00	SPY	ETF	466.67	467.12	466.57	466.92	144946.0
2021-12-13 17:00:00	SPY	ETF	466.95	467.11	466.8	466.89	36707.0
2021-12-13 17:30:00	SPY	ETF	466.89	466.93	466.71	466.86	35619.0
2021-12-13 18:00:00	SPY	ETF	466.86	467.24	466.71	466.74	41650.0
2021-12-13 18:30:00	SPY	ETF	466.57	467.14	466.57	467.01	12943.0
2021-12-13 19:00:00	SPY	ETF	467.09	467.42	467.09	467.24	45118.0
2021-12-13 19:30:00	SPY	ETF	467.22	467.48	467.15	467.45	39759.0
2021-12-13 04:00:00	QQQ	ETF	398.71	399.72	398.71	399.61	13694.0
2021-12-13 04:30:00	QQQ	ETF	399.73	399.73	399.58	399.62	2963.0
2021-12-13 05:00:00	QQQ	ETF	399.66	399.71	399.35	399.5	7315.0
2021-12-13 05:30:00	QQQ	ETF	399.54	399.8	399.53	399.76	10284.0
2021-12-13 06:00:00	QQQ	ETF	399.81	399.93	399.76	399.87	4949.0
2021-12-13 06:30:00	QQQ	ETF	399.8	400.06	399.45	399.7	16506.0
2021-12-13 07:00:00	QQQ	ETF	399.71	399.76	399.35	399.75	38148.0
2021-12-13 07:30:00	QQQ	ETF	399.7	399.81	399.5	399.6	15977.0
2021-12-13 08:00:00	QQQ	ETF	399.3004	400.0004	398.308	399.54	74104.0
2021-12-13 08:30:00	QQQ	ETF	399.54	399.75	398.01	399.47	65050.0
2021-12-13 09:00:00	QQQ	ETF	399.43	399.45	398.02	398.02	174842.0
2021-12-13 09:30:00	QQQ	ETF	398.0	398.325	396.3	396.77	4521710.0
2021-12-13 10:00:00	QQQ	ETF	396.78	397.7195	394.83	395.34	3706016.0
2021-12-13 10:30:00	QQQ	ETF	395.34	395.825	394.53	395.16	2951999.0
2021-12-13 11:00:00	QQQ	ETF	395.15	395.41	393.6	394.01	2708080.0
2021-12-13 11:30:00	QQQ	ETF	394.02	394.36	392.82	393.446	2755354.0
2021-12-13 12:00:00	QQQ	ETF	393.43	394.369	392.96	394.3	2019008.0
2021-12-13 12:30:00	QQQ	ETF	394.3	394.73	393.72	394.04	1456922.0

> showing 50 of 24,933 rows — these rows as CSV

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