PREVIEW / etf_30min / 2021-12-10

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-10.parquet
  size:    625 KB
  rows:    24,060

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-12-10 04:00:00	SPY	ETF	467.57	467.69	467.23	467.31	10513.0
2021-12-10 04:30:00	SPY	ETF	467.34	467.64	467.31	467.64	10291.0
2021-12-10 05:00:00	SPY	ETF	467.68	467.69	467.48	467.54	10610.0
2021-12-10 05:30:00	SPY	ETF	467.57	467.72	467.55	467.7	7660.0
2021-12-10 06:00:00	SPY	ETF	467.72	468.22	467.7	468.22	30930.0
2021-12-10 06:30:00	SPY	ETF	468.23	468.5	468.04	468.35	28578.0
2021-12-10 07:00:00	SPY	ETF	468.33	468.38	467.82	468.12	54284.0
2021-12-10 07:30:00	SPY	ETF	468.12	468.15	467.7	467.83	71702.0
2021-12-10 08:00:00	SPY	ETF	468.17	468.5096	466.33	467.85	218100.0
2021-12-10 08:30:00	SPY	ETF	467.75	470.2	467.68	469.72	1289826.0
2021-12-10 09:00:00	SPY	ETF	469.77	469.88	469.2	469.25	350492.0
2021-12-10 09:30:00	SPY	ETF	469.23	470.08	468.15	468.39	7255597.0
2021-12-10 10:00:00	SPY	ETF	468.41	469.53	468.24	469.42	4246565.0
2021-12-10 10:30:00	SPY	ETF	469.43	469.555	467.36	468.01	3965864.0
2021-12-10 11:00:00	SPY	ETF	467.98	468.13	466.51	467.99	3794603.0
2021-12-10 11:30:00	SPY	ETF	468.0	468.94	467.55	468.71	2659686.0
2021-12-10 12:00:00	SPY	ETF	468.71	469.0	468.34	468.5762	2100953.0
2021-12-10 12:30:00	SPY	ETF	468.58	468.9	467.941	468.87	1526974.0
2021-12-10 13:00:00	SPY	ETF	468.87	469.41	468.67	469.23	2133204.0
2021-12-10 13:30:00	SPY	ETF	469.24	469.32	468.81	469.25	1551025.0
2021-12-10 14:00:00	SPY	ETF	469.24	469.47	469.0	469.42	2111301.0
2021-12-10 14:30:00	SPY	ETF	469.41	469.58	468.52	468.65	2379100.0
2021-12-10 15:00:00	SPY	ETF	468.65	469.58	468.38	469.45	3302008.0
2021-12-10 15:30:00	SPY	ETF	469.45	470.9	469.45	470.71	11768271.0
2021-12-10 16:00:00	SPY	ETF	470.7	470.86	470.45	470.67	3617097.0
2021-12-10 16:30:00	SPY	ETF	470.67	470.8	470.63	470.78	133772.0
2021-12-10 17:00:00	SPY	ETF	470.76	470.81	470.1	470.22	158932.0
2021-12-10 17:30:00	SPY	ETF	470.24	470.25	470.0	470.12	95936.0
2021-12-10 18:00:00	SPY	ETF	470.15	470.35	470.1	470.35	23724.0
2021-12-10 18:30:00	SPY	ETF	470.74	470.74	470.18	470.44	29443.0
2021-12-10 19:00:00	SPY	ETF	470.4	470.61	470.4	470.6	50339.0
2021-12-10 19:30:00	SPY	ETF	470.6	471.0	470.58	471.0	102062.0
2021-12-10 04:00:00	QQQ	ETF	394.97	394.97	394.33	394.55	10556.0
2021-12-10 04:30:00	QQQ	ETF	394.59	395.01	394.59	395.0	9838.0
2021-12-10 05:00:00	QQQ	ETF	395.06	395.06	394.63	394.78	3497.0
2021-12-10 05:30:00	QQQ	ETF	394.85	395.04	394.84	395.04	2815.0
2021-12-10 06:00:00	QQQ	ETF	394.97	395.4	394.96	395.4	7000.0
2021-12-10 06:30:00	QQQ	ETF	395.44	395.68	395.37	395.37	10707.0
2021-12-10 07:00:00	QQQ	ETF	395.42	395.43	394.85	394.96	44367.0
2021-12-10 07:30:00	QQQ	ETF	395.09	395.1	394.4	394.65	83483.0
2021-12-10 08:00:00	QQQ	ETF	395.22	395.5104	393.63	394.6	121714.0
2021-12-10 08:30:00	QQQ	ETF	394.58	397.67	394.32	397.07	1285811.0
2021-12-10 09:00:00	QQQ	ETF	397.1	397.22	396.52	396.59	195340.0
2021-12-10 09:30:00	QQQ	ETF	396.59	398.06	395.0	395.43	9391223.0
2021-12-10 10:00:00	QQQ	ETF	395.4	397.68	395.25	397.29	5218315.0
2021-12-10 10:30:00	QQQ	ETF	397.2823	397.37	394.086	395.14	3525126.0
2021-12-10 11:00:00	QQQ	ETF	395.07	395.32	393.36	395.235	3430277.0
2021-12-10 11:30:00	QQQ	ETF	395.25	396.5362	394.29	396.16	2933187.0
2021-12-10 12:00:00	QQQ	ETF	396.19	396.52	395.53	396.0	1874868.0
2021-12-10 12:30:00	QQQ	ETF	396.02	396.45	395.13	396.395	1951258.0

> showing 50 of 24,060 rows — these rows as CSV

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