PREVIEW / etf_30min / 2022-08-02

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-02.parquet
  size:    658 KB
  rows:    26,244

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
2022-08-02 04:00:00	SPY	ETF	408.68	409.49	408.14	408.55	13447.0
2022-08-02 04:30:00	SPY	ETF	408.66	408.66	407.83	408.14	15793.0
2022-08-02 05:00:00	SPY	ETF	408.16	408.39	408.02	408.2	7200.0
2022-08-02 05:30:00	SPY	ETF	408.24	408.24	407.6	407.6	28106.0
2022-08-02 06:00:00	SPY	ETF	407.76	407.82	407.18	407.39	55381.0
2022-08-02 06:30:00	SPY	ETF	407.31	407.69	407.17	407.69	18602.0
2022-08-02 07:00:00	SPY	ETF	407.68	408.44	407.6	408.34	64086.0
2022-08-02 07:30:00	SPY	ETF	408.32	408.6	408.2	408.26	80597.0
2022-08-02 08:00:00	SPY	ETF	408.13	409.07	407.4204	408.14	359936.0
2022-08-02 08:30:00	SPY	ETF	408.18	408.39	407.77	408.27	188738.0
2022-08-02 09:00:00	SPY	ETF	408.29	409.15	408.16	409.11	257964.0
2022-08-02 09:30:00	SPY	ETF	409.12	409.77	407.6787	408.6	5528335.0
2022-08-02 10:00:00	SPY	ETF	408.5901	409.14	406.82	409.13	4078980.0
2022-08-02 10:30:00	SPY	ETF	409.14	411.4	408.75	410.48	4037251.0
2022-08-02 11:00:00	SPY	ETF	410.48	410.7099	409.56	410.45	3055441.0
2022-08-02 11:30:00	SPY	ETF	410.46	411.08	409.47	410.6995	2044443.0
2022-08-02 12:00:00	SPY	ETF	410.7	412.54	410.54	412.52	2631003.0
2022-08-02 12:30:00	SPY	ETF	412.53	413.0	412.215	412.63	2149194.0
2022-08-02 13:00:00	SPY	ETF	412.625	412.66	410.57	410.73	2864813.0
2022-08-02 13:30:00	SPY	ETF	410.72	410.73	408.85	409.49	3706263.0
2022-08-02 14:00:00	SPY	ETF	409.5	410.46	409.1201	410.28	2690512.0
2022-08-02 14:30:00	SPY	ETF	410.309	410.82	409.21	409.48	3274174.0
2022-08-02 15:00:00	SPY	ETF	409.49	409.85	408.41	409.39	3388147.0
2022-08-02 15:30:00	SPY	ETF	409.3733	409.97	407.93	408.12	6134559.0
2022-08-02 16:00:00	SPY	ETF	408.11	408.29	407.68	407.9	2483808.0
2022-08-02 16:30:00	SPY	ETF	407.79	408.39	407.76	408.35	243306.0
2022-08-02 17:00:00	SPY	ETF	408.22	408.49	408.22	408.36	26850.0
2022-08-02 17:30:00	SPY	ETF	408.43	408.5	408.26	408.39	34592.0
2022-08-02 18:00:00	SPY	ETF	408.48	408.9	408.39	408.46	55544.0
2022-08-02 18:30:00	SPY	ETF	408.57	408.96	408.57	408.68	23805.0
2022-08-02 19:00:00	SPY	ETF	408.6	408.8	408.55	408.75	11801.0
2022-08-02 19:30:00	SPY	ETF	408.77	408.77	408.0	408.16	70980.0
2022-08-02 04:00:00	QQQ	ETF	314.64	314.64	312.76	313.27	61342.0
2022-08-02 04:30:00	QQQ	ETF	313.27	313.27	312.5	312.8	19970.0
2022-08-02 05:00:00	QQQ	ETF	312.79	313.0	312.7	312.7	9982.0
2022-08-02 05:30:00	QQQ	ETF	312.83	312.83	312.0	312.02	33536.0
2022-08-02 06:00:00	QQQ	ETF	312.0	312.39	311.71	312.01	45358.0
2022-08-02 06:30:00	QQQ	ETF	311.98	312.4	311.86	312.39	36085.0
2022-08-02 07:00:00	QQQ	ETF	312.4	313.3	312.4	313.06	166989.0
2022-08-02 07:30:00	QQQ	ETF	313.02	313.26	312.66	312.74	92091.0
2022-08-02 08:00:00	QQQ	ETF	312.8	315.506	311.8904	312.75	170261.0
2022-08-02 08:30:00	QQQ	ETF	312.75	312.97	312.09	312.57	198117.0
2022-08-02 09:00:00	QQQ	ETF	312.53	313.25	312.46	312.89	235747.0
2022-08-02 09:30:00	QQQ	ETF	312.92	315.15	312.61	314.09	5847903.0
2022-08-02 10:00:00	QQQ	ETF	314.09	314.12	311.8401	313.91	3166063.0
2022-08-02 10:30:00	QQQ	ETF	313.91	316.24	313.25	315.45	3497390.0
2022-08-02 11:00:00	QQQ	ETF	315.45	315.75	314.36	315.4	2005973.0
2022-08-02 11:30:00	QQQ	ETF	315.38	316.09	314.2916	315.74	1625427.0
2022-08-02 12:00:00	QQQ	ETF	315.745	318.13	315.57	318.02	2466520.0
2022-08-02 12:30:00	QQQ	ETF	318.02	318.545	317.68	317.99	1755900.0

> showing 50 of 26,244 rows — these rows as CSV

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