PREVIEW / etf_30min / 2021-03-04

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-04.parquet
  size:    664 KB
  rows:    25,830

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-03-04 04:00:00	SPY	ETF	380.79	381.16	379.69	379.74	39648.0
2021-03-04 04:30:00	SPY	ETF	379.82	380.03	379.19	379.86	59443.0
2021-03-04 05:00:00	SPY	ETF	379.83	380.01	378.84	378.96	15038.0
2021-03-04 05:30:00	SPY	ETF	379.08	379.61	378.8	379.6	70043.0
2021-03-04 06:00:00	SPY	ETF	379.32	379.62	378.82	379.0	33619.0
2021-03-04 06:30:00	SPY	ETF	378.85	380.26	378.85	380.16	202970.0
2021-03-04 07:00:00	SPY	ETF	380.21	380.91	380.1	380.42	179210.0
2021-03-04 07:30:00	SPY	ETF	380.57	380.9	380.04	380.87	96467.0
2021-03-04 08:00:00	SPY	ETF	380.8	381.51	378.8896	381.09	327762.0
2021-03-04 08:30:00	SPY	ETF	381.12	381.96	380.94	381.4	301383.0
2021-03-04 09:00:00	SPY	ETF	381.45	381.6	380.85	381.2	509793.0
2021-03-04 09:30:00	SPY	ETF	381.22	383.375	380.15	380.89	13960751.0
2021-03-04 10:00:00	SPY	ETF	380.87	381.17	378.579	380.28	14029916.0
2021-03-04 10:30:00	SPY	ETF	380.3	382.43	380.03	381.85	9109745.0
2021-03-04 11:00:00	SPY	ETF	381.85	382.84	381.23	382.03	7544813.0
2021-03-04 11:30:00	SPY	ETF	382.03	383.67	381.81	382.96	4465192.0
2021-03-04 12:00:00	SPY	ETF	382.97	384.0	379.57	380.52	10267350.0
2021-03-04 12:30:00	SPY	ETF	380.48	380.81	376.36	377.0169	12540704.0
2021-03-04 13:00:00	SPY	ETF	377.01	377.91	375.04	376.8	10750626.0
2021-03-04 13:30:00	SPY	ETF	376.78	376.81	371.88	371.94	11148585.0
2021-03-04 14:00:00	SPY	ETF	371.93	376.25	371.9	376.09	12539793.0
2021-03-04 14:30:00	SPY	ETF	376.11	377.49	374.44	377.23	9327889.0
2021-03-04 15:00:00	SPY	ETF	377.2201	377.49	374.36	375.875	9877487.0
2021-03-04 15:30:00	SPY	ETF	375.87	377.2	375.28	376.73	19963695.0
2021-03-04 16:00:00	SPY	ETF	376.73	377.24	376.4083	376.95	5834984.0
2021-03-04 16:30:00	SPY	ETF	376.95	377.15	375.7	376.45	309375.0
2021-03-04 17:00:00	SPY	ETF	376.46	376.58	376.4	376.55	57605.0
2021-03-04 17:30:00	SPY	ETF	376.55	376.7	376.07	376.3	162504.0
2021-03-04 18:00:00	SPY	ETF	376.3	376.88	375.86	376.12	137334.0
2021-03-04 18:30:00	SPY	ETF	376.7	376.7	375.59	375.59	56419.0
2021-03-04 19:00:00	SPY	ETF	375.72	375.79	374.5	374.72	152076.0
2021-03-04 19:30:00	SPY	ETF	374.72	374.74	373.95	373.95	251172.0
2021-03-04 04:00:00	QQQ	ETF	308.45	309.17	307.13	307.24	64046.0
2021-03-04 04:30:00	QQQ	ETF	307.34	307.93	306.89	307.67	52202.0
2021-03-04 05:00:00	QQQ	ETF	307.55	308.06	306.95	307.06	35784.0
2021-03-04 05:30:00	QQQ	ETF	306.98	307.5	306.37	306.99	61942.0
2021-03-04 06:00:00	QQQ	ETF	306.88	307.29	306.18	306.64	56249.0
2021-03-04 06:30:00	QQQ	ETF	306.62	308.37	306.62	308.12	257790.0
2021-03-04 07:00:00	QQQ	ETF	308.1	308.89	307.79	308.35	330484.0
2021-03-04 07:30:00	QQQ	ETF	308.37	308.76	307.85	308.611	186693.0
2021-03-04 08:00:00	QQQ	ETF	306.65	309.76	306.4296	309.18	300134.0
2021-03-04 08:30:00	QQQ	ETF	309.16	309.85	308.75	309.08	468607.0
2021-03-04 09:00:00	QQQ	ETF	309.12	309.27	308.15	308.81	456033.0
2021-03-04 09:30:00	QQQ	ETF	308.78	311.28	306.49	307.01	11810904.0
2021-03-04 10:00:00	QQQ	ETF	306.99	307.65	305.025	307.16	9909284.0
2021-03-04 10:30:00	QQQ	ETF	307.17	311.06	306.86	310.245	8722420.0
2021-03-04 11:00:00	QQQ	ETF	310.24	311.32	309.1001	309.82	5463538.0
2021-03-04 11:30:00	QQQ	ETF	309.8001	312.04	309.62	310.66	5368286.0
2021-03-04 12:00:00	QQQ	ETF	310.68	311.7	306.31	307.39	10675285.0
2021-03-04 12:30:00	QQQ	ETF	307.39	307.89	303.48	304.45	12222058.0

> showing 50 of 25,830 rows — these rows as CSV

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