PREVIEW / etf_30min / 2020-10-01

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-01.parquet
  size:    562 KB
  rows:    20,876

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-10-01 04:00:00	SPY	ETF	337.66	338.08	337.31	337.64	79090.0
2020-10-01 04:30:00	SPY	ETF	337.35	337.35	336.65	336.94	49748.0
2020-10-01 05:00:00	SPY	ETF	336.89	337.8	336.88	337.8	35734.0
2020-10-01 05:30:00	SPY	ETF	337.84	338.38	337.73	338.29	37205.0
2020-10-01 06:00:00	SPY	ETF	338.34	338.6	337.85	338.26	132340.0
2020-10-01 06:30:00	SPY	ETF	338.22	338.22	337.85	338.12	41637.0
2020-10-01 07:00:00	SPY	ETF	338.05	338.47	337.98	338.31	104172.0
2020-10-01 07:30:00	SPY	ETF	338.36	338.72	338.18	338.47	196889.0
2020-10-01 08:00:00	SPY	ETF	338.3099	338.64	334.89	338.12	277986.0
2020-10-01 08:30:00	SPY	ETF	338.22	338.4	337.0	337.66	342811.0
2020-10-01 09:00:00	SPY	ETF	337.65	338.03	337.18	337.63	370554.0
2020-10-01 09:30:00	SPY	ETF	337.69	338.74	336.61	336.76	10357080.0
2020-10-01 10:00:00	SPY	ETF	336.74	337.07	335.58	336.1899	6893137.0
2020-10-01 10:30:00	SPY	ETF	336.19	337.41	335.9401	336.68	4989115.0
2020-10-01 11:00:00	SPY	ETF	336.68	337.33	335.8	337.19	7037683.0
2020-10-01 11:30:00	SPY	ETF	337.22	337.64	336.73	337.2	2898057.0
2020-10-01 12:00:00	SPY	ETF	337.2	337.25	336.245	337.15	4515479.0
2020-10-01 12:30:00	SPY	ETF	337.14	337.39	336.8	337.17	2197811.0
2020-10-01 13:00:00	SPY	ETF	337.17	337.653	336.58	336.82	3190982.0
2020-10-01 13:30:00	SPY	ETF	336.82	337.16	335.87	336.25	5285352.0
2020-10-01 14:00:00	SPY	ETF	336.24	336.9601	335.01	336.28	8532519.0
2020-10-01 14:30:00	SPY	ETF	336.27	337.19	336.23	336.95	3875209.0
2020-10-01 15:00:00	SPY	ETF	336.96	337.44	335.91	336.075	5856677.0
2020-10-01 15:30:00	SPY	ETF	336.07	337.19	335.815	337.03	12265251.0
2020-10-01 16:00:00	SPY	ETF	337.02	337.44	335.2417	336.9	5506689.0
2020-10-01 16:30:00	SPY	ETF	336.87	337.14	336.65	336.74	298768.0
2020-10-01 17:00:00	SPY	ETF	336.84	337.0	336.8	336.9	218202.0
2020-10-01 17:30:00	SPY	ETF	336.9	336.95	336.81	336.81	20774.0
2020-10-01 18:00:00	SPY	ETF	336.81	337.46	336.5	336.64	190376.0
2020-10-01 18:30:00	SPY	ETF	336.64	337.49	336.25	337.13	151062.0
2020-10-01 19:00:00	SPY	ETF	337.2	337.25	336.74	336.78	60560.0
2020-10-01 19:30:00	SPY	ETF	336.86	336.9	336.57	336.77	48694.0
2020-10-01 04:00:00	QQQ	ETF	280.22	280.9	279.97	280.58	50203.0
2020-10-01 04:30:00	QQQ	ETF	280.48	280.48	279.66	279.97	40019.0
2020-10-01 05:00:00	QQQ	ETF	279.96	280.88	279.96	280.8	39340.0
2020-10-01 05:30:00	QQQ	ETF	280.93	281.62	280.8	281.57	34364.0
2020-10-01 06:00:00	QQQ	ETF	281.6	282.19	281.35	282.06	28388.0
2020-10-01 06:30:00	QQQ	ETF	281.97	282.02	281.6	281.94	31776.0
2020-10-01 07:00:00	QQQ	ETF	281.84	282.03	281.56	281.88	114380.0
2020-10-01 07:30:00	QQQ	ETF	281.8	282.29	281.75	282.12	159975.0
2020-10-01 08:00:00	QQQ	ETF	282.13	282.2	277.84	281.9	244242.0
2020-10-01 08:30:00	QQQ	ETF	281.86	282.71	281.7	281.87	417332.0
2020-10-01 09:00:00	QQQ	ETF	281.8498	282.26	281.52	281.85	217496.0
2020-10-01 09:30:00	QQQ	ETF	281.84	282.15	280.75	281.03	4863076.0
2020-10-01 10:00:00	QQQ	ETF	281.03	281.4699	280.12	280.59	2663453.0
2020-10-01 10:30:00	QQQ	ETF	280.585	281.55	280.31	280.88	2098296.0
2020-10-01 11:00:00	QQQ	ETF	280.88	281.4	279.84	281.38	2178171.0
2020-10-01 11:30:00	QQQ	ETF	281.38	281.86	280.95	281.28	1705799.0
2020-10-01 12:00:00	QQQ	ETF	281.235	281.36	280.45	281.07	1577668.0
2020-10-01 12:30:00	QQQ	ETF	281.09	281.59	280.8228	281.54	1261717.0

> showing 50 of 20,876 rows — these rows as CSV

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