PREVIEW / etf_30min / 2021-09-10

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-10.parquet
  size:    609 KB
  rows:    23,011

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-10 04:00:00	SPY	ETF	450.38	450.73	449.86	450.71	20810.0
2021-09-10 04:30:00	SPY	ETF	450.76	451.06	450.76	450.92	29635.0
2021-09-10 05:00:00	SPY	ETF	450.75	450.76	450.68	450.72	14673.0
2021-09-10 05:30:00	SPY	ETF	450.64	450.67	450.52	450.52	3100.0
2021-09-10 06:00:00	SPY	ETF	450.53	450.67	450.53	450.65	8427.0
2021-09-10 06:30:00	SPY	ETF	450.71	450.73	450.54	450.73	26684.0
2021-09-10 07:00:00	SPY	ETF	450.74	450.89	450.66	450.81	61643.0
2021-09-10 07:30:00	SPY	ETF	450.81	450.88	450.65	450.82	88535.0
2021-09-10 08:00:00	SPY	ETF	450.6799	451.0	450.0	450.64	165017.0
2021-09-10 08:30:00	SPY	ETF	450.66	450.89	450.66	450.8	76740.0
2021-09-10 09:00:00	SPY	ETF	450.81	451.1	450.65	451.02	280390.0
2021-09-10 09:30:00	SPY	ETF	451.04	451.49	449.49	449.7	6671530.0
2021-09-10 10:00:00	SPY	ETF	449.71	449.71	448.68	449.0	5366810.0
2021-09-10 10:30:00	SPY	ETF	448.98	448.98	447.41	448.21	7050760.0
2021-09-10 11:00:00	SPY	ETF	448.2	448.36	447.5028	447.5028	3698820.0
2021-09-10 11:30:00	SPY	ETF	447.51	448.08	447.34	447.915	3518145.0
2021-09-10 12:00:00	SPY	ETF	447.915	448.87	447.72	448.82	2351699.0
2021-09-10 12:30:00	SPY	ETF	448.83	449.315	448.78	449.115	1754493.0
2021-09-10 13:00:00	SPY	ETF	449.12	451.0196	448.74	448.77	2049900.0
2021-09-10 13:30:00	SPY	ETF	448.78	449.15	448.42	448.635	1488659.0
2021-09-10 14:00:00	SPY	ETF	448.64	448.77	448.08	448.1	1525386.0
2021-09-10 14:30:00	SPY	ETF	448.1	448.21	447.83	447.905	1784906.0
2021-09-10 15:00:00	SPY	ETF	447.9	447.92	446.7901	446.86	5193581.0
2021-09-10 15:30:00	SPY	ETF	446.86	447.01	445.31	445.5002	19230761.0
2021-09-10 16:00:00	SPY	ETF	445.52	446.08	445.37	445.94	5360092.0
2021-09-10 16:30:00	SPY	ETF	445.96	446.03	445.44	445.73	239227.0
2021-09-10 17:00:00	SPY	ETF	445.94	445.94	445.44	445.5	100373.0
2021-09-10 17:30:00	SPY	ETF	445.49	445.6	445.44	445.48	86190.0
2021-09-10 18:00:00	SPY	ETF	445.49	445.5	445.3	445.3	42543.0
2021-09-10 18:30:00	SPY	ETF	445.44	445.44	445.26	445.29	12061.0
2021-09-10 19:00:00	SPY	ETF	445.29	445.45	445.25	445.45	21258.0
2021-09-10 19:30:00	SPY	ETF	445.44	445.55	445.23	445.3399	22374.0
2021-09-10 04:00:00	QQQ	ETF	380.0	380.75	380.0	380.73	22710.0
2021-09-10 04:30:00	QQQ	ETF	380.81	380.89	380.73	380.74	12232.0
2021-09-10 05:00:00	QQQ	ETF	380.78	380.78	380.7	380.72	5326.0
2021-09-10 05:30:00	QQQ	ETF	380.68	380.68	380.56	380.56	8401.0
2021-09-10 06:00:00	QQQ	ETF	380.55	380.72	380.55	380.67	4701.0
2021-09-10 06:30:00	QQQ	ETF	380.64	380.88	380.56	380.86	49920.0
2021-09-10 07:00:00	QQQ	ETF	380.86	381.01	380.83	380.93	49845.0
2021-09-10 07:30:00	QQQ	ETF	380.92	381.09	380.92	381.0	59444.0
2021-09-10 08:00:00	QQQ	ETF	380.8299	381.23	380.15	381.04	128067.0
2021-09-10 08:30:00	QQQ	ETF	381.06	381.1	380.88	380.92	92964.0
2021-09-10 09:00:00	QQQ	ETF	380.93	381.31	380.855	381.27	105546.0
2021-09-10 09:30:00	QQQ	ETF	381.23	381.97	381.23	381.67	3020192.0
2021-09-10 10:00:00	QQQ	ETF	381.68	381.71	380.34	380.54	2245385.0
2021-09-10 10:30:00	QQQ	ETF	380.54	380.55	379.33	380.19	3364866.0
2021-09-10 11:00:00	QQQ	ETF	380.19	380.29	378.94	378.94	3331004.0
2021-09-10 11:30:00	QQQ	ETF	378.93	379.46	378.57	378.939	3509828.0
2021-09-10 12:00:00	QQQ	ETF	378.97	379.98	378.8	379.85	1365063.0
2021-09-10 12:30:00	QQQ	ETF	379.85	380.34	379.85	380.07	735404.0

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

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