PREVIEW / etf_30min / 2020-12-15

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-15.parquet
  size:    596 KB
  rows:    22,024

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-15 04:00:00	SPY	ETF	366.51	367.0	366.51	366.91	12808.0
2020-12-15 04:30:00	SPY	ETF	367.0	367.15	366.82	366.97	13919.0
2020-12-15 05:00:00	SPY	ETF	366.97	366.97	366.7	366.79	64314.0
2020-12-15 05:30:00	SPY	ETF	366.84	366.86	366.72	366.75	21827.0
2020-12-15 06:00:00	SPY	ETF	366.82	366.96	366.75	366.75	31756.0
2020-12-15 06:30:00	SPY	ETF	366.73	366.84	366.52	366.67	19515.0
2020-12-15 07:00:00	SPY	ETF	366.62	367.46	366.61	367.21	78862.0
2020-12-15 07:30:00	SPY	ETF	367.22	367.25	367.0	367.04	88994.0
2020-12-15 08:00:00	SPY	ETF	367.0233	367.46	364.75	367.18	75050.0
2020-12-15 08:30:00	SPY	ETF	367.15	367.4498	367.1	367.29	117559.0
2020-12-15 09:00:00	SPY	ETF	367.32	367.46	367.11	367.42	156257.0
2020-12-15 09:30:00	SPY	ETF	367.4	367.775	366.69	366.86	4548567.0
2020-12-15 10:00:00	SPY	ETF	366.85	367.17	366.42	366.6	2796854.0
2020-12-15 10:30:00	SPY	ETF	366.59	366.9418	366.0701	366.721	2979708.0
2020-12-15 11:00:00	SPY	ETF	366.74	366.8	365.92	366.71	3471130.0
2020-12-15 11:30:00	SPY	ETF	366.7	367.25	366.53	367.1597	4907826.0
2020-12-15 12:00:00	SPY	ETF	367.15	367.6589	367.08	367.57	5466984.0
2020-12-15 12:30:00	SPY	ETF	367.5786	368.54	367.55	368.49	3438481.0
2020-12-15 13:00:00	SPY	ETF	368.5	369.195	368.37	368.755	3405098.0
2020-12-15 13:30:00	SPY	ETF	368.755	369.26	368.74	369.175	2524843.0
2020-12-15 14:00:00	SPY	ETF	369.16	369.49	368.97	369.205	3282152.0
2020-12-15 14:30:00	SPY	ETF	369.2099	369.56	369.16	369.21	2079374.0
2020-12-15 15:00:00	SPY	ETF	369.22	369.5798	368.84	368.85	4392416.0
2020-12-15 15:30:00	SPY	ETF	368.85	369.57	368.6	369.57	7728308.0
2020-12-15 16:00:00	SPY	ETF	369.55	369.6	368.44	369.22	10091772.0
2020-12-15 16:30:00	SPY	ETF	369.22	369.56	369.22	369.33	86445.0
2020-12-15 17:00:00	SPY	ETF	369.43	369.79	369.42	369.67	449810.0
2020-12-15 17:30:00	SPY	ETF	369.66	369.77	369.62	369.72	35730.0
2020-12-15 18:00:00	SPY	ETF	369.7	369.7	369.27	369.3	179672.0
2020-12-15 18:30:00	SPY	ETF	369.3	369.37	369.21	369.32	20155.0
2020-12-15 19:00:00	SPY	ETF	369.4	369.45	369.0	369.02	52616.0
2020-12-15 19:30:00	SPY	ETF	369.01	369.1	368.8	369.08	59778.0
2020-12-15 04:00:00	QQQ	ETF	305.0	305.31	305.0	305.26	10234.0
2020-12-15 04:30:00	QQQ	ETF	305.28	305.47	305.21	305.26	9924.0
2020-12-15 05:00:00	QQQ	ETF	305.27	305.27	305.1	305.12	3105.0
2020-12-15 05:30:00	QQQ	ETF	305.12	305.22	305.02	305.08	2220.0
2020-12-15 06:00:00	QQQ	ETF	305.18	305.18	305.06	305.12	2807.0
2020-12-15 06:30:00	QQQ	ETF	305.12	305.14	304.9	305.02	16252.0
2020-12-15 07:00:00	QQQ	ETF	304.99	305.74	304.99	305.74	71875.0
2020-12-15 07:30:00	QQQ	ETF	305.69	305.82	305.62	305.76	32810.0
2020-12-15 08:00:00	QQQ	ETF	305.78	306.0	303.97	305.9102	97671.0
2020-12-15 08:30:00	QQQ	ETF	305.95	306.28	305.89	306.24	71280.0
2020-12-15 09:00:00	QQQ	ETF	306.25	306.45	306.15	306.37	142821.0
2020-12-15 09:30:00	QQQ	ETF	306.35	306.83	305.81	306.38	2751141.0
2020-12-15 10:00:00	QQQ	ETF	306.39	306.68	305.85	306.0669	1358412.0
2020-12-15 10:30:00	QQQ	ETF	306.0798	306.39	305.36	305.49	1410345.0
2020-12-15 11:00:00	QQQ	ETF	305.48	305.48	304.11	304.64	2020709.0
2020-12-15 11:30:00	QQQ	ETF	304.61	305.25	304.39	304.92	1412699.0
2020-12-15 12:00:00	QQQ	ETF	304.91	305.54	304.86	305.501	942687.0
2020-12-15 12:30:00	QQQ	ETF	305.51	305.78	305.29	305.7274	836513.0

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

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