PREVIEW / etf_30min / 2020-12-08

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-08.parquet
  size:    588 KB
  rows:    21,931

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
2020-12-08 04:00:00	SPY	ETF	368.28	368.74	368.26	368.26	9575.0
2020-12-08 04:30:00	SPY	ETF	368.19	368.19	367.59	367.83	16512.0
2020-12-08 05:00:00	SPY	ETF	367.82	367.82	367.54	367.67	8607.0
2020-12-08 05:30:00	SPY	ETF	367.77	367.95	367.6	367.76	17356.0
2020-12-08 06:00:00	SPY	ETF	367.6	367.61	367.0	367.48	31984.0
2020-12-08 06:30:00	SPY	ETF	367.47	367.47	366.41	366.46	35264.0
2020-12-08 07:00:00	SPY	ETF	366.69	367.2	366.69	367.05	73060.0
2020-12-08 07:30:00	SPY	ETF	367.03	367.43	367.02	367.32	126780.0
2020-12-08 08:00:00	SPY	ETF	367.35	368.0	366.7101	367.78	165243.0
2020-12-08 08:30:00	SPY	ETF	367.78	367.78	367.51	367.64	252021.0
2020-12-08 09:00:00	SPY	ETF	367.67	367.75	367.35	367.7	222635.0
2020-12-08 09:30:00	SPY	ETF	367.72	368.55	367.67	368.4801	4730466.0
2020-12-08 10:00:00	SPY	ETF	368.48	368.79	367.73	368.1903	3377561.0
2020-12-08 10:30:00	SPY	ETF	368.19	369.04	368.04	369.025	2325966.0
2020-12-08 11:00:00	SPY	ETF	369.03	369.53	369.0138	369.51	1908871.0
2020-12-08 11:30:00	SPY	ETF	369.52	369.79	369.3319	369.64	1485771.0
2020-12-08 12:00:00	SPY	ETF	369.635	369.92	369.52	369.82	1405597.0
2020-12-08 12:30:00	SPY	ETF	369.82	370.31	369.75	370.02	1562113.0
2020-12-08 13:00:00	SPY	ETF	370.025	370.27	369.94	370.195	1128455.0
2020-12-08 13:30:00	SPY	ETF	370.2	370.36	369.99	370.0616	1135251.0
2020-12-08 14:00:00	SPY	ETF	370.07	370.78	369.9	370.6081	1946680.0
2020-12-08 14:30:00	SPY	ETF	370.61	370.655	370.01	370.24	1936668.0
2020-12-08 15:00:00	SPY	ETF	370.265	370.35	370.0	370.235	2228097.0
2020-12-08 15:30:00	SPY	ETF	370.23	370.39	369.92	370.1599	7201439.0
2020-12-08 16:00:00	SPY	ETF	370.15	370.38	370.0	370.1	5400323.0
2020-12-08 16:30:00	SPY	ETF	370.11	370.26	370.0	370.22	338142.0
2020-12-08 17:00:00	SPY	ETF	370.25	370.42	370.25	370.34	51921.0
2020-12-08 17:30:00	SPY	ETF	370.39	370.51	370.35	370.5	74729.0
2020-12-08 18:00:00	SPY	ETF	370.54	371.41	370.17	370.85	229512.0
2020-12-08 18:30:00	SPY	ETF	370.85	370.87	370.58	370.61	35042.0
2020-12-08 19:00:00	SPY	ETF	370.61	371.21	370.61	371.18	95943.0
2020-12-08 19:30:00	SPY	ETF	371.15	371.26	370.85	371.0	46898.0
2020-12-08 04:00:00	QQQ	ETF	307.06	307.32	307.06	307.12	20753.0
2020-12-08 04:30:00	QQQ	ETF	307.12	307.13	306.79	307.03	14139.0
2020-12-08 05:00:00	QQQ	ETF	306.99	307.12	306.95	307.12	2256.0
2020-12-08 05:30:00	QQQ	ETF	307.16	307.24	307.11	307.11	2992.0
2020-12-08 06:00:00	QQQ	ETF	307.0	307.04	306.23	306.44	24611.0
2020-12-08 06:30:00	QQQ	ETF	306.23	306.26	305.65	305.68	45494.0
2020-12-08 07:00:00	QQQ	ETF	305.76	306.16	305.74	306.07	56950.0
2020-12-08 07:30:00	QQQ	ETF	306.05	306.24	305.98	306.24	40772.0
2020-12-08 08:00:00	QQQ	ETF	305.8	307.25	305.73	306.34	51464.0
2020-12-08 08:30:00	QQQ	ETF	306.2599	306.57	306.2599	306.53	46860.0
2020-12-08 09:00:00	QQQ	ETF	306.58	306.8	306.32	306.8	77589.0
2020-12-08 09:30:00	QQQ	ETF	306.78	307.03	305.52	306.11	2006506.0
2020-12-08 10:00:00	QQQ	ETF	306.1694	306.58	304.95	305.4	1967243.0
2020-12-08 10:30:00	QQQ	ETF	305.39	306.4	305.29	306.31	1165553.0
2020-12-08 11:00:00	QQQ	ETF	306.31	306.6	305.9921	306.42	1126368.0
2020-12-08 11:30:00	QQQ	ETF	306.42	307.02	306.305	306.98	786441.0
2020-12-08 12:00:00	QQQ	ETF	306.97	307.35	306.82	307.01	830047.0
2020-12-08 12:30:00	QQQ	ETF	306.99	307.37	306.96	307.35	671321.0

> showing 50 of 21,931 rows — these rows as CSV

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