PREVIEW / etf_30min / 2021-06-10

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-10.parquet
  size:    598 KB
  rows:    22,948

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-10 04:00:00	SPY	ETF	421.78	421.78	421.14	421.14	9109.0
2021-06-10 04:30:00	SPY	ETF	421.12	421.65	421.12	421.65	5267.0
2021-06-10 05:00:00	SPY	ETF	421.68	421.83	421.67	421.67	2600.0
2021-06-10 05:30:00	SPY	ETF	421.64	421.83	421.55	421.83	8100.0
2021-06-10 06:00:00	SPY	ETF	421.82	422.02	421.82	421.9	11092.0
2021-06-10 06:30:00	SPY	ETF	421.87	421.89	421.7	421.76	7200.0
2021-06-10 07:00:00	SPY	ETF	421.76	421.97	421.51	421.59	53221.0
2021-06-10 07:30:00	SPY	ETF	421.57	421.94	421.0	421.6	89829.0
2021-06-10 08:00:00	SPY	ETF	421.58	422.14	420.97	421.65	183334.0
2021-06-10 08:30:00	SPY	ETF	421.62	422.88	420.5	422.81	1348099.0
2021-06-10 09:00:00	SPY	ETF	422.8	423.09	422.72	422.96	503040.0
2021-06-10 09:30:00	SPY	ETF	422.96	424.52	422.94	424.25	5235248.0
2021-06-10 10:00:00	SPY	ETF	424.25	424.63	423.605	423.75	3023277.0
2021-06-10 10:30:00	SPY	ETF	423.76	423.9	421.55	422.465	4908220.0
2021-06-10 11:00:00	SPY	ETF	422.46	423.24	422.13	423.2	2656972.0
2021-06-10 11:30:00	SPY	ETF	423.21	423.52	422.87	423.46	1757089.0
2021-06-10 12:00:00	SPY	ETF	423.47	423.6	423.1	423.26	1724295.0
2021-06-10 12:30:00	SPY	ETF	423.27	423.92	423.27	423.91	1533784.0
2021-06-10 13:00:00	SPY	ETF	423.9	424.05	423.69	423.74	1352154.0
2021-06-10 13:30:00	SPY	ETF	423.75	424.09	423.525	424.08	1527969.0
2021-06-10 14:00:00	SPY	ETF	424.08	424.1	423.64	423.6701	1546415.0
2021-06-10 14:30:00	SPY	ETF	423.68	423.85	423.38	423.8	1371521.0
2021-06-10 15:00:00	SPY	ETF	423.79	423.83	423.35	423.5	1875054.0
2021-06-10 15:30:00	SPY	ETF	423.49	423.73	423.17	423.59	6936781.0
2021-06-10 16:00:00	SPY	ETF	423.58	423.77	423.35	423.44	1882975.0
2021-06-10 16:30:00	SPY	ETF	423.48	423.69	423.46	423.6	124974.0
2021-06-10 17:00:00	SPY	ETF	423.61	423.67	423.5	423.63	52794.0
2021-06-10 17:30:00	SPY	ETF	423.63	423.69	423.62	423.69	20680.0
2021-06-10 18:00:00	SPY	ETF	423.7	423.71	423.58	423.65	38798.0
2021-06-10 18:30:00	SPY	ETF	423.61	423.63	423.56	423.61	12655.0
2021-06-10 19:00:00	SPY	ETF	423.61	423.61	423.52	423.52	5706.0
2021-06-10 19:30:00	SPY	ETF	423.64	423.65	423.45	423.51	12794.0
2021-06-10 04:00:00	QQQ	ETF	336.45	336.45	335.76	335.78	17594.0
2021-06-10 04:30:00	QQQ	ETF	335.67	336.14	335.67	336.14	3582.0
2021-06-10 05:00:00	QQQ	ETF	336.23	336.3	335.99	336.05	27774.0
2021-06-10 05:30:00	QQQ	ETF	336.0	336.18	335.72	336.0	18478.0
2021-06-10 06:00:00	QQQ	ETF	336.14	336.17	335.95	336.11	14827.0
2021-06-10 06:30:00	QQQ	ETF	335.97	335.98	335.7	335.83	17600.0
2021-06-10 07:00:00	QQQ	ETF	335.79	336.23	335.75	335.94	150248.0
2021-06-10 07:30:00	QQQ	ETF	335.95	336.32	335.16	335.84	91745.0
2021-06-10 08:00:00	QQQ	ETF	335.83	337.09	335.15	336.18	136589.0
2021-06-10 08:30:00	QQQ	ETF	336.1	337.31	334.7	337.15	1151524.0
2021-06-10 09:00:00	QQQ	ETF	337.15	337.69	337.06	337.21	353387.0
2021-06-10 09:30:00	QQQ	ETF	337.22	340.45	336.73	339.94	4437489.0
2021-06-10 10:00:00	QQQ	ETF	339.95	340.34	339.44	339.73	2997136.0
2021-06-10 10:30:00	QQQ	ETF	339.73	339.97	337.09	338.09	3690619.0
2021-06-10 11:00:00	QQQ	ETF	338.09	339.0998	337.6399	339.03	1883703.0
2021-06-10 11:30:00	QQQ	ETF	339.03	339.46	338.78	339.41	1368938.0
2021-06-10 12:00:00	QQQ	ETF	339.43	339.76	339.23	339.281	1161518.0
2021-06-10 12:30:00	QQQ	ETF	339.3	339.99	339.27	339.98	918680.0

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

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