PREVIEW / etf_30min / 2020-12-18

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-18.parquet
  size:    596 KB
  rows:    22,222

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
2020-12-18 04:00:00	SPY	ETF	371.2	371.52	370.76	370.9	23351.0
2020-12-18 04:30:00	SPY	ETF	370.9	370.9	370.68	370.76	4203.0
2020-12-18 05:00:00	SPY	ETF	370.78	370.96	370.75	370.79	6228.0
2020-12-18 05:30:00	SPY	ETF	370.73	370.9	370.51	370.9	25659.0
2020-12-18 06:00:00	SPY	ETF	370.85	371.0	370.74	370.94	6826.0
2020-12-18 06:30:00	SPY	ETF	370.91	371.02	370.86	370.9	19872.0
2020-12-18 07:00:00	SPY	ETF	370.95	371.1	370.85	371.0	54875.0
2020-12-18 07:30:00	SPY	ETF	371.0	371.23	370.78	370.79	80553.0
2020-12-18 08:00:00	SPY	ETF	370.79	371.2298	369.39	370.69	167043.0
2020-12-18 08:30:00	SPY	ETF	370.73	371.13	370.68	370.88	152291.0
2020-12-18 09:00:00	SPY	ETF	370.86	372.34	370.78	371.0	557693.0
2020-12-18 09:30:00	SPY	ETF	370.97	371.15	369.04	369.62	10706526.0
2020-12-18 10:00:00	SPY	ETF	369.64	370.6892	368.55	368.81	10291134.0
2020-12-18 10:30:00	SPY	ETF	368.8101	371.0815	368.43	369.0498	14336166.0
2020-12-18 11:00:00	SPY	ETF	369.04	369.2	367.7	368.37	4362028.0
2020-12-18 11:30:00	SPY	ETF	368.37	368.8	368.175	368.59	3281053.0
2020-12-18 12:00:00	SPY	ETF	368.581	369.21	368.48	369.085	2389802.0
2020-12-18 12:30:00	SPY	ETF	369.0889	369.59	368.825	368.93	2755997.0
2020-12-18 13:00:00	SPY	ETF	368.93	368.96	368.27	368.59	2917002.0
2020-12-18 13:30:00	SPY	ETF	368.59	368.59	367.98	368.35	2317033.0
2020-12-18 14:00:00	SPY	ETF	368.35	368.36	367.57	367.845	4543424.0
2020-12-18 14:30:00	SPY	ETF	367.85	368.1802	367.3	367.59	4759911.0
2020-12-18 15:00:00	SPY	ETF	367.6	367.96	367.02	367.27	5257096.0
2020-12-18 15:30:00	SPY	ETF	367.27	370.6892	367.063	369.13	20454443.0
2020-12-18 16:00:00	SPY	ETF	369.09	370.5	369.06	369.98	16448335.0
2020-12-18 16:30:00	SPY	ETF	369.98	371.14	369.18	370.8	8282981.0
2020-12-18 17:00:00	SPY	ETF	370.83	371.27	369.18	370.99	10415947.0
2020-12-18 17:30:00	SPY	ETF	370.99	371.13	369.18	370.4	1567105.0
2020-12-18 18:00:00	SPY	ETF	370.3	370.35	369.9999	370.14	538333.0
2020-12-18 18:30:00	SPY	ETF	370.11	370.14	369.18	370.0	1095605.0
2020-12-18 19:00:00	SPY	ETF	370.1	370.3	370.1	370.29	7856.0
2020-12-18 19:30:00	SPY	ETF	370.29	370.39	370.05	370.28	37462.0
2020-12-18 04:00:00	QQQ	ETF	311.49	311.7	311.06	311.07	59776.0
2020-12-18 04:30:00	QQQ	ETF	311.09	311.09	310.93	311.0	26667.0
2020-12-18 05:00:00	QQQ	ETF	311.12	311.15	310.87	310.87	7100.0
2020-12-18 05:30:00	QQQ	ETF	310.96	310.97	310.72	310.93	20499.0
2020-12-18 06:00:00	QQQ	ETF	310.96	311.17	310.95	311.06	3000.0
2020-12-18 06:30:00	QQQ	ETF	311.02	311.16	311.0	311.04	22983.0
2020-12-18 07:00:00	QQQ	ETF	311.04	311.38	311.01	311.3	52116.0
2020-12-18 07:30:00	QQQ	ETF	311.29	311.46	311.01	311.09	47289.0
2020-12-18 08:00:00	QQQ	ETF	311.3098	311.46	310.15	311.4	65750.0
2020-12-18 08:30:00	QQQ	ETF	311.43	311.77	311.41	311.69	76196.0
2020-12-18 09:00:00	QQQ	ETF	311.68	312.01	311.66	311.66	321721.0
2020-12-18 09:30:00	QQQ	ETF	311.66	311.98	310.17	310.45	3250749.0
2020-12-18 10:00:00	QQQ	ETF	310.43	310.55	309.41	310.13	2267347.0
2020-12-18 10:30:00	QQQ	ETF	310.1499	310.4699	309.74	310.25	1189644.0
2020-12-18 11:00:00	QQQ	ETF	310.25	310.48	308.84	309.56	1168132.0
2020-12-18 11:30:00	QQQ	ETF	309.5218	309.93	309.39	309.66	656022.0
2020-12-18 12:00:00	QQQ	ETF	309.64	310.18	309.47	310.15	587079.0
2020-12-18 12:30:00	QQQ	ETF	310.15	310.43	309.99	310.108	703283.0

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

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