PREVIEW / etf_30min / 2021-06-02

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-02.parquet
  size:    595 KB
  rows:    23,210

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-06-02 04:00:00	SPY	ETF	419.35	419.68	419.3	419.58	1250.0
2021-06-02 04:30:00	SPY	ETF	419.41	419.43	419.09	419.15	10838.0
2021-06-02 05:00:00	SPY	ETF	419.2	419.58	419.2	419.48	4800.0
2021-06-02 05:30:00	SPY	ETF	419.47	419.72	419.45	419.72	2338.0
2021-06-02 06:00:00	SPY	ETF	419.58	419.6	419.52	419.59	2698.0
2021-06-02 06:30:00	SPY	ETF	419.62	419.8	419.62	419.78	19869.0
2021-06-02 07:00:00	SPY	ETF	419.79	419.92	419.49	419.76	38918.0
2021-06-02 07:30:00	SPY	ETF	419.68	419.89	419.65	419.79	29804.0
2021-06-02 08:00:00	SPY	ETF	419.9099	420.36	419.57	420.2699	73028.0
2021-06-02 08:30:00	SPY	ETF	420.22	420.47	420.18	420.455	59310.0
2021-06-02 09:00:00	SPY	ETF	420.46	420.61	420.16	420.38	137042.0
2021-06-02 09:30:00	SPY	ETF	420.37	420.68	419.55	420.41	3907567.0
2021-06-02 10:00:00	SPY	ETF	420.4	420.9781	420.24	420.84	2748931.0
2021-06-02 10:30:00	SPY	ETF	420.85	420.98	420.485	420.6952	2178515.0
2021-06-02 11:00:00	SPY	ETF	420.71	421.23	420.5	421.075	2136896.0
2021-06-02 11:30:00	SPY	ETF	421.075	421.19	420.77	420.8435	1076715.0
2021-06-02 12:00:00	SPY	ETF	420.85	420.91	420.26	420.41	1246049.0
2021-06-02 12:30:00	SPY	ETF	420.4	420.51	420.13	420.435	1263382.0
2021-06-02 13:00:00	SPY	ETF	420.435	420.53	419.59	419.835	1956805.0
2021-06-02 13:30:00	SPY	ETF	419.84	420.04	419.57	419.79	1645906.0
2021-06-02 14:00:00	SPY	ETF	419.785	420.04	419.29	419.79	2117750.0
2021-06-02 14:30:00	SPY	ETF	419.79	419.94	419.65	419.9	1414725.0
2021-06-02 15:00:00	SPY	ETF	419.89	420.05	419.7	419.779	2310481.0
2021-06-02 15:30:00	SPY	ETF	419.775	420.47	419.58	420.3601	8135638.0
2021-06-02 16:00:00	SPY	ETF	420.36	420.44	420.15	420.23	2308491.0
2021-06-02 16:30:00	SPY	ETF	420.23	420.38	419.9	420.38	591217.0
2021-06-02 17:00:00	SPY	ETF	420.39	420.4	420.3	420.4	58221.0
2021-06-02 17:30:00	SPY	ETF	420.39	420.48	420.38	420.48	26804.0
2021-06-02 18:00:00	SPY	ETF	420.49	420.55	420.38	420.5	77018.0
2021-06-02 18:30:00	SPY	ETF	420.33	420.5	420.33	420.42	10771.0
2021-06-02 19:00:00	SPY	ETF	420.38	420.45	420.35	420.38	6684.0
2021-06-02 19:30:00	SPY	ETF	420.41	420.63	420.39	420.63	32361.0
2021-06-02 04:00:00	QQQ	ETF	332.39	332.6	332.29	332.29	3859.0
2021-06-02 04:30:00	QQQ	ETF	332.34	332.37	332.15	332.26	4344.0
2021-06-02 05:00:00	QQQ	ETF	332.26	332.37	332.11	332.35	7684.0
2021-06-02 05:30:00	QQQ	ETF	332.4	332.57	332.32	332.56	7798.0
2021-06-02 06:00:00	QQQ	ETF	332.52	332.58	332.34	332.5	4264.0
2021-06-02 06:30:00	QQQ	ETF	332.51	332.73	332.51	332.73	11577.0
2021-06-02 07:00:00	QQQ	ETF	332.72	333.0	332.59	332.74	56427.0
2021-06-02 07:30:00	QQQ	ETF	332.78	332.97	332.69	332.9	25421.0
2021-06-02 08:00:00	QQQ	ETF	332.7004	333.36	332.3504	333.33	74589.0
2021-06-02 08:30:00	QQQ	ETF	333.23	333.38	333.14	333.31	53807.0
2021-06-02 09:00:00	QQQ	ETF	333.33	333.45	333.16	333.27	46179.0
2021-06-02 09:30:00	QQQ	ETF	333.25	334.24	332.8601	333.53	2949243.0
2021-06-02 10:00:00	QQQ	ETF	333.53	334.07	333.02	334.0258	1811421.0
2021-06-02 10:30:00	QQQ	ETF	334.03	334.34	333.4198	333.66	1430614.0
2021-06-02 11:00:00	QQQ	ETF	333.66	334.02	333.47	333.97	1260785.0
2021-06-02 11:30:00	QQQ	ETF	333.97	334.185	333.825	333.945	708419.0
2021-06-02 12:00:00	QQQ	ETF	333.96	334.01	332.97	333.17	943085.0
2021-06-02 12:30:00	QQQ	ETF	333.17	333.44	332.99	333.2999	893880.0

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

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