PREVIEW / etf_30min / 2019-12-06

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-06.parquet
  size:    517 KB
  rows:    17,968

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
2019-12-06 04:00:00	SPY	ETF	312.65	312.8	312.65	312.71	2917.0
2019-12-06 04:30:00	SPY	ETF	312.73	312.76	312.71	312.76	720.0
2019-12-06 05:00:00	SPY	ETF	312.81	312.81	312.67	312.67	2020.0
2019-12-06 05:30:00	SPY	ETF	312.72	312.76	312.7	312.7	2833.0
2019-12-06 06:00:00	SPY	ETF	312.64	312.83	312.64	312.82	2910.0
2019-12-06 06:30:00	SPY	ETF	312.78	312.89	312.76	312.83	33570.0
2019-12-06 07:00:00	SPY	ETF	312.83	312.85	312.58	312.58	33091.0
2019-12-06 07:30:00	SPY	ETF	312.57	312.64	312.53	312.62	12147.0
2019-12-06 08:00:00	SPY	ETF	312.75	312.9	312.5101	312.55	67826.0
2019-12-06 08:30:00	SPY	ETF	312.51	314.14	312.37	313.95	1738961.0
2019-12-06 09:00:00	SPY	ETF	313.96	314.2	313.91	314.1	253287.0
2019-12-06 09:30:00	SPY	ETF	314.12	314.72	314.11	314.64	5062561.0
2019-12-06 10:00:00	SPY	ETF	314.63	314.89	314.42	314.66	4246941.0
2019-12-06 10:30:00	SPY	ETF	314.66	315.06	314.5	314.92	3895971.0
2019-12-06 11:00:00	SPY	ETF	314.92	315.19	314.86	315.18	3093067.0
2019-12-06 11:30:00	SPY	ETF	315.17	315.28	315.06	315.11	3264765.0
2019-12-06 12:00:00	SPY	ETF	315.11	315.2	315.03	315.1799	2178322.0
2019-12-06 12:30:00	SPY	ETF	315.18	315.29	315.115	315.22	1868747.0
2019-12-06 13:00:00	SPY	ETF	315.215	315.31	315.13	315.195	1729044.0
2019-12-06 13:30:00	SPY	ETF	315.195	315.26	315.06	315.07	1876880.0
2019-12-06 14:00:00	SPY	ETF	315.065	315.16	314.92	315.11	2700419.0
2019-12-06 14:30:00	SPY	ETF	315.115	315.12	314.91	314.955	1208009.0
2019-12-06 15:00:00	SPY	ETF	314.9501	315.0	314.83	314.95	1836423.0
2019-12-06 15:30:00	SPY	ETF	314.95	315.2599	314.67	314.82	6802604.0
2019-12-06 16:00:00	SPY	ETF	314.82	314.9	314.73	314.8	4515309.0
2019-12-06 16:30:00	SPY	ETF	314.81	314.91	314.8	314.87	1342605.0
2019-12-06 17:00:00	SPY	ETF	314.88	314.96	314.82	314.96	39379.0
2019-12-06 17:30:00	SPY	ETF	314.97	315.04	314.95	314.96	15719.0
2019-12-06 18:00:00	SPY	ETF	315.0	315.05	315.0	315.0	2963.0
2019-12-06 18:30:00	SPY	ETF	315.0	315.02	314.99	315.0	2706.0
2019-12-06 19:00:00	SPY	ETF	315.01	315.05	315.01	315.01	7218.0
2019-12-06 19:30:00	SPY	ETF	315.01	315.08	314.96	315.01	15886.0
2019-12-06 04:00:00	QQQ	ETF	203.35	203.48	203.33	203.41	5352.0
2019-12-06 04:30:00	QQQ	ETF	203.41	203.56	203.41	203.55	4980.0
2019-12-06 05:00:00	QQQ	ETF	203.38	203.38	203.38	203.38	100.0
2019-12-06 05:30:00	QQQ	ETF	203.36	203.47	203.36	203.4	5564.0
2019-12-06 06:00:00	QQQ	ETF	203.38	203.46	203.38	203.46	2100.0
2019-12-06 06:30:00	QQQ	ETF	203.46	203.53	203.46	203.53	5623.0
2019-12-06 07:00:00	QQQ	ETF	203.52	203.53	203.31	203.32	59395.0
2019-12-06 07:30:00	QQQ	ETF	203.3	203.35	203.27	203.34	11753.0
2019-12-06 08:00:00	QQQ	ETF	203.35	203.53	203.25	203.3	31443.0
2019-12-06 08:30:00	QQQ	ETF	203.18	204.45	203.12	204.33	628343.0
2019-12-06 09:00:00	QQQ	ETF	204.34	204.38	204.22	204.22	130742.0
2019-12-06 09:30:00	QQQ	ETF	204.22	204.74	204.1501	204.58	2442616.0
2019-12-06 10:00:00	QQQ	ETF	204.58	204.67	204.33	204.4313	1789939.0
2019-12-06 10:30:00	QQQ	ETF	204.46	204.78	204.42	204.64	893745.0
2019-12-06 11:00:00	QQQ	ETF	204.66	204.81	204.61	204.79	604731.0
2019-12-06 11:30:00	QQQ	ETF	204.795	204.83	204.67	204.71	432049.0
2019-12-06 12:00:00	QQQ	ETF	204.7105	204.87	204.69	204.86	569245.0
2019-12-06 12:30:00	QQQ	ETF	204.86	204.98	204.82	204.92	476907.0

> showing 50 of 17,968 rows — these rows as CSV

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