PREVIEW / etf_30min / 2021-04-28

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-28.parquet
  size:    604 KB
  rows:    23,119

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-04-28 04:00:00	SPY	ETF	417.52	417.58	417.42	417.52	18571.0
2021-04-28 04:30:00	SPY	ETF	417.69	417.87	417.69	417.87	900.0
2021-04-28 05:00:00	SPY	ETF	417.69	417.87	417.65	417.67	3643.0
2021-04-28 05:30:00	SPY	ETF	417.65	417.93	417.65	417.79	4940.0
2021-04-28 06:00:00	SPY	ETF	417.78	417.91	417.7	417.84	12800.0
2021-04-28 06:30:00	SPY	ETF	417.87	417.98	417.7	417.9	14099.0
2021-04-28 07:00:00	SPY	ETF	417.87	418.08	417.821	417.93	44558.0
2021-04-28 07:30:00	SPY	ETF	417.88	417.9	417.19	417.46	105556.0
2021-04-28 08:00:00	SPY	ETF	417.9101	418.07	417.36	417.6	36133.0
2021-04-28 08:30:00	SPY	ETF	417.54	417.7	417.49	417.68	37889.0
2021-04-28 09:00:00	SPY	ETF	417.71	417.83	417.65	417.83	111909.0
2021-04-28 09:30:00	SPY	ETF	417.81	418.41	417.32	418.38	4299654.0
2021-04-28 10:00:00	SPY	ETF	418.39	418.45	418.05	418.1555	2442660.0
2021-04-28 10:30:00	SPY	ETF	418.16	418.23	417.74	418.0319	2322172.0
2021-04-28 11:00:00	SPY	ETF	418.035	418.105	417.71	417.9182	1695917.0
2021-04-28 11:30:00	SPY	ETF	417.91	417.93	417.23	417.2919	2125417.0
2021-04-28 12:00:00	SPY	ETF	417.3	417.68	417.12	417.615	1331420.0
2021-04-28 12:30:00	SPY	ETF	417.6155	417.89	417.5201	417.809	994072.0
2021-04-28 13:00:00	SPY	ETF	417.81	417.84	417.66	417.8	711332.0
2021-04-28 13:30:00	SPY	ETF	417.8	417.82	417.23	417.31	1620340.0
2021-04-28 14:00:00	SPY	ETF	417.31	418.22	416.9	417.68	4081007.0
2021-04-28 14:30:00	SPY	ETF	417.6714	419.01	417.21	418.33	5036755.0
2021-04-28 15:00:00	SPY	ETF	418.33	418.54	417.11	417.96	3917844.0
2021-04-28 15:30:00	SPY	ETF	417.97	418.18	417.02	417.35	8083517.0
2021-04-28 16:00:00	SPY	ETF	417.35	417.89	416.97	417.4	2119093.0
2021-04-28 16:30:00	SPY	ETF	417.47	418.39	417.45	418.08	535574.0
2021-04-28 17:00:00	SPY	ETF	418.0	418.0	417.76	417.81	128487.0
2021-04-28 17:30:00	SPY	ETF	417.87	418.0	417.8	418.0	44477.0
2021-04-28 18:00:00	SPY	ETF	418.0	418.26	417.92	418.23	97453.0
2021-04-28 18:30:00	SPY	ETF	417.4	418.23	417.4	418.22	26438.0
2021-04-28 19:00:00	SPY	ETF	418.22	418.3	418.16	418.16	12604.0
2021-04-28 19:30:00	SPY	ETF	418.2	418.5	418.16	418.47	26043.0
2021-04-28 04:00:00	QQQ	ETF	339.79	339.8	339.38	339.64	16591.0
2021-04-28 04:30:00	QQQ	ETF	339.64	339.9	339.64	339.83	3294.0
2021-04-28 05:00:00	QQQ	ETF	339.86	339.86	339.37	339.5	24373.0
2021-04-28 05:30:00	QQQ	ETF	339.41	339.66	339.36	339.51	15647.0
2021-04-28 06:00:00	QQQ	ETF	339.5	339.84	339.5	339.68	17977.0
2021-04-28 06:30:00	QQQ	ETF	339.74	339.81	339.67	339.79	20884.0
2021-04-28 07:00:00	QQQ	ETF	339.77	340.09	339.69	339.97	86534.0
2021-04-28 07:30:00	QQQ	ETF	339.9	339.9	339.3	339.49	213046.0
2021-04-28 08:00:00	QQQ	ETF	339.85	340.52	339.37	339.63	89281.0
2021-04-28 08:30:00	QQQ	ETF	339.59	339.71	339.43	339.59	123642.0
2021-04-28 09:00:00	QQQ	ETF	339.58	339.85	339.49	339.85	88806.0
2021-04-28 09:30:00	QQQ	ETF	339.81	340.64	338.51	340.63	4327164.0
2021-04-28 10:00:00	QQQ	ETF	340.64	340.81	340.0	340.04	2082756.0
2021-04-28 10:30:00	QQQ	ETF	340.04	340.06	338.87	339.4213	2167963.0
2021-04-28 11:00:00	QQQ	ETF	339.43	339.599	338.82	339.23	1153150.0
2021-04-28 11:30:00	QQQ	ETF	339.23	339.61	338.56	338.6225	1393132.0
2021-04-28 12:00:00	QQQ	ETF	338.62	339.15	338.3301	339.05	902993.0
2021-04-28 12:30:00	QQQ	ETF	339.05	339.45	338.93	339.3072	795727.0

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

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