PREVIEW / etf_30min / 2021-01-06

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-06.parquet
  size:    648 KB
  rows:    24,665

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-01-06 04:00:00	SPY	ETF	368.66	369.8	368.04	369.47	77923.0
2021-01-06 04:30:00	SPY	ETF	369.36	370.64	369.36	370.13	64600.0
2021-01-06 05:00:00	SPY	ETF	370.37	370.69	369.9	369.9	36836.0
2021-01-06 05:30:00	SPY	ETF	369.89	371.0	369.89	370.47	92558.0
2021-01-06 06:00:00	SPY	ETF	370.43	370.47	369.3	370.0	93751.0
2021-01-06 06:30:00	SPY	ETF	369.87	370.61	369.75	370.45	57046.0
2021-01-06 07:00:00	SPY	ETF	370.43	371.41	370.35	370.97	325794.0
2021-01-06 07:30:00	SPY	ETF	370.97	371.19	369.85	369.95	629649.0
2021-01-06 08:00:00	SPY	ETF	369.92	371.41	368.86	370.59	653533.0
2021-01-06 08:30:00	SPY	ETF	370.6	370.61	369.16	369.46	260356.0
2021-01-06 09:00:00	SPY	ETF	369.41	369.91	369.34	369.71	290482.0
2021-01-06 09:30:00	SPY	ETF	369.71	372.41	369.12	372.23	9153079.0
2021-01-06 10:00:00	SPY	ETF	372.2463	373.9799	371.96	373.8	6493239.0
2021-01-06 10:30:00	SPY	ETF	373.79	375.75	373.79	375.1031	6429705.0
2021-01-06 11:00:00	SPY	ETF	375.11	376.16	375.02	375.8801	4611244.0
2021-01-06 11:30:00	SPY	ETF	375.89	376.06	375.1	375.4	3351653.0
2021-01-06 12:00:00	SPY	ETF	375.42	376.04	375.38	375.7335	2441987.0
2021-01-06 12:30:00	SPY	ETF	375.73	376.58	375.73	376.44	4431282.0
2021-01-06 13:00:00	SPY	ETF	376.445	376.98	376.085	376.13	3391789.0
2021-01-06 13:30:00	SPY	ETF	376.13	376.98	376.11	376.4899	2513555.0
2021-01-06 14:00:00	SPY	ETF	376.48	376.9	374.31	374.6699	7202174.0
2021-01-06 14:30:00	SPY	ETF	374.66	375.7	373.0	374.475	12688990.0
2021-01-06 15:00:00	SPY	ETF	374.47	375.18	372.88	374.21	10472413.0
2021-01-06 15:30:00	SPY	ETF	374.2	374.66	372.83	373.53	18881449.0
2021-01-06 16:00:00	SPY	ETF	373.43	374.17	372.6	374.0	6393801.0
2021-01-06 16:30:00	SPY	ETF	374.0	374.97	373.95	374.35	634044.0
2021-01-06 17:00:00	SPY	ETF	374.26	374.65	373.55	374.64	3924448.0
2021-01-06 17:30:00	SPY	ETF	374.6	375.0	374.46	374.75	90597.0
2021-01-06 18:00:00	SPY	ETF	374.73	374.84	374.2	374.51	897587.0
2021-01-06 18:30:00	SPY	ETF	374.43	374.69	374.15	374.47	105434.0
2021-01-06 19:00:00	SPY	ETF	374.4	374.55	373.8	374.04	218389.0
2021-01-06 19:30:00	SPY	ETF	374.06	375.01	374.06	375.0	191334.0
2021-01-06 04:00:00	QQQ	ETF	305.22	306.18	305.19	305.89	119024.0
2021-01-06 04:30:00	QQQ	ETF	305.94	306.99	305.83	306.72	70416.0
2021-01-06 05:00:00	QQQ	ETF	306.76	306.76	305.87	305.87	152255.0
2021-01-06 05:30:00	QQQ	ETF	305.87	306.41	305.39	305.83	131741.0
2021-01-06 06:00:00	QQQ	ETF	305.79	305.96	304.83	305.54	119539.0
2021-01-06 06:30:00	QQQ	ETF	305.59	306.74	305.45	306.57	133393.0
2021-01-06 07:00:00	QQQ	ETF	306.62	308.06	306.57	307.79	359126.0
2021-01-06 07:30:00	QQQ	ETF	307.85	308.02	306.93	307.06	457377.0
2021-01-06 08:00:00	QQQ	ETF	306.99	308.51	304.84	308.0	440869.0
2021-01-06 08:30:00	QQQ	ETF	308.0	308.0	306.2	306.53	623799.0
2021-01-06 09:00:00	QQQ	ETF	306.42	307.41	306.27	307.04	696808.0
2021-01-06 09:30:00	QQQ	ETF	307.08	308.81	305.98	308.0	6889512.0
2021-01-06 10:00:00	QQQ	ETF	308.01	309.87	307.4802	309.6	3573091.0
2021-01-06 10:30:00	QQQ	ETF	309.59	311.22	309.59	310.38	2525971.0
2021-01-06 11:00:00	QQQ	ETF	310.4	311.66	310.2	311.28	2392275.0
2021-01-06 11:30:00	QQQ	ETF	311.32	311.6	310.505	310.83	1486682.0
2021-01-06 12:00:00	QQQ	ETF	310.865	311.88	310.79	311.38	1657106.0
2021-01-06 12:30:00	QQQ	ETF	311.38	311.61	310.9	311.17	1170064.0

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

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