PREVIEW / etf_30min / 2021-09-14

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-14.parquet
  size:    614 KB
  rows:    23,250

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-14 04:00:00	SPY	ETF	446.84	447.0	446.35	446.99	40835.0
2021-09-14 04:30:00	SPY	ETF	446.98	447.35	446.98	447.12	3784.0
2021-09-14 05:00:00	SPY	ETF	447.25	447.36	447.15	447.17	2400.0
2021-09-14 05:30:00	SPY	ETF	447.12	447.16	446.75	446.77	5876.0
2021-09-14 06:00:00	SPY	ETF	446.69	447.15	446.65	447.11	13746.0
2021-09-14 06:30:00	SPY	ETF	447.15	447.16	446.76	446.76	55511.0
2021-09-14 07:00:00	SPY	ETF	446.95	446.97	446.68	446.68	138017.0
2021-09-14 07:30:00	SPY	ETF	446.65	446.87	445.78	446.05	200346.0
2021-09-14 08:00:00	SPY	ETF	446.94	447.23	445.78	446.39	219859.0
2021-09-14 08:30:00	SPY	ETF	446.3	448.59	446.3	447.85	1019331.0
2021-09-14 09:00:00	SPY	ETF	447.89	448.26	447.86	448.12	186814.0
2021-09-14 09:30:00	SPY	ETF	448.12	448.34	446.01	446.0875	5609315.0
2021-09-14 10:00:00	SPY	ETF	446.08	446.13	445.13	445.845	5747590.0
2021-09-14 10:30:00	SPY	ETF	445.835	445.91	444.6	444.97	4367263.0
2021-09-14 11:00:00	SPY	ETF	444.97	445.75	444.95	445.7	2727915.0
2021-09-14 11:30:00	SPY	ETF	445.7	446.035	445.49	446.02	2797539.0
2021-09-14 12:00:00	SPY	ETF	446.01	446.29	445.79	445.88	1548293.0
2021-09-14 12:30:00	SPY	ETF	445.875	445.88	444.7	444.8899	2748208.0
2021-09-14 13:00:00	SPY	ETF	444.86	445.15	444.07	444.9	2995540.0
2021-09-14 13:30:00	SPY	ETF	444.91	445.22	444.42	445.025	1683084.0
2021-09-14 14:00:00	SPY	ETF	445.03	445.1199	443.81	444.0	3765270.0
2021-09-14 14:30:00	SPY	ETF	444.0	444.17	443.22	444.105	4375125.0
2021-09-14 15:00:00	SPY	ETF	444.11	444.29	443.39	443.449	4448862.0
2021-09-14 15:30:00	SPY	ETF	443.44	444.255	443.2522	444.18	12909268.0
2021-09-14 16:00:00	SPY	ETF	444.18	444.5	443.875	444.4	3960528.0
2021-09-14 16:30:00	SPY	ETF	444.4	444.41	444.17	444.36	103898.0
2021-09-14 17:00:00	SPY	ETF	444.37	444.43	444.21	444.42	9885.0
2021-09-14 17:30:00	SPY	ETF	444.35	444.35	444.17	444.24	174304.0
2021-09-14 18:00:00	SPY	ETF	444.28	444.58	444.27	444.43	105876.0
2021-09-14 18:30:00	SPY	ETF	444.42	444.48	444.17	444.48	174850.0
2021-09-14 19:00:00	SPY	ETF	444.48	444.48	444.38	444.43	9270.0
2021-09-14 19:30:00	SPY	ETF	444.45	444.73	444.429	444.72	53577.0
2021-09-14 04:00:00	QQQ	ETF	376.0	376.33	375.89	376.33	28958.0
2021-09-14 04:30:00	QQQ	ETF	376.36	376.63	376.36	376.39	12247.0
2021-09-14 05:00:00	QQQ	ETF	376.47	376.59	376.36	376.39	6490.0
2021-09-14 05:30:00	QQQ	ETF	376.39	376.4	376.17	376.17	8533.0
2021-09-14 06:00:00	QQQ	ETF	376.11	376.49	376.01	376.49	9076.0
2021-09-14 06:30:00	QQQ	ETF	376.46	376.5	376.22	376.33	16326.0
2021-09-14 07:00:00	QQQ	ETF	376.32	376.4	376.14	376.15	26229.0
2021-09-14 07:30:00	QQQ	ETF	376.14	376.38	375.48	375.66	125930.0
2021-09-14 08:00:00	QQQ	ETF	376.2299	376.612	375.49	375.93	136495.0
2021-09-14 08:30:00	QQQ	ETF	376.14	377.95	376.14	377.57	683448.0
2021-09-14 09:00:00	QQQ	ETF	377.63	377.89	377.43	377.83	144598.0
2021-09-14 09:30:00	QQQ	ETF	377.84	378.61	376.27	376.36	4759775.0
2021-09-14 10:00:00	QQQ	ETF	376.38	376.7599	375.71	376.5501	3099803.0
2021-09-14 10:30:00	QQQ	ETF	376.55	376.6594	375.265	375.8301	2993432.0
2021-09-14 11:00:00	QQQ	ETF	375.83	376.74	375.83	376.68	2049084.0
2021-09-14 11:30:00	QQQ	ETF	376.67	377.47	376.54	377.45	1671146.0
2021-09-14 12:00:00	QQQ	ETF	377.45	377.75	376.84	376.93	1224477.0
2021-09-14 12:30:00	QQQ	ETF	376.921	376.93	375.98	376.155	1566901.0

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

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