PREVIEW / etf_30min / 2021-01-14

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-14.parquet
  size:    634 KB
  rows:    23,607

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-01-14 04:00:00	SPY	ETF	380.81	380.92	380.67	380.76	22186.0
2021-01-14 04:30:00	SPY	ETF	380.81	380.89	380.75	380.83	2316.0
2021-01-14 05:00:00	SPY	ETF	380.76	380.76	380.19	380.34	12462.0
2021-01-14 05:30:00	SPY	ETF	380.36	380.46	380.04	380.3	10491.0
2021-01-14 06:00:00	SPY	ETF	380.38	380.42	380.0	380.07	16150.0
2021-01-14 06:30:00	SPY	ETF	380.07	380.46	380.06	380.46	8177.0
2021-01-14 07:00:00	SPY	ETF	380.44	380.55	380.34	380.45	50102.0
2021-01-14 07:30:00	SPY	ETF	380.37	380.51	380.26	380.48	147614.0
2021-01-14 08:00:00	SPY	ETF	380.47	380.54	380.25	380.3499	242017.0
2021-01-14 08:30:00	SPY	ETF	380.4	380.57	380.05	380.45	271620.0
2021-01-14 09:00:00	SPY	ETF	380.48	380.71	380.45	380.64	180124.0
2021-01-14 09:30:00	SPY	ETF	380.59	380.93	380.22	380.835	3661714.0
2021-01-14 10:00:00	SPY	ETF	380.83	381.13	380.48	380.965	2297849.0
2021-01-14 10:30:00	SPY	ETF	380.965	381.09	380.36	380.77	2153502.0
2021-01-14 11:00:00	SPY	ETF	380.76	380.87	380.4001	380.5499	1508628.0
2021-01-14 11:30:00	SPY	ETF	380.545	380.615	380.18	380.38	2526567.0
2021-01-14 12:00:00	SPY	ETF	380.37	380.53	380.1	380.39	1515188.0
2021-01-14 12:30:00	SPY	ETF	380.4	380.76	379.84	380.63	2543451.0
2021-01-14 13:00:00	SPY	ETF	380.63	380.73	380.07	380.29	1835524.0
2021-01-14 13:30:00	SPY	ETF	380.28	380.62	380.16	380.24	1017534.0
2021-01-14 14:00:00	SPY	ETF	380.24	380.52	379.99	380.178	1300339.0
2021-01-14 14:30:00	SPY	ETF	380.17	380.29	379.65	379.9031	1935127.0
2021-01-14 15:00:00	SPY	ETF	379.905	380.08	378.58	379.17	5321290.0
2021-01-14 15:30:00	SPY	ETF	379.17	379.55	378.1	378.45	13282955.0
2021-01-14 16:00:00	SPY	ETF	378.49	378.85	378.27	378.78	5790024.0
2021-01-14 16:30:00	SPY	ETF	378.78	378.8	378.26	378.46	708091.0
2021-01-14 17:00:00	SPY	ETF	378.37	378.8	378.37	378.75	313472.0
2021-01-14 17:30:00	SPY	ETF	378.79	378.87	378.46	378.87	58680.0
2021-01-14 18:00:00	SPY	ETF	378.86	379.15	378.74	379.07	92052.0
2021-01-14 18:30:00	SPY	ETF	379.14	379.22	378.9	379.02	19155.0
2021-01-14 19:00:00	SPY	ETF	378.91	379.05	378.45	379.01	93085.0
2021-01-14 19:30:00	SPY	ETF	378.99	379.01	378.0	378.25	125349.0
2021-01-14 04:00:00	QQQ	ETF	316.08	316.33	315.98	316.11	20810.0
2021-01-14 04:30:00	QQQ	ETF	316.03	316.17	315.65	315.65	11445.0
2021-01-14 05:00:00	QQQ	ETF	315.65	315.65	315.0	315.07	12558.0
2021-01-14 05:30:00	QQQ	ETF	314.99	315.43	314.97	315.43	9588.0
2021-01-14 06:00:00	QQQ	ETF	315.49	315.71	315.02	315.15	27925.0
2021-01-14 06:30:00	QQQ	ETF	315.19	315.89	315.19	315.88	20515.0
2021-01-14 07:00:00	QQQ	ETF	315.92	316.11	315.82	316.05	68133.0
2021-01-14 07:30:00	QQQ	ETF	316.0	316.33	315.79	316.2	68007.0
2021-01-14 08:00:00	QQQ	ETF	315.69	316.22	315.5696	316.17	144656.0
2021-01-14 08:30:00	QQQ	ETF	316.18	316.53	316.05	316.41	67907.0
2021-01-14 09:00:00	QQQ	ETF	316.4402	316.54	316.29	316.46	83184.0
2021-01-14 09:30:00	QQQ	ETF	316.47	317.2	316.07	316.67	2283336.0
2021-01-14 10:00:00	QQQ	ETF	316.66	317.08	316.36	316.92	1053667.0
2021-01-14 10:30:00	QQQ	ETF	316.94	317.53	316.65	317.15	1375465.0
2021-01-14 11:00:00	QQQ	ETF	317.15	317.38	316.51	316.78	762242.0
2021-01-14 11:30:00	QQQ	ETF	316.785	316.91	316.05	316.252	1379404.0
2021-01-14 12:00:00	QQQ	ETF	316.2674	316.35	315.7	316.17	879041.0
2021-01-14 12:30:00	QQQ	ETF	316.16	316.42	315.2	316.3698	1406612.0

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

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