PREVIEW / etf_30min / 2020-12-31

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-31.parquet
  size:    588 KB
  rows:    22,195

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-31 04:00:00	SPY	ETF	371.36	371.53	371.18	371.2	9269.0
2020-12-31 04:30:00	SPY	ETF	371.16	371.26	371.0	371.26	4211.0
2020-12-31 05:00:00	SPY	ETF	371.26	371.4	371.2	371.4	9222.0
2020-12-31 05:30:00	SPY	ETF	371.39	371.95	371.39	371.88	7126.0
2020-12-31 06:00:00	SPY	ETF	371.89	372.17	371.79	372.17	3225.0
2020-12-31 06:30:00	SPY	ETF	372.17	372.33	372.17	372.18	17215.0
2020-12-31 07:00:00	SPY	ETF	372.1	372.26	371.8	371.99	30808.0
2020-12-31 07:30:00	SPY	ETF	371.8	371.87	371.7	371.78	78593.0
2020-12-31 08:00:00	SPY	ETF	371.76	372.2996	371.39	371.59	93554.0
2020-12-31 08:30:00	SPY	ETF	371.58	371.77	371.56	371.72	33960.0
2020-12-31 09:00:00	SPY	ETF	371.7	371.83	371.6	371.78	121539.0
2020-12-31 09:30:00	SPY	ETF	371.78	371.85	371.232	371.6467	3249046.0
2020-12-31 10:00:00	SPY	ETF	371.66	372.23	371.66	371.94	2934935.0
2020-12-31 10:30:00	SPY	ETF	371.949	372.05	371.7901	371.8055	2085906.0
2020-12-31 11:00:00	SPY	ETF	371.79	371.995	371.53	371.695	1870515.0
2020-12-31 11:30:00	SPY	ETF	371.7	371.78	371.285	371.37	1816445.0
2020-12-31 12:00:00	SPY	ETF	371.365	371.83	371.32	371.82	2074146.0
2020-12-31 12:30:00	SPY	ETF	371.81	372.09	371.68	371.905	1584125.0
2020-12-31 13:00:00	SPY	ETF	371.91	371.98	371.7401	371.85	976825.0
2020-12-31 13:30:00	SPY	ETF	371.8419	371.91	371.59	371.75	1589870.0
2020-12-31 14:00:00	SPY	ETF	371.75	372.64	371.46	372.44	4739123.0
2020-12-31 14:30:00	SPY	ETF	372.44	373.04	372.435	372.7889	3618211.0
2020-12-31 15:00:00	SPY	ETF	372.785	373.64	372.78	373.32	5807941.0
2020-12-31 15:30:00	SPY	ETF	373.325	374.66	373.05	373.85	20072952.0
2020-12-31 16:00:00	SPY	ETF	373.85	374.69	373.84	374.03	20987183.0
2020-12-31 16:30:00	SPY	ETF	374.04	374.34	373.88	374.3	500384.0
2020-12-31 17:00:00	SPY	ETF	374.25	374.32	374.13	374.32	1632656.0
2020-12-31 17:30:00	SPY	ETF	374.34	374.42	374.21	374.39	28193.0
2020-12-31 18:00:00	SPY	ETF	374.39	374.41	374.39	374.39	13206.0
2020-12-31 18:30:00	SPY	ETF	374.39	374.4	374.39	374.4	5460.0
2020-12-31 19:00:00	SPY	ETF	374.39	374.41	374.26	374.39	11418.0
2020-12-31 19:30:00	SPY	ETF	374.39	374.41	374.39	374.39	28381.0
2020-12-31 04:00:00	QQQ	ETF	312.97	313.04	312.8	312.85	8275.0
2020-12-31 04:30:00	QQQ	ETF	312.79	312.97	312.79	312.96	3675.0
2020-12-31 05:00:00	QQQ	ETF	312.9	312.97	312.9	312.97	5299.0
2020-12-31 05:30:00	QQQ	ETF	313.01	313.2	313.01	313.16	4272.0
2020-12-31 06:00:00	QQQ	ETF	313.16	313.35	313.14	313.35	4011.0
2020-12-31 06:30:00	QQQ	ETF	313.35	313.39	313.29	313.33	8045.0
2020-12-31 07:00:00	QQQ	ETF	313.29	313.43	313.15	313.22	38986.0
2020-12-31 07:30:00	QQQ	ETF	313.23	313.24	313.14	313.21	15714.0
2020-12-31 08:00:00	QQQ	ETF	313.33	313.4002	312.92	313.03	22480.0
2020-12-31 08:30:00	QQQ	ETF	313.08	313.17	313.01	313.02	13501.0
2020-12-31 09:00:00	QQQ	ETF	313.0	313.13	312.82	312.83	61927.0
2020-12-31 09:30:00	QQQ	ETF	312.88	313.28	312.425	312.68	2049907.0
2020-12-31 10:00:00	QQQ	ETF	312.69	313.25	312.69	312.99	1480108.0
2020-12-31 10:30:00	QQQ	ETF	313.01	313.21	312.73	313.01	788791.0
2020-12-31 11:00:00	QQQ	ETF	313.005	313.15	312.64	312.77	769294.0
2020-12-31 11:30:00	QQQ	ETF	312.7499	312.7999	311.76	311.89	1102346.0
2020-12-31 12:00:00	QQQ	ETF	311.92	312.519	311.825	312.385	638551.0
2020-12-31 12:30:00	QQQ	ETF	312.4	312.65	312.14	312.45	544446.0

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

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