PREVIEW / etf_30min / 2021-07-02

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-02.parquet
  size:    595 KB
  rows:    22,653

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-07-02 04:00:00	SPY	ETF	430.54	431.0	430.54	430.58	1500.0
2021-07-02 04:30:00	SPY	ETF	430.57	430.58	430.38	430.47	1467.0
2021-07-02 05:00:00	SPY	ETF	430.53	430.7	430.53	430.56	4800.0
2021-07-02 05:30:00	SPY	ETF	430.59	430.78	430.49	430.67	3100.0
2021-07-02 06:00:00	SPY	ETF	430.78	430.87	430.66	430.66	7009.0
2021-07-02 06:30:00	SPY	ETF	430.66	430.74	430.55	430.72	10994.0
2021-07-02 07:00:00	SPY	ETF	430.8	430.98	430.79	430.95	23300.0
2021-07-02 07:30:00	SPY	ETF	430.96	431.02	430.91	430.94	56467.0
2021-07-02 08:00:00	SPY	ETF	430.8801	431.1	430.5	430.92	283153.0
2021-07-02 08:30:00	SPY	ETF	430.87	431.88	430.75	431.66	497063.0
2021-07-02 09:00:00	SPY	ETF	431.66	431.99	431.58	431.67	197001.0
2021-07-02 09:30:00	SPY	ETF	431.67	431.92	431.33	431.81	4590601.0
2021-07-02 10:00:00	SPY	ETF	431.815	431.97	431.61	431.88	2478815.0
2021-07-02 10:30:00	SPY	ETF	431.88	431.959	431.7399	431.9	1877359.0
2021-07-02 11:00:00	SPY	ETF	431.89	432.13	431.84	432.12	1545393.0
2021-07-02 11:30:00	SPY	ETF	432.11	432.65	432.04	432.45	2562251.0
2021-07-02 12:00:00	SPY	ETF	432.45	432.55	432.34	432.5	1098011.0
2021-07-02 12:30:00	SPY	ETF	432.49	433.3	432.46	433.27	2329495.0
2021-07-02 13:00:00	SPY	ETF	433.2601	433.49	433.06	433.1599	2540724.0
2021-07-02 13:30:00	SPY	ETF	433.16	433.39	433.03	433.3101	1636869.0
2021-07-02 14:00:00	SPY	ETF	433.3125	433.56	433.2699	433.5561	1660141.0
2021-07-02 14:30:00	SPY	ETF	433.56	433.57	433.18	433.2675	1914548.0
2021-07-02 15:00:00	SPY	ETF	433.26	433.67	433.19	433.6	3369019.0
2021-07-02 15:30:00	SPY	ETF	433.605	434.1	433.44	433.75	11693867.0
2021-07-02 16:00:00	SPY	ETF	433.73	433.7501	433.37	433.44	3721250.0
2021-07-02 16:30:00	SPY	ETF	433.43	433.72	433.21	433.2701	401762.0
2021-07-02 17:00:00	SPY	ETF	433.28	433.45	433.24	433.365	28746.0
2021-07-02 17:30:00	SPY	ETF	433.385	433.5	433.35	433.35	10707.0
2021-07-02 18:00:00	SPY	ETF	433.36	433.36	433.36	433.36	605.0
2021-07-02 18:30:00	SPY	ETF	433.33	433.4299	433.33	433.34	928.0
2021-07-02 19:00:00	SPY	ETF	433.34	433.4	433.34	433.4	760.0
2021-07-02 19:30:00	SPY	ETF	433.37	433.47	433.28	433.28	12438.0
2021-07-02 04:00:00	QQQ	ETF	355.15	355.3	354.8	354.95	10498.0
2021-07-02 04:30:00	QQQ	ETF	354.94	354.94	354.79	354.94	5724.0
2021-07-02 05:00:00	QQQ	ETF	354.9	355.13	354.85	354.96	12008.0
2021-07-02 05:30:00	QQQ	ETF	354.99	355.21	354.93	355.08	8912.0
2021-07-02 06:00:00	QQQ	ETF	355.16	355.23	355.04	355.13	10111.0
2021-07-02 06:30:00	QQQ	ETF	355.1	355.34	355.1	355.24	13329.0
2021-07-02 07:00:00	QQQ	ETF	355.2	355.4	355.2	355.39	20567.0
2021-07-02 07:30:00	QQQ	ETF	355.43	355.83	355.4	355.72	68634.0
2021-07-02 08:00:00	QQQ	ETF	355.74	356.13	355.08	355.93	183789.0
2021-07-02 08:30:00	QQQ	ETF	355.85	356.72	355.25	356.44	545718.0
2021-07-02 09:00:00	QQQ	ETF	356.46	357.08	356.43	356.57	299230.0
2021-07-02 09:30:00	QQQ	ETF	356.54	357.415	356.28	357.1182	3930557.0
2021-07-02 10:00:00	QQQ	ETF	357.135	357.27	356.86	356.9899	1660834.0
2021-07-02 10:30:00	QQQ	ETF	356.98	356.99	356.44	356.59	2038746.0
2021-07-02 11:00:00	QQQ	ETF	356.58	357.01	356.52	356.71	1017748.0
2021-07-02 11:30:00	QQQ	ETF	356.71	357.71	356.65	357.47	1495884.0
2021-07-02 12:00:00	QQQ	ETF	357.48	357.62	357.175	357.51	915272.0
2021-07-02 12:30:00	QQQ	ETF	357.505	357.9902	357.48	357.9899	1106637.0

> showing 50 of 22,653 rows — these rows as CSV

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