PREVIEW / etf_30min / 2021-10-12

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-12.parquet
  size:    608 KB
  rows:    23,041

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-10-12 04:00:00	SPY	ETF	433.47	433.51	432.75	433.33	22644.0
2021-10-12 04:30:00	SPY	ETF	433.54	434.37	433.44	434.31	19615.0
2021-10-12 05:00:00	SPY	ETF	434.38	435.12	434.36	434.96	32566.0
2021-10-12 05:30:00	SPY	ETF	435.0	435.05	434.7	434.84	20790.0
2021-10-12 06:00:00	SPY	ETF	434.84	434.97	434.27	434.29	58943.0
2021-10-12 06:30:00	SPY	ETF	434.41	435.38	434.37	435.35	202750.0
2021-10-12 07:00:00	SPY	ETF	435.3	435.54	434.94	435.44	293407.0
2021-10-12 07:30:00	SPY	ETF	435.38	435.5	434.82	434.82	149759.0
2021-10-12 08:00:00	SPY	ETF	435.1001	436.09	431.99	436.0	480733.0
2021-10-12 08:30:00	SPY	ETF	436.0	436.0	434.98	435.27	181966.0
2021-10-12 09:00:00	SPY	ETF	435.29	435.91	435.22	435.69	273208.0
2021-10-12 09:30:00	SPY	ETF	435.67	436.1	433.5	434.11	9510587.0
2021-10-12 10:00:00	SPY	ETF	434.12	435.26	433.5704	434.68	4853166.0
2021-10-12 10:30:00	SPY	ETF	434.6799	435.0	433.98	434.08	3274064.0
2021-10-12 11:00:00	SPY	ETF	434.1	435.5	434.07	434.795	3198892.0
2021-10-12 11:30:00	SPY	ETF	434.8	435.37	434.25	435.33	2211049.0
2021-10-12 12:00:00	SPY	ETF	435.35	436.07	435.06	435.163	2386180.0
2021-10-12 12:30:00	SPY	ETF	435.17	435.21	433.98	434.175	2647654.0
2021-10-12 13:00:00	SPY	ETF	434.179	434.43	433.74	434.26	1735207.0
2021-10-12 13:30:00	SPY	ETF	434.24	434.8899	434.07	434.2001	2421194.0
2021-10-12 14:00:00	SPY	ETF	434.2	435.57	434.06	434.93	2726292.0
2021-10-12 14:30:00	SPY	ETF	434.95	435.0915	434.22	434.29	2115523.0
2021-10-12 15:00:00	SPY	ETF	434.3	434.36	433.7	434.17	3531296.0
2021-10-12 15:30:00	SPY	ETF	434.16	434.35	432.78	433.63	9625843.0
2021-10-12 16:00:00	SPY	ETF	433.63	433.6892	432.27	432.35	2451903.0
2021-10-12 16:30:00	SPY	ETF	432.34	433.62	432.25	432.52	488191.0
2021-10-12 17:00:00	SPY	ETF	432.58	432.58	432.41	432.52	24242.0
2021-10-12 17:30:00	SPY	ETF	432.54	432.54	432.0	432.36	134263.0
2021-10-12 18:00:00	SPY	ETF	432.34	432.7	432.34	432.57	113364.0
2021-10-12 18:30:00	SPY	ETF	433.62	433.62	432.35	432.5799	15364.0
2021-10-12 19:00:00	SPY	ETF	432.6	432.77	432.48	432.68	27354.0
2021-10-12 19:30:00	SPY	ETF	432.67	432.7	432.3	432.4	22221.0
2021-10-12 04:00:00	QQQ	ETF	357.38	357.81	357.09	357.59	36827.0
2021-10-12 04:30:00	QQQ	ETF	357.74	358.47	357.6	358.33	34556.0
2021-10-12 05:00:00	QQQ	ETF	358.45	359.16	358.43	359.08	95644.0
2021-10-12 05:30:00	QQQ	ETF	359.05	359.16	358.9	359.01	33513.0
2021-10-12 06:00:00	QQQ	ETF	359.07	359.25	358.73	358.73	13096.0
2021-10-12 06:30:00	QQQ	ETF	358.82	359.6	358.82	359.51	119633.0
2021-10-12 07:00:00	QQQ	ETF	359.53	359.8	359.19	359.64	135157.0
2021-10-12 07:30:00	QQQ	ETF	359.63	359.7	359.16	359.17	77933.0
2021-10-12 08:00:00	QQQ	ETF	359.16	360.41	355.9	360.37	353968.0
2021-10-12 08:30:00	QQQ	ETF	360.31	360.3196	359.24	359.51	210047.0
2021-10-12 09:00:00	QQQ	ETF	359.54	360.29	359.49	359.86	199826.0
2021-10-12 09:30:00	QQQ	ETF	359.88	360.33	357.37	357.455	5916746.0
2021-10-12 10:00:00	QQQ	ETF	357.45	358.87	357.22	358.1791	3719219.0
2021-10-12 10:30:00	QQQ	ETF	358.19	358.19	356.7704	356.9	2964181.0
2021-10-12 11:00:00	QQQ	ETF	356.93	358.4969	356.92	357.75	2025825.0
2021-10-12 11:30:00	QQQ	ETF	357.76	358.5	357.28	358.5	1689013.0
2021-10-12 12:00:00	QQQ	ETF	358.53	359.18	358.26	358.3801	1721700.0
2021-10-12 12:30:00	QQQ	ETF	358.38	358.4544	357.25	357.4	1563670.0

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

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