PREVIEW / etf_30min / 2021-01-29

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-29.parquet
  size:    646 KB
  rows:    24,748

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-29 04:00:00	SPY	ETF	373.96	374.64	373.24	374.17	81505.0
2021-01-29 04:30:00	SPY	ETF	373.94	374.79	373.45	373.74	46339.0
2021-01-29 05:00:00	SPY	ETF	373.47	373.57	372.85	373.27	23436.0
2021-01-29 05:30:00	SPY	ETF	373.2	374.26	373.2	374.18	42391.0
2021-01-29 06:00:00	SPY	ETF	374.18	375.5	373.62	375.19	214313.0
2021-01-29 06:30:00	SPY	ETF	375.22	376.1	375.0	375.24	186669.0
2021-01-29 07:00:00	SPY	ETF	375.28	375.7	375.06	375.65	215802.0
2021-01-29 07:30:00	SPY	ETF	375.65	375.89	374.26	374.53	292775.0
2021-01-29 08:00:00	SPY	ETF	374.45	376.64	372.31	374.46	2416218.0
2021-01-29 08:30:00	SPY	ETF	374.4999	377.07	374.48	376.13	1308234.0
2021-01-29 09:00:00	SPY	ETF	376.12	376.5	375.62	375.62	585184.0
2021-01-29 09:30:00	SPY	ETF	375.61	375.77	373.15	375.18	9084841.0
2021-01-29 10:00:00	SPY	ETF	375.19	376.595	374.52	376.25	5051458.0
2021-01-29 10:30:00	SPY	ETF	376.2679	376.67	374.44	375.55	3325331.0
2021-01-29 11:00:00	SPY	ETF	375.55	375.8599	372.65	372.73	5612412.0
2021-01-29 11:30:00	SPY	ETF	372.72	373.09	371.7711	373.0201	4620768.0
2021-01-29 12:00:00	SPY	ETF	373.02	373.24	370.52	370.845	5804781.0
2021-01-29 12:30:00	SPY	ETF	370.84	371.23	368.56	369.26	8746162.0
2021-01-29 13:00:00	SPY	ETF	369.25	370.87	368.27	370.8502	6876918.0
2021-01-29 13:30:00	SPY	ETF	370.86	371.16	369.55	369.79	4596874.0
2021-01-29 14:00:00	SPY	ETF	369.79	371.71	369.68	370.97	5639187.0
2021-01-29 14:30:00	SPY	ETF	370.96	371.18	369.7	370.79	4598813.0
2021-01-29 15:00:00	SPY	ETF	370.78	373.06	370.77	372.135	6687505.0
2021-01-29 15:30:00	SPY	ETF	372.14	373.18	369.94	370.19	20594616.0
2021-01-29 16:00:00	SPY	ETF	370.19	371.56	369.29	369.71	8569403.0
2021-01-29 16:30:00	SPY	ETF	369.74	370.08	369.36	369.4	541308.0
2021-01-29 17:00:00	SPY	ETF	369.5	370.07	369.36	369.92	187774.0
2021-01-29 17:30:00	SPY	ETF	369.83	370.07	369.7	369.7001	89225.0
2021-01-29 18:00:00	SPY	ETF	369.75	369.85	369.51	369.63	19017.0
2021-01-29 18:30:00	SPY	ETF	369.5	369.83	369.32	369.7	43638.0
2021-01-29 19:00:00	SPY	ETF	369.79	369.79	369.4	369.6	13064.0
2021-01-29 19:30:00	SPY	ETF	369.5	369.6	369.0	369.45	51967.0
2021-01-29 04:00:00	QQQ	ETF	317.43	317.94	316.4	317.35	59772.0
2021-01-29 04:30:00	QQQ	ETF	317.26	317.86	316.38	316.8	43169.0
2021-01-29 05:00:00	QQQ	ETF	316.46	316.58	315.44	316.48	47827.0
2021-01-29 05:30:00	QQQ	ETF	316.29	317.96	316.28	317.88	47987.0
2021-01-29 06:00:00	QQQ	ETF	317.83	318.76	317.16	318.64	91862.0
2021-01-29 06:30:00	QQQ	ETF	318.47	319.18	318.2	318.49	84984.0
2021-01-29 07:00:00	QQQ	ETF	318.46	319.08	318.26	319.03	142096.0
2021-01-29 07:30:00	QQQ	ETF	319.01	319.31	317.81	318.0	265847.0
2021-01-29 08:00:00	QQQ	ETF	318.0	321.32	316.63	318.44	652936.0
2021-01-29 08:30:00	QQQ	ETF	318.65	320.9	318.55	320.0998	554324.0
2021-01-29 09:00:00	QQQ	ETF	320.04	320.22	319.43	319.53	163351.0
2021-01-29 09:30:00	QQQ	ETF	319.54	320.14	316.85	318.9	4740717.0
2021-01-29 10:00:00	QQQ	ETF	318.93	320.7193	317.47	320.34	2880869.0
2021-01-29 10:30:00	QQQ	ETF	320.34	320.71	318.15	319.45	1833133.0
2021-01-29 11:00:00	QQQ	ETF	319.47	319.85	316.44	316.725	2340349.0
2021-01-29 11:30:00	QQQ	ETF	316.72	317.76	315.98	317.62	2326028.0
2021-01-29 12:00:00	QQQ	ETF	317.53	317.97	315.21	315.528	2742825.0
2021-01-29 12:30:00	QQQ	ETF	315.47	315.83	312.76	313.4	4591683.0

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

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