PREVIEW / etf_30min / 2021-06-11

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-11.parquet
  size:    585 KB
  rows:    22,392

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-06-11 04:00:00	SPY	ETF	423.54	423.6	423.54	423.6	600.0
2021-06-11 04:30:00	SPY	ETF	423.54	423.8	423.51	423.8	1700.0
2021-06-11 05:00:00	SPY	ETF	423.79	423.79	423.74	423.76	5178.0
2021-06-11 05:30:00	SPY	ETF	423.77	423.77	423.69	423.74	2198.0
2021-06-11 06:00:00	SPY	ETF	423.69	424.05	423.68	424.01	11741.0
2021-06-11 06:30:00	SPY	ETF	424.1	424.49	424.1	424.49	8283.0
2021-06-11 07:00:00	SPY	ETF	424.48	424.51	424.12	424.13	31080.0
2021-06-11 07:30:00	SPY	ETF	424.17	424.26	424.0	424.11	22940.0
2021-06-11 08:00:00	SPY	ETF	424.4199	424.4904	423.72	424.13	162777.0
2021-06-11 08:30:00	SPY	ETF	424.11	424.4	424.11	424.3	74179.0
2021-06-11 09:00:00	SPY	ETF	424.29	424.49	424.17	424.19	158358.0
2021-06-11 09:30:00	SPY	ETF	424.19	424.42	423.79	423.98	3416149.0
2021-06-11 10:00:00	SPY	ETF	423.97	424.26	423.44	423.65	2690886.0
2021-06-11 10:30:00	SPY	ETF	423.66	423.69	423.2209	423.37	2448650.0
2021-06-11 11:00:00	SPY	ETF	423.35	423.53	423.025	423.5201	1966264.0
2021-06-11 11:30:00	SPY	ETF	423.53	423.62	423.26	423.355	1619792.0
2021-06-11 12:00:00	SPY	ETF	423.36	423.455	422.965	423.01	1366944.0
2021-06-11 12:30:00	SPY	ETF	423.0	423.23	422.82	423.19	1367346.0
2021-06-11 13:00:00	SPY	ETF	423.1801	423.31	423.02	423.24	1624341.0
2021-06-11 13:30:00	SPY	ETF	423.2481	423.535	423.23	423.48	1032861.0
2021-06-11 14:00:00	SPY	ETF	423.485	423.77	423.485	423.7499	1373807.0
2021-06-11 14:30:00	SPY	ETF	423.745	423.85	423.5701	423.77	1314000.0
2021-06-11 15:00:00	SPY	ETF	423.7781	423.79	423.47	423.5499	2717982.0
2021-06-11 15:30:00	SPY	ETF	423.545	424.41	423.41	424.32	7336791.0
2021-06-11 16:00:00	SPY	ETF	424.32	424.43	424.12	424.3	3175175.0
2021-06-11 16:30:00	SPY	ETF	424.29	424.31	424.24	424.27	514916.0
2021-06-11 17:00:00	SPY	ETF	424.13	424.29	424.13	424.29	40130.0
2021-06-11 17:30:00	SPY	ETF	424.3	424.42	424.24	424.42	54925.0
2021-06-11 18:00:00	SPY	ETF	424.36	424.38	424.32	424.33	2097.0
2021-06-11 18:30:00	SPY	ETF	424.4	424.4	424.36	424.4	1922.0
2021-06-11 19:00:00	SPY	ETF	424.4	424.43	424.4	424.43	3598.0
2021-06-11 19:30:00	SPY	ETF	424.38	424.45	424.37	424.41	27500.0
2021-06-11 04:00:00	QQQ	ETF	340.14	340.34	340.11	340.12	18000.0
2021-06-11 04:30:00	QQQ	ETF	340.19	340.53	340.19	340.52	10680.0
2021-06-11 05:00:00	QQQ	ETF	340.45	340.45	340.34	340.41	7000.0
2021-06-11 05:30:00	QQQ	ETF	340.3	340.33	340.22	340.33	8125.0
2021-06-11 06:00:00	QQQ	ETF	340.2	340.54	340.15	340.53	25439.0
2021-06-11 06:30:00	QQQ	ETF	340.7	341.25	340.68	341.24	20887.0
2021-06-11 07:00:00	QQQ	ETF	341.2	341.27	340.86	341.0	61716.0
2021-06-11 07:30:00	QQQ	ETF	340.99	341.14	340.79	340.79	32279.0
2021-06-11 08:00:00	QQQ	ETF	340.4996	341.2404	340.1304	340.81	68327.0
2021-06-11 08:30:00	QQQ	ETF	340.81	340.89	340.469	340.659	137374.0
2021-06-11 09:00:00	QQQ	ETF	340.64	340.86	340.37	340.43	97941.0
2021-06-11 09:30:00	QQQ	ETF	340.36	340.98	339.92	340.565	2946503.0
2021-06-11 10:00:00	QQQ	ETF	340.56	340.97	340.33	340.82	1680205.0
2021-06-11 10:30:00	QQQ	ETF	340.835	340.9	339.865	340.2218	2343277.0
2021-06-11 11:00:00	QQQ	ETF	340.23	340.72	339.69	340.64	1703810.0
2021-06-11 11:30:00	QQQ	ETF	340.65	340.67	340.2	340.335	832979.0
2021-06-11 12:00:00	QQQ	ETF	340.34	340.565	340.12	340.18	675666.0
2021-06-11 12:30:00	QQQ	ETF	340.18	340.4	340.07	340.37	544421.0

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

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