PREVIEW / etf_30min / 2021-04-26

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-26.parquet
  size:    610 KB
  rows:    23,513

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-04-26 04:00:00	SPY	ETF	416.8	416.84	416.48	416.48	22305.0
2021-04-26 04:30:00	SPY	ETF	416.51	416.51	416.24	416.28	2200.0
2021-04-26 05:00:00	SPY	ETF	416.31	416.55	416.31	416.48	8497.0
2021-04-26 05:30:00	SPY	ETF	416.33	416.48	416.29	416.29	1980.0
2021-04-26 06:00:00	SPY	ETF	416.09	416.4	416.04	416.3	4718.0
2021-04-26 06:30:00	SPY	ETF	416.37	416.44	416.19	416.22	51137.0
2021-04-26 07:00:00	SPY	ETF	416.26	416.57	416.12	416.4	68492.0
2021-04-26 07:30:00	SPY	ETF	416.4	416.74	416.35	416.71	116142.0
2021-04-26 08:00:00	SPY	ETF	416.3501	416.97	416.12	416.8	176721.0
2021-04-26 08:30:00	SPY	ETF	416.77	417.0	416.64	416.84	76473.0
2021-04-26 09:00:00	SPY	ETF	416.83	417.42	416.82	417.41	241701.0
2021-04-26 09:30:00	SPY	ETF	417.44	417.98	417.2	417.69	4584045.0
2021-04-26 10:00:00	SPY	ETF	417.69	418.17	417.6	417.818	3152106.0
2021-04-26 10:30:00	SPY	ETF	417.83	418.01	417.62	417.75	1545850.0
2021-04-26 11:00:00	SPY	ETF	417.75	418.15	417.73	417.92	1479397.0
2021-04-26 11:30:00	SPY	ETF	417.91	417.955	417.61	417.6801	1451803.0
2021-04-26 12:00:00	SPY	ETF	417.68	417.7599	417.28	417.41	1669366.0
2021-04-26 12:30:00	SPY	ETF	417.4011	417.81	417.36	417.595	1351266.0
2021-04-26 13:00:00	SPY	ETF	417.595	417.675	417.301	417.4001	1090391.0
2021-04-26 13:30:00	SPY	ETF	417.4087	417.72	417.295	417.7089	1360638.0
2021-04-26 14:00:00	SPY	ETF	417.705	417.95	417.7	417.92	1666575.0
2021-04-26 14:30:00	SPY	ETF	417.919	418.11	417.86	418.0901	1880071.0
2021-04-26 15:00:00	SPY	ETF	418.09	418.22	417.18	417.3	2900462.0
2021-04-26 15:30:00	SPY	ETF	417.305	417.935	416.97	417.64	9398677.0
2021-04-26 16:00:00	SPY	ETF	417.64	417.9	417.24	417.33	3593407.0
2021-04-26 16:30:00	SPY	ETF	417.32	417.8	417.32	417.73	278098.0
2021-04-26 17:00:00	SPY	ETF	417.66	417.78	417.5583	417.73	410531.0
2021-04-26 17:30:00	SPY	ETF	417.72	417.78	417.67	417.74	21138.0
2021-04-26 18:00:00	SPY	ETF	417.75	417.82	417.59	417.8099	40174.0
2021-04-26 18:30:00	SPY	ETF	417.61	417.77	417.61	417.65	12279.0
2021-04-26 19:00:00	SPY	ETF	417.66	417.75	417.58	417.6	20025.0
2021-04-26 19:30:00	SPY	ETF	417.77	418.04	417.75	417.95	29447.0
2021-04-26 04:00:00	QQQ	ETF	339.0	339.23	338.73	338.81	33077.0
2021-04-26 04:30:00	QQQ	ETF	338.82	338.84	338.28	338.46	30823.0
2021-04-26 05:00:00	QQQ	ETF	338.43	338.59	338.4	338.4	21986.0
2021-04-26 05:30:00	QQQ	ETF	338.38	338.56	338.3	338.45	9379.0
2021-04-26 06:00:00	QQQ	ETF	338.45	338.7	338.26	338.6	24963.0
2021-04-26 06:30:00	QQQ	ETF	338.52	338.55	338.33	338.42	24586.0
2021-04-26 07:00:00	QQQ	ETF	338.4	338.45	338.06	338.31	208168.0
2021-04-26 07:30:00	QQQ	ETF	338.31	338.78	338.15	338.76	178846.0
2021-04-26 08:00:00	QQQ	ETF	338.4396	339.61	338.02	338.78	178579.0
2021-04-26 08:30:00	QQQ	ETF	338.82	339.37	338.68	339.26	152904.0
2021-04-26 09:00:00	QQQ	ETF	339.28	339.68	339.24	339.66	179104.0
2021-04-26 09:30:00	QQQ	ETF	339.67	340.09	338.9	339.64	3966206.0
2021-04-26 10:00:00	QQQ	ETF	339.64	340.4797	339.64	340.1501	1739376.0
2021-04-26 10:30:00	QQQ	ETF	340.16	340.74	339.95	340.29	1336999.0
2021-04-26 11:00:00	QQQ	ETF	340.3	341.0101	340.3	340.7698	1133940.0
2021-04-26 11:30:00	QQQ	ETF	340.76	340.9399	340.5	340.5782	918803.0
2021-04-26 12:00:00	QQQ	ETF	340.58	340.71	340.185	340.54	1302606.0
2021-04-26 12:30:00	QQQ	ETF	340.54	341.01	340.49	340.8301	732166.0

> showing 50 of 23,513 rows — these rows as CSV

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