PREVIEW / etf_30min / 2020-12-07

all etf 30-min files

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

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-07 04:00:00	SPY	ETF	367.56	367.87	367.36	367.87	34699.0
2020-12-07 04:30:00	SPY	ETF	367.9	368.19	367.9	368.12	11193.0
2020-12-07 05:00:00	SPY	ETF	368.06	368.54	368.06	368.54	13983.0
2020-12-07 05:30:00	SPY	ETF	368.6	368.6	368.15	368.15	6370.0
2020-12-07 06:00:00	SPY	ETF	368.04	368.41	368.04	368.41	11542.0
2020-12-07 06:30:00	SPY	ETF	368.5	368.72	368.31	368.65	37954.0
2020-12-07 07:00:00	SPY	ETF	368.66	368.72	368.4	368.41	38686.0
2020-12-07 07:30:00	SPY	ETF	368.42	368.69	368.24	368.61	192063.0
2020-12-07 08:00:00	SPY	ETF	368.5201	369.1	367.54	368.69	174319.0
2020-12-07 08:30:00	SPY	ETF	368.69	368.99	368.6	368.94	125141.0
2020-12-07 09:00:00	SPY	ETF	368.93	369.1	368.88	369.02	182090.0
2020-12-07 09:30:00	SPY	ETF	369.02	369.365	368.84	369.365	3862251.0
2020-12-07 10:00:00	SPY	ETF	369.37	369.5	369.0501	369.4	2516164.0
2020-12-07 10:30:00	SPY	ETF	369.41	369.59	369.22	369.34	2005381.0
2020-12-07 11:00:00	SPY	ETF	369.33	369.55	369.23	369.465	1407545.0
2020-12-07 11:30:00	SPY	ETF	369.46	369.62	369.01	369.42	3034933.0
2020-12-07 12:00:00	SPY	ETF	369.41	369.48	369.09	369.2	2357470.0
2020-12-07 12:30:00	SPY	ETF	369.2	369.25	368.86	368.8699	1672081.0
2020-12-07 13:00:00	SPY	ETF	368.86	368.9199	368.24	368.57	3146327.0
2020-12-07 13:30:00	SPY	ETF	368.55	368.77	368.0575	368.42	2052982.0
2020-12-07 14:00:00	SPY	ETF	368.42	368.52	367.89	368.4659	2855332.0
2020-12-07 14:30:00	SPY	ETF	368.465	368.75	368.33	368.3901	2715459.0
2020-12-07 15:00:00	SPY	ETF	368.4	368.85	368.23	368.745	3495733.0
2020-12-07 15:30:00	SPY	ETF	368.74	369.205	367.72	369.12	9383085.0
2020-12-07 16:00:00	SPY	ETF	369.14	369.26	368.71	368.92	4702480.0
2020-12-07 16:30:00	SPY	ETF	368.9	369.09	367.97	368.14	1384840.0
2020-12-07 17:00:00	SPY	ETF	368.14	368.33	368.06	368.2	67168.0
2020-12-07 17:30:00	SPY	ETF	368.32	369.07	368.25	368.25	287878.0
2020-12-07 18:00:00	SPY	ETF	368.25	368.36	368.21	368.28	30759.0
2020-12-07 18:30:00	SPY	ETF	368.36	368.43	368.2	368.23	73803.0
2020-12-07 19:00:00	SPY	ETF	368.21	368.21	367.8	368.03	50298.0
2020-12-07 19:30:00	SPY	ETF	368.08	368.31	368.06	368.28	98882.0
2020-12-07 04:00:00	QQQ	ETF	304.59	304.85	304.44	304.78	13307.0
2020-12-07 04:30:00	QQQ	ETF	304.8	305.12	304.8	304.84	14088.0
2020-12-07 05:00:00	QQQ	ETF	304.89	305.32	304.88	305.32	8350.0
2020-12-07 05:30:00	QQQ	ETF	305.41	305.41	305.16	305.27	10593.0
2020-12-07 06:00:00	QQQ	ETF	305.1	305.45	305.1	305.4	5800.0
2020-12-07 06:30:00	QQQ	ETF	305.4	305.4	305.29	305.38	9549.0
2020-12-07 07:00:00	QQQ	ETF	305.39	305.52	305.28	305.32	29893.0
2020-12-07 07:30:00	QQQ	ETF	305.26	305.44	305.16	305.41	29632.0
2020-12-07 08:00:00	QQQ	ETF	305.19	305.68	305.18	305.61	59961.0
2020-12-07 08:30:00	QQQ	ETF	305.58	305.72	305.48	305.72	52038.0
2020-12-07 09:00:00	QQQ	ETF	305.692	305.86	305.67	305.71	75716.0
2020-12-07 09:30:00	QQQ	ETF	305.71	307.03	305.52	306.931	2884371.0
2020-12-07 10:00:00	QQQ	ETF	306.9882	307.33	306.91	307.0599	1053138.0
2020-12-07 10:30:00	QQQ	ETF	307.07	307.339	306.75	307.03	733706.0
2020-12-07 11:00:00	QQQ	ETF	307.03	307.63	306.89	307.35	916409.0
2020-12-07 11:30:00	QQQ	ETF	307.37	307.41	306.92	307.13	779581.0
2020-12-07 12:00:00	QQQ	ETF	307.1291	307.1291	306.63	307.03	616403.0
2020-12-07 12:30:00	QQQ	ETF	307.02	307.07	306.66	306.6602	318487.0

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

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