PREVIEW / etf_30min / 2021-04-16

all etf 30-min files

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

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-16 04:00:00	SPY	ETF	415.46	415.58	415.32	415.46	9840.0
2021-04-16 04:30:00	SPY	ETF	415.42	415.6	415.28	415.6	2146.0
2021-04-16 05:00:00	SPY	ETF	415.55	415.7	415.55	415.68	1700.0
2021-04-16 05:30:00	SPY	ETF	415.79	416.21	415.79	416.1	9322.0
2021-04-16 06:00:00	SPY	ETF	416.06	416.11	415.98	416.07	10653.0
2021-04-16 06:30:00	SPY	ETF	416.06	416.2	416.04	416.08	23070.0
2021-04-16 07:00:00	SPY	ETF	416.02	416.37	415.98	416.3	63089.0
2021-04-16 07:30:00	SPY	ETF	416.31	416.5	416.22	416.48	103660.0
2021-04-16 08:00:00	SPY	ETF	416.47	416.76	415.3	416.58	176099.0
2021-04-16 08:30:00	SPY	ETF	416.62	416.87	416.48	416.85	90425.0
2021-04-16 09:00:00	SPY	ETF	416.85	417.34	416.48	417.26	328866.0
2021-04-16 09:30:00	SPY	ETF	417.25	417.39	415.91	416.1	6307091.0
2021-04-16 10:00:00	SPY	ETF	416.11	417.01	415.73	416.42	4713122.0
2021-04-16 10:30:00	SPY	ETF	416.419	416.95	416.26	416.61	3281334.0
2021-04-16 11:00:00	SPY	ETF	416.6	417.0	416.28	416.31	2624955.0
2021-04-16 11:30:00	SPY	ETF	416.315	416.56	416.19	416.4	1810280.0
2021-04-16 12:00:00	SPY	ETF	416.4	416.845	416.4	416.75	1594198.0
2021-04-16 12:30:00	SPY	ETF	416.75	416.87	416.43	416.6	1350778.0
2021-04-16 13:00:00	SPY	ETF	416.61	416.67	416.43	416.55	1299980.0
2021-04-16 13:30:00	SPY	ETF	416.56	416.8	416.49	416.5	1735300.0
2021-04-16 14:00:00	SPY	ETF	416.499	417.17	416.4	417.0709	3196090.0
2021-04-16 14:30:00	SPY	ETF	417.075	417.49	417.07	417.44	2585024.0
2021-04-16 15:00:00	SPY	ETF	417.44	417.59	417.18	417.501	3774246.0
2021-04-16 15:30:00	SPY	ETF	417.51	417.91	417.1	417.3101	13870181.0
2021-04-16 16:00:00	SPY	ETF	417.32	417.35	416.74	416.9	5743083.0
2021-04-16 16:30:00	SPY	ETF	416.9	416.95	416.8	416.82	275583.0
2021-04-16 17:00:00	SPY	ETF	416.75	417.26	416.71	416.95	296020.0
2021-04-16 17:30:00	SPY	ETF	416.94	416.94	416.8	416.8	17322.0
2021-04-16 18:00:00	SPY	ETF	416.9	417.12	416.9	417.0	36509.0
2021-04-16 18:30:00	SPY	ETF	416.95	417.08	416.95	417.08	2910.0
2021-04-16 19:00:00	SPY	ETF	417.08	417.08	416.95	416.95	4177.0
2021-04-16 19:30:00	SPY	ETF	416.95	416.95	416.75	416.75	9787.0
2021-04-16 04:00:00	QQQ	ETF	340.56	340.97	340.5	340.62	23027.0
2021-04-16 04:30:00	QQQ	ETF	340.59	340.72	340.51	340.62	11681.0
2021-04-16 05:00:00	QQQ	ETF	340.6	340.87	340.6	340.87	6199.0
2021-04-16 05:30:00	QQQ	ETF	340.84	341.12	340.7	341.02	27997.0
2021-04-16 06:00:00	QQQ	ETF	341.04	341.1	340.91	341.06	7967.0
2021-04-16 06:30:00	QQQ	ETF	341.12	341.36	341.12	341.23	21043.0
2021-04-16 07:00:00	QQQ	ETF	341.23	341.74	341.19	341.7	74473.0
2021-04-16 07:30:00	QQQ	ETF	341.66	341.96	341.66	341.89	44126.0
2021-04-16 08:00:00	QQQ	ETF	341.2196	342.61	340.54	342.33	198988.0
2021-04-16 08:30:00	QQQ	ETF	342.37	342.52	342.27	342.44	137223.0
2021-04-16 09:00:00	QQQ	ETF	342.39	342.39	341.76	342.14	364361.0
2021-04-16 09:30:00	QQQ	ETF	342.15	342.15	340.08	340.34	3814312.0
2021-04-16 10:00:00	QQQ	ETF	340.34	341.9799	340.14	341.17	2767973.0
2021-04-16 10:30:00	QQQ	ETF	341.165	341.66	340.7389	341.31	1591321.0
2021-04-16 11:00:00	QQQ	ETF	341.3	341.66	340.8701	341.02	1525706.0
2021-04-16 11:30:00	QQQ	ETF	341.03	341.43	340.92	341.38	1165614.0
2021-04-16 12:00:00	QQQ	ETF	341.42	342.09	341.27	341.9409	1276101.0
2021-04-16 12:30:00	QQQ	ETF	341.94	342.12	341.64	341.785	1054282.0

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

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