PREVIEW / etf_30min / 2021-02-19

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-02-19.parquet
  size:    622 KB
  rows:    23,519

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-02-19 04:00:00	SPY	ETF	391.08	391.39	390.74	391.22	13253.0
2021-02-19 04:30:00	SPY	ETF	391.38	392.03	391.38	391.59	24600.0
2021-02-19 05:00:00	SPY	ETF	391.69	392.17	391.22	391.75	28675.0
2021-02-19 05:30:00	SPY	ETF	391.75	391.94	391.64	391.94	9997.0
2021-02-19 06:00:00	SPY	ETF	391.89	391.93	391.4	391.62	29008.0
2021-02-19 06:30:00	SPY	ETF	391.57	391.59	391.3	391.44	8106.0
2021-02-19 07:00:00	SPY	ETF	391.34	392.24	391.34	392.19	74570.0
2021-02-19 07:30:00	SPY	ETF	392.22	392.51	392.0	392.14	289419.0
2021-02-19 08:00:00	SPY	ETF	391.6701	392.51	390.0	392.4	247680.0
2021-02-19 08:30:00	SPY	ETF	392.37	392.76	392.27	392.59	148545.0
2021-02-19 09:00:00	SPY	ETF	392.57	392.57	391.94	392.07	186897.0
2021-02-19 09:30:00	SPY	ETF	392.07	392.27	391.06	392.01	3937617.0
2021-02-19 10:00:00	SPY	ETF	392.03	392.165	391.3	391.6301	2892315.0
2021-02-19 10:30:00	SPY	ETF	391.645	392.15	391.46	392.0	1822621.0
2021-02-19 11:00:00	SPY	ETF	392.0011	392.34	391.86	392.3	1707352.0
2021-02-19 11:30:00	SPY	ETF	392.28	392.38	391.71	391.75	1577390.0
2021-02-19 12:00:00	SPY	ETF	391.75	391.81	390.78	390.9561	3584685.0
2021-02-19 12:30:00	SPY	ETF	390.96	391.105	390.1022	390.61	5351748.0
2021-02-19 13:00:00	SPY	ETF	390.6	390.74	389.85	390.3885	3426892.0
2021-02-19 13:30:00	SPY	ETF	390.39	390.87	390.0	390.82	2037582.0
2021-02-19 14:00:00	SPY	ETF	390.8242	391.05	389.66	389.78	2543684.0
2021-02-19 14:30:00	SPY	ETF	389.77	390.45	389.76	390.4	2544192.0
2021-02-19 15:00:00	SPY	ETF	390.39	390.88	390.17	390.67	4221137.0
2021-02-19 15:30:00	SPY	ETF	390.66	390.94	389.55	390.02	9315936.0
2021-02-19 16:00:00	SPY	ETF	390.02	390.07	389.36	389.62	8026285.0
2021-02-19 16:30:00	SPY	ETF	389.68	389.72	389.45	389.6	690589.0
2021-02-19 17:00:00	SPY	ETF	389.65	389.85	389.37	389.55	57895.0
2021-02-19 17:30:00	SPY	ETF	389.51	390.03	389.4201	389.68	191414.0
2021-02-19 18:00:00	SPY	ETF	389.61	390.03	389.46	389.62	38860.0
2021-02-19 18:30:00	SPY	ETF	389.69	389.85	389.55	389.56	34173.0
2021-02-19 19:00:00	SPY	ETF	389.65	389.78	389.56	389.6	5844.0
2021-02-19 19:30:00	SPY	ETF	389.6	389.7	389.57	389.7	16851.0
2021-02-19 04:00:00	QQQ	ETF	332.69	333.08	332.56	332.96	37673.0
2021-02-19 04:30:00	QQQ	ETF	333.02	333.64	333.0	333.3	11764.0
2021-02-19 05:00:00	QQQ	ETF	333.28	333.73	332.95	333.54	23870.0
2021-02-19 05:30:00	QQQ	ETF	333.48	333.75	333.42	333.7	10135.0
2021-02-19 06:00:00	QQQ	ETF	333.8	333.8	333.33	333.53	16629.0
2021-02-19 06:30:00	QQQ	ETF	333.57	333.57	333.31	333.46	11597.0
2021-02-19 07:00:00	QQQ	ETF	333.44	334.16	333.44	334.16	63426.0
2021-02-19 07:30:00	QQQ	ETF	334.19	334.27	333.97	334.099	216108.0
2021-02-19 08:00:00	QQQ	ETF	334.1	334.41	331.6	334.39	88533.0
2021-02-19 08:30:00	QQQ	ETF	334.42	334.62	334.27	334.59	144055.0
2021-02-19 09:00:00	QQQ	ETF	334.55	334.55	333.8	333.81	183185.0
2021-02-19 09:30:00	QQQ	ETF	333.86	333.99	332.55	333.28	2711413.0
2021-02-19 10:00:00	QQQ	ETF	333.29	333.41	332.25	332.86	2094989.0
2021-02-19 10:30:00	QQQ	ETF	332.87	333.53	332.5401	333.4	937389.0
2021-02-19 11:00:00	QQQ	ETF	333.39	333.9	333.1	333.8	879001.0
2021-02-19 11:30:00	QQQ	ETF	333.79	333.955	333.08	333.11	860518.0
2021-02-19 12:00:00	QQQ	ETF	333.09	333.25	331.79	331.91	1681858.0
2021-02-19 12:30:00	QQQ	ETF	331.9	332.065	330.46	331.12	2466691.0

> showing 50 of 23,519 rows — these rows as CSV

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