PREVIEW / etf_30min / 2021-07-28

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-28.parquet
  size:    612 KB
  rows:    23,126

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-28 04:00:00	SPY	ETF	439.0	439.42	438.83	439.35	3757.0
2021-07-28 04:30:00	SPY	ETF	439.47	439.95	439.47	439.91	5849.0
2021-07-28 05:00:00	SPY	ETF	439.9	439.9	439.73	439.75	7927.0
2021-07-28 05:30:00	SPY	ETF	439.82	439.85	439.56	439.79	4489.0
2021-07-28 06:00:00	SPY	ETF	439.41	439.41	438.96	439.03	14509.0
2021-07-28 06:30:00	SPY	ETF	439.07	439.3	438.84	439.25	19159.0
2021-07-28 07:00:00	SPY	ETF	439.18	439.32	439.0	439.27	26550.0
2021-07-28 07:30:00	SPY	ETF	439.28	439.56	438.89	439.13	90898.0
2021-07-28 08:00:00	SPY	ETF	439.2599	439.84	438.42	439.47	210151.0
2021-07-28 08:30:00	SPY	ETF	439.47	439.62	439.32	439.38	144510.0
2021-07-28 09:00:00	SPY	ETF	439.42	439.82	439.42	439.7	339734.0
2021-07-28 09:30:00	SPY	ETF	439.68	439.8301	438.11	438.6	4630040.0
2021-07-28 10:00:00	SPY	ETF	438.6	439.33	438.16	439.17	3001989.0
2021-07-28 10:30:00	SPY	ETF	439.16	439.58	438.35	439.31	3209694.0
2021-07-28 11:00:00	SPY	ETF	439.31	439.5	438.94	438.965	2206636.0
2021-07-28 11:30:00	SPY	ETF	438.96	439.54	438.885	439.2699	1868552.0
2021-07-28 12:00:00	SPY	ETF	439.265	439.34	438.8	438.805	2595808.0
2021-07-28 12:30:00	SPY	ETF	438.805	439.03	438.41	438.62	1313591.0
2021-07-28 13:00:00	SPY	ETF	438.63	438.72	438.04	438.14	1331602.0
2021-07-28 13:30:00	SPY	ETF	438.147	438.48	437.91	438.2	2036052.0
2021-07-28 14:00:00	SPY	ETF	438.2	439.32	437.31	439.05	4765339.0
2021-07-28 14:30:00	SPY	ETF	439.06	440.3	438.46	439.68	4056475.0
2021-07-28 15:00:00	SPY	ETF	439.7	439.9609	439.08	439.52	3653873.0
2021-07-28 15:30:00	SPY	ETF	439.52	439.86	438.73	438.79	5088929.0
2021-07-28 16:00:00	SPY	ETF	438.7999	438.9	438.5	438.66	1956789.0
2021-07-28 16:30:00	SPY	ETF	438.64	438.76	438.6	438.71	89105.0
2021-07-28 17:00:00	SPY	ETF	438.74	438.75	438.65	438.69	22744.0
2021-07-28 17:30:00	SPY	ETF	438.67	438.76	438.66	438.75	14057.0
2021-07-28 18:00:00	SPY	ETF	438.8	438.94	438.73	438.93	29674.0
2021-07-28 18:30:00	SPY	ETF	438.83	438.9	438.7	438.89	16415.0
2021-07-28 19:00:00	SPY	ETF	438.76	438.8	438.6	438.8	14708.0
2021-07-28 19:30:00	SPY	ETF	438.76	438.95	438.76	438.93	12232.0
2021-07-28 04:00:00	QQQ	ETF	364.0	365.15	364.0	365.15	45223.0
2021-07-28 04:30:00	QQQ	ETF	365.2	365.58	365.2	365.56	19989.0
2021-07-28 05:00:00	QQQ	ETF	365.61	365.62	365.26	365.45	89184.0
2021-07-28 05:30:00	QQQ	ETF	365.45	365.46	365.22	365.3	7096.0
2021-07-28 06:00:00	QQQ	ETF	365.36	365.36	364.57	364.65	40387.0
2021-07-28 06:30:00	QQQ	ETF	364.79	365.07	364.73	365.07	18021.0
2021-07-28 07:00:00	QQQ	ETF	364.99	365.53	364.82	365.52	102304.0
2021-07-28 07:30:00	QQQ	ETF	365.46	365.64	365.16	365.38	83423.0
2021-07-28 08:00:00	QQQ	ETF	365.2496	365.88	363.41	365.87	126301.0
2021-07-28 08:30:00	QQQ	ETF	365.92	366.12	365.73	365.73	185474.0
2021-07-28 09:00:00	QQQ	ETF	365.74	366.01	365.58	365.62	131745.0
2021-07-28 09:30:00	QQQ	ETF	365.6	366.2	363.24	365.13	6126876.0
2021-07-28 10:00:00	QQQ	ETF	365.12	367.1987	365.01	366.92	3618405.0
2021-07-28 10:30:00	QQQ	ETF	366.92	367.45	365.59	366.57	3050178.0
2021-07-28 11:00:00	QQQ	ETF	366.56	367.12	366.005	366.01	1947891.0
2021-07-28 11:30:00	QQQ	ETF	366.0	366.42	365.2932	365.8975	1738917.0
2021-07-28 12:00:00	QQQ	ETF	365.8912	366.36	365.71	366.08	1325039.0
2021-07-28 12:30:00	QQQ	ETF	366.11	366.34	365.36	365.57	927699.0

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

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