PREVIEW / etf_30min / 2021-08-13

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-13.parquet
  size:    586 KB
  rows:    22,275

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-08-13 04:00:00	SPY	ETF	445.37	445.4	445.26	445.29	3600.0
2021-08-13 04:30:00	SPY	ETF	445.35	445.43	445.35	445.41	300.0
2021-08-13 05:00:00	SPY	ETF	445.59	445.59	445.38	445.38	1323.0
2021-08-13 05:30:00	SPY	ETF	445.42	445.45	445.42	445.43	1727.0
2021-08-13 06:00:00	SPY	ETF	445.47	445.48	445.44	445.44	510.0
2021-08-13 06:30:00	SPY	ETF	445.45	445.45	445.32	445.32	61415.0
2021-08-13 07:00:00	SPY	ETF	445.33	445.36	445.28	445.35	58683.0
2021-08-13 07:30:00	SPY	ETF	445.34	445.35	445.22	445.22	26656.0
2021-08-13 08:00:00	SPY	ETF	445.35	445.45	445.22	445.41	61058.0
2021-08-13 08:30:00	SPY	ETF	445.41	445.53	445.37	445.53	17062.0
2021-08-13 09:00:00	SPY	ETF	445.54	445.69	445.48	445.56	69271.0
2021-08-13 09:30:00	SPY	ETF	445.59	445.85	445.14	445.505	3367815.0
2021-08-13 10:00:00	SPY	ETF	445.5	445.82	445.07	445.4	3013053.0
2021-08-13 10:30:00	SPY	ETF	445.395	445.56	445.25	445.4454	1879357.0
2021-08-13 11:00:00	SPY	ETF	445.45	445.689	445.35	445.6152	1241777.0
2021-08-13 11:30:00	SPY	ETF	445.615	445.62	445.395	445.5199	909497.0
2021-08-13 12:00:00	SPY	ETF	445.5199	445.62	445.43	445.49	922530.0
2021-08-13 12:30:00	SPY	ETF	445.48	445.6	445.36	445.5499	897975.0
2021-08-13 13:00:00	SPY	ETF	445.545	445.605	445.4	445.57	800169.0
2021-08-13 13:30:00	SPY	ETF	445.57	445.8	445.535	445.725	1113294.0
2021-08-13 14:00:00	SPY	ETF	445.725	445.76	445.59	445.615	944395.0
2021-08-13 14:30:00	SPY	ETF	445.6199	445.62	445.2	445.4273	1599911.0
2021-08-13 15:00:00	SPY	ETF	445.435	445.65	445.39	445.465	1327384.0
2021-08-13 15:30:00	SPY	ETF	445.4617	445.93	445.33	445.9	7194661.0
2021-08-13 16:00:00	SPY	ETF	445.89	445.95	445.67	445.8	2046433.0
2021-08-13 16:30:00	SPY	ETF	445.78	445.83	445.62	445.62	200009.0
2021-08-13 17:00:00	SPY	ETF	445.51	445.7	445.51	445.56	46487.0
2021-08-13 17:30:00	SPY	ETF	445.58	445.59	445.5	445.5	10406.0
2021-08-13 18:00:00	SPY	ETF	445.58	445.58	445.46	445.47	6616.0
2021-08-13 18:30:00	SPY	ETF	445.45	445.45	445.34	445.35	9310.0
2021-08-13 19:00:00	SPY	ETF	445.38	445.38	445.32	445.32	25387.0
2021-08-13 19:30:00	SPY	ETF	445.33	445.45	445.31	445.45	28069.0
2021-08-13 04:00:00	QQQ	ETF	367.92	367.92	367.79	367.87	3167.0
2021-08-13 04:30:00	QQQ	ETF	367.86	367.99	367.83	367.92	6456.0
2021-08-13 05:00:00	QQQ	ETF	367.97	368.01	367.76	367.76	10588.0
2021-08-13 05:30:00	QQQ	ETF	367.8	367.8	367.65	367.73	7329.0
2021-08-13 06:00:00	QQQ	ETF	367.73	367.82	367.72	367.82	1900.0
2021-08-13 06:30:00	QQQ	ETF	367.78	367.78	367.64	367.66	61866.0
2021-08-13 07:00:00	QQQ	ETF	367.7	367.71	367.37	367.55	94244.0
2021-08-13 07:30:00	QQQ	ETF	367.54	367.55	367.12	367.2	68030.0
2021-08-13 08:00:00	QQQ	ETF	367.7404	367.805	367.08	367.49	46501.0
2021-08-13 08:30:00	QQQ	ETF	367.43	367.63	367.4	367.61	49112.0
2021-08-13 09:00:00	QQQ	ETF	367.65	367.93	367.63	367.84	70959.0
2021-08-13 09:30:00	QQQ	ETF	367.88	368.34	367.38	368.12	2935244.0
2021-08-13 10:00:00	QQQ	ETF	368.13	369.16	367.72	368.5199	2473686.0
2021-08-13 10:30:00	QQQ	ETF	368.51	368.74	368.31	368.5	1019893.0
2021-08-13 11:00:00	QQQ	ETF	368.51	368.8075	368.14	368.43	947896.0
2021-08-13 11:30:00	QQQ	ETF	368.43	368.4599	368.011	368.17	625822.0
2021-08-13 12:00:00	QQQ	ETF	368.165	368.525	368.14	368.29	584529.0
2021-08-13 12:30:00	QQQ	ETF	368.28	368.63	367.9609	368.5676	866382.0

> showing 50 of 22,275 rows — these rows as CSV

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