PREVIEW / etf_30min / 2021-05-28

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-28.parquet
  size:    588 KB
  rows:    22,491

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-05-28 04:00:00	SPY	ETF	420.95	421.05	420.95	420.98	2300.0
2021-05-28 04:30:00	SPY	ETF	421.08	421.1	421.03	421.07	2402.0
2021-05-28 05:00:00	SPY	ETF	421.13	421.24	420.95	421.13	5064.0
2021-05-28 05:30:00	SPY	ETF	421.12	421.24	421.01	421.16	9828.0
2021-05-28 06:00:00	SPY	ETF	421.22	421.22	421.04	421.09	8409.0
2021-05-28 06:30:00	SPY	ETF	421.11	421.39	421.1	421.36	22556.0
2021-05-28 07:00:00	SPY	ETF	421.35	421.43	421.13	421.17	82101.0
2021-05-28 07:30:00	SPY	ETF	421.2	421.2	421.0	421.0	43600.0
2021-05-28 08:00:00	SPY	ETF	421.36	421.42	420.64	420.77	100669.0
2021-05-28 08:30:00	SPY	ETF	420.79	421.01	420.52	420.61	152388.0
2021-05-28 09:00:00	SPY	ETF	420.61	421.07	420.61	420.98	150459.0
2021-05-28 09:30:00	SPY	ETF	420.97	421.09	420.34	420.87	4532402.0
2021-05-28 10:00:00	SPY	ETF	420.86	421.04	419.9655	420.07	3141397.0
2021-05-28 10:30:00	SPY	ETF	420.07	420.64	420.07	420.4681	2283212.0
2021-05-28 11:00:00	SPY	ETF	420.465	420.79	420.35	420.7	1726715.0
2021-05-28 11:30:00	SPY	ETF	420.71	421.04	420.67	420.95	1763886.0
2021-05-28 12:00:00	SPY	ETF	420.95	421.25	420.885	421.125	1472499.0
2021-05-28 12:30:00	SPY	ETF	421.125	421.22	420.835	420.89	1310713.0
2021-05-28 13:00:00	SPY	ETF	420.88	421.0036	420.5301	420.66	1815286.0
2021-05-28 13:30:00	SPY	ETF	420.66	420.83	420.54	420.69	1759873.0
2021-05-28 14:00:00	SPY	ETF	420.695	420.8	420.47	420.8	1728819.0
2021-05-28 14:30:00	SPY	ETF	420.8	420.91	420.68	420.7689	2113214.0
2021-05-28 15:00:00	SPY	ETF	420.77	420.83	420.43	420.6501	2696064.0
2021-05-28 15:30:00	SPY	ETF	420.65	420.96	419.79	420.03	12105947.0
2021-05-28 16:00:00	SPY	ETF	420.03	420.35	419.8372	420.1	3435609.0
2021-05-28 16:30:00	SPY	ETF	420.12	420.13	419.97	420.04	247056.0
2021-05-28 17:00:00	SPY	ETF	420.02	420.15	419.98	420.07	542427.0
2021-05-28 17:30:00	SPY	ETF	420.15	420.17	420.05	420.12	17881.0
2021-05-28 18:00:00	SPY	ETF	420.05	420.12	419.95	420.0	17028.0
2021-05-28 18:30:00	SPY	ETF	420.04	420.04	419.97	420.0	3850.0
2021-05-28 19:00:00	SPY	ETF	419.98	419.98	419.95	419.95	3852.0
2021-05-28 19:30:00	SPY	ETF	419.99	420.05	419.96	420.04	5268.0
2021-05-28 04:00:00	QQQ	ETF	333.51	334.02	333.51	333.89	9919.0
2021-05-28 04:30:00	QQQ	ETF	333.92	333.95	333.85	333.95	4549.0
2021-05-28 05:00:00	QQQ	ETF	333.96	334.22	333.86	334.2	4318.0
2021-05-28 05:30:00	QQQ	ETF	334.22	334.37	334.17	334.24	9251.0
2021-05-28 06:00:00	QQQ	ETF	334.36	334.38	334.19	334.3	39308.0
2021-05-28 06:30:00	QQQ	ETF	334.24	334.66	334.2	334.65	106543.0
2021-05-28 07:00:00	QQQ	ETF	334.65	334.65	334.28	334.4	115481.0
2021-05-28 07:30:00	QQQ	ETF	334.35	334.43	334.26	334.43	22398.0
2021-05-28 08:00:00	QQQ	ETF	334.38	334.58	333.32	333.88	107506.0
2021-05-28 08:30:00	QQQ	ETF	333.95	334.18	333.56	333.73	165989.0
2021-05-28 09:00:00	QQQ	ETF	333.7	334.14	333.68	334.07	74506.0
2021-05-28 09:30:00	QQQ	ETF	334.14	334.985	333.94	334.599	2873126.0
2021-05-28 10:00:00	QQQ	ETF	334.59	334.82	333.91	333.98	1903268.0
2021-05-28 10:30:00	QQQ	ETF	333.98	334.79	333.97	334.39	1295097.0
2021-05-28 11:00:00	QQQ	ETF	334.4	334.73	334.23	334.64	1034597.0
2021-05-28 11:30:00	QQQ	ETF	334.63	335.24	334.61	335.22	1229065.0
2021-05-28 12:00:00	QQQ	ETF	335.235	335.5699	335.19	335.26	1137212.0
2021-05-28 12:30:00	QQQ	ETF	335.27	335.5	335.13	335.39	625272.0

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

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