PREVIEW / etf_30min / 2021-05-27

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-27.parquet
  size:    592 KB
  rows:    22,587

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-27 04:00:00	SPY	ETF	418.11	418.38	418.1	418.35	11283.0
2021-05-27 04:30:00	SPY	ETF	418.29	418.29	417.81	417.97	10564.0
2021-05-27 05:00:00	SPY	ETF	417.97	418.09	417.87	417.87	7767.0
2021-05-27 05:30:00	SPY	ETF	417.91	418.03	417.83	417.9	4907.0
2021-05-27 06:00:00	SPY	ETF	417.81	418.14	417.69	417.99	20562.0
2021-05-27 06:30:00	SPY	ETF	418.04	418.2	418.02	418.18	13142.0
2021-05-27 07:00:00	SPY	ETF	418.18	418.39	418.16	418.26	39057.0
2021-05-27 07:30:00	SPY	ETF	418.25	418.79	418.0	418.76	80900.0
2021-05-27 08:00:00	SPY	ETF	418.16	419.55	418.0	418.62	267733.0
2021-05-27 08:30:00	SPY	ETF	418.58	419.46	418.42	419.41	171026.0
2021-05-27 09:00:00	SPY	ETF	419.44	420.36	419.41	420.17	294545.0
2021-05-27 09:30:00	SPY	ETF	420.17	420.63	419.915	420.1	5355608.0
2021-05-27 10:00:00	SPY	ETF	420.1	420.53	419.79	420.34	3330198.0
2021-05-27 10:30:00	SPY	ETF	420.34	420.72	419.79	420.103	3454408.0
2021-05-27 11:00:00	SPY	ETF	420.12	420.2611	419.75	419.75	2024174.0
2021-05-27 11:30:00	SPY	ETF	419.75	420.38	419.46	420.28	2165932.0
2021-05-27 12:00:00	SPY	ETF	420.28	420.43	420.205	420.29	1252687.0
2021-05-27 12:30:00	SPY	ETF	420.295	420.38	419.98	420.045	1121988.0
2021-05-27 13:00:00	SPY	ETF	420.0489	420.1901	419.89	419.91	1273354.0
2021-05-27 13:30:00	SPY	ETF	419.91	419.97	419.41	419.7089	1903365.0
2021-05-27 14:00:00	SPY	ETF	419.71	419.75	419.2	419.58	2739383.0
2021-05-27 14:30:00	SPY	ETF	419.5704	419.72	419.22	419.6011	2647266.0
2021-05-27 15:00:00	SPY	ETF	419.6	419.6017	419.12	419.42	4284676.0
2021-05-27 15:30:00	SPY	ETF	419.435	420.1	419.16	419.22	11096230.0
2021-05-27 16:00:00	SPY	ETF	419.22	420.58	419.15	420.43	3634301.0
2021-05-27 16:30:00	SPY	ETF	420.46	420.82	420.43	420.76	233288.0
2021-05-27 17:00:00	SPY	ETF	420.77	420.77	420.6	420.61	71801.0
2021-05-27 17:30:00	SPY	ETF	420.62	420.69	420.6	420.68	13365.0
2021-05-27 18:00:00	SPY	ETF	420.65	420.82	420.65	420.69	29016.0
2021-05-27 18:30:00	SPY	ETF	419.29	420.76	419.29	420.73	17075.0
2021-05-27 19:00:00	SPY	ETF	420.76	420.76	420.61	420.73	16569.0
2021-05-27 19:30:00	SPY	ETF	420.74	421.25	420.74	421.12	68850.0
2021-05-27 04:00:00	QQQ	ETF	333.37	333.37	332.43	332.81	21236.0
2021-05-27 04:30:00	QQQ	ETF	332.83	332.83	332.28	332.41	16127.0
2021-05-27 05:00:00	QQQ	ETF	332.39	332.56	332.22	332.27	21175.0
2021-05-27 05:30:00	QQQ	ETF	332.46	332.56	332.33	332.37	3741.0
2021-05-27 06:00:00	QQQ	ETF	332.3	332.76	332.21	332.7	26696.0
2021-05-27 06:30:00	QQQ	ETF	332.67	332.79	332.64	332.76	24550.0
2021-05-27 07:00:00	QQQ	ETF	332.76	332.999	332.73	332.77	75085.0
2021-05-27 07:30:00	QQQ	ETF	332.78	333.27	332.44	333.23	64955.0
2021-05-27 08:00:00	QQQ	ETF	332.9	333.58	332.3	332.59	298929.0
2021-05-27 08:30:00	QQQ	ETF	332.55	333.25	332.13	333.08	234278.0
2021-05-27 09:00:00	QQQ	ETF	333.09	333.98	333.09	333.67	217988.0
2021-05-27 09:30:00	QQQ	ETF	333.66	333.9	332.67	332.97	3332132.0
2021-05-27 10:00:00	QQQ	ETF	332.965	334.085	332.74	333.92	2203332.0
2021-05-27 10:30:00	QQQ	ETF	333.92	334.54	333.45	333.64	2260797.0
2021-05-27 11:00:00	QQQ	ETF	333.63	334.2801	333.5289	333.81	994299.0
2021-05-27 11:30:00	QQQ	ETF	333.815	334.3	333.52	334.231	1007644.0
2021-05-27 12:00:00	QQQ	ETF	334.23	334.369	334.005	334.109	570983.0
2021-05-27 12:30:00	QQQ	ETF	334.1292	334.16	333.83	334.1018	616509.0

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

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