PREVIEW / etf_30min / 2021-09-09

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-09.parquet
  size:    612 KB
  rows:    23,058

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-09-09 04:00:00	SPY	ETF	450.3	450.3	449.54	449.78	24176.0
2021-09-09 04:30:00	SPY	ETF	449.74	449.75	449.56	449.56	5526.0
2021-09-09 05:00:00	SPY	ETF	449.5	449.69	449.3	449.69	8582.0
2021-09-09 05:30:00	SPY	ETF	450.09	450.1	449.77	449.86	3560.0
2021-09-09 06:00:00	SPY	ETF	449.85	449.89	449.68	449.79	10489.0
2021-09-09 06:30:00	SPY	ETF	449.92	449.93	449.59	449.69	30699.0
2021-09-09 07:00:00	SPY	ETF	449.72	449.92	449.72	449.78	36112.0
2021-09-09 07:30:00	SPY	ETF	449.8	450.69	449.42	450.63	111825.0
2021-09-09 08:00:00	SPY	ETF	450.68	451.208	448.3	450.31	179066.0
2021-09-09 08:30:00	SPY	ETF	450.35	451.0	450.2	450.68	258677.0
2021-09-09 09:00:00	SPY	ETF	450.73	450.76	450.62	450.69	161615.0
2021-09-09 09:30:00	SPY	ETF	450.7	452.02	450.48	451.8	4437001.0
2021-09-09 10:00:00	SPY	ETF	451.8	452.5599	451.61	452.22	3189700.0
2021-09-09 10:30:00	SPY	ETF	452.23	452.57	451.84	451.87	2471142.0
2021-09-09 11:00:00	SPY	ETF	451.87	451.97	450.815	450.84	2430434.0
2021-09-09 11:30:00	SPY	ETF	450.85	451.26	450.75	451.22	2321069.0
2021-09-09 12:00:00	SPY	ETF	451.22	451.25	450.47	450.73	2261071.0
2021-09-09 12:30:00	SPY	ETF	450.73	451.095	450.45	450.585	1528557.0
2021-09-09 13:00:00	SPY	ETF	450.585	451.05	449.33	449.79	3736304.0
2021-09-09 13:30:00	SPY	ETF	449.79	449.79	448.97	449.32	3898778.0
2021-09-09 14:00:00	SPY	ETF	449.3199	449.64	448.72	449.38	3443180.0
2021-09-09 14:30:00	SPY	ETF	449.38	449.92	448.94	449.81	2531578.0
2021-09-09 15:00:00	SPY	ETF	449.81	449.99	449.31	449.5	2636313.0
2021-09-09 15:30:00	SPY	ETF	449.51	450.14	448.74	448.96	8670228.0
2021-09-09 16:00:00	SPY	ETF	448.96	450.8912	448.51	448.73	2428434.0
2021-09-09 16:30:00	SPY	ETF	448.73	448.98	448.38	448.72	311981.0
2021-09-09 17:00:00	SPY	ETF	448.73	448.96	448.53	448.95	166914.0
2021-09-09 17:30:00	SPY	ETF	448.95	449.08	448.9	448.9	112833.0
2021-09-09 18:00:00	SPY	ETF	448.89	448.95	448.62	448.65	317061.0
2021-09-09 18:30:00	SPY	ETF	448.98	448.98	448.55	448.84	22084.0
2021-09-09 19:00:00	SPY	ETF	448.83	448.83	448.57	448.75	10047.0
2021-09-09 19:30:00	SPY	ETF	448.75	448.93	448.67	448.79	36529.0
2021-09-09 04:00:00	QQQ	ETF	380.25	380.25	379.85	379.85	21397.0
2021-09-09 04:30:00	QQQ	ETF	379.85	379.85	379.7	379.7	2833.0
2021-09-09 05:00:00	QQQ	ETF	379.65	379.83	379.65	379.83	5758.0
2021-09-09 05:30:00	QQQ	ETF	379.86	380.22	379.86	379.99	7976.0
2021-09-09 06:00:00	QQQ	ETF	380.03	380.08	379.92	380.06	3927.0
2021-09-09 06:30:00	QQQ	ETF	380.12	380.12	379.97	379.97	11542.0
2021-09-09 07:00:00	QQQ	ETF	380.02	380.17	379.91	380.0	26578.0
2021-09-09 07:30:00	QQQ	ETF	379.99	380.95	379.67	380.85	152579.0
2021-09-09 08:00:00	QQQ	ETF	380.87	381.065	379.32	380.59	141116.0
2021-09-09 08:30:00	QQQ	ETF	380.58	381.11	380.45	380.83	124159.0
2021-09-09 09:00:00	QQQ	ETF	380.85	381.13	380.82	381.03	70955.0
2021-09-09 09:30:00	QQQ	ETF	381.01	382.15	380.82	381.75	3046618.0
2021-09-09 10:00:00	QQQ	ETF	381.74	382.14	381.27	381.73	1714053.0
2021-09-09 10:30:00	QQQ	ETF	381.75	381.91	381.42	381.465	1247497.0
2021-09-09 11:00:00	QQQ	ETF	381.47	381.63	380.63	380.66	1737271.0
2021-09-09 11:30:00	QQQ	ETF	380.63	381.04	380.575	381.02	1307992.0
2021-09-09 12:00:00	QQQ	ETF	381.0222	381.18	380.67	381.0292	955830.0
2021-09-09 12:30:00	QQQ	ETF	381.02	381.2601	380.71	380.765	749610.0

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

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