PREVIEW / etf_30min / 2021-09-24

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-24.parquet
  size:    599 KB
  rows:    22,865

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-09-24 04:00:00	SPY	ETF	442.69	442.69	441.01	441.69	55680.0
2021-09-24 04:30:00	SPY	ETF	441.77	442.15	441.6	442.14	13812.0
2021-09-24 05:00:00	SPY	ETF	442.07	442.13	441.72	441.72	22433.0
2021-09-24 05:30:00	SPY	ETF	441.7	442.02	441.18	441.24	34038.0
2021-09-24 06:00:00	SPY	ETF	441.21	442.15	441.15	441.68	33469.0
2021-09-24 06:30:00	SPY	ETF	441.78	441.84	441.51	441.51	77877.0
2021-09-24 07:00:00	SPY	ETF	441.5	441.72	440.95	441.7	173355.0
2021-09-24 07:30:00	SPY	ETF	441.67	441.78	441.0	441.02	184025.0
2021-09-24 08:00:00	SPY	ETF	441.3799	443.512	440.66	441.12	299265.0
2021-09-24 08:30:00	SPY	ETF	441.1	441.1	440.52	440.79	265050.0
2021-09-24 09:00:00	SPY	ETF	440.78	441.47	440.59	441.45	409076.0
2021-09-24 09:30:00	SPY	ETF	441.44	443.64	441.21	443.62	6656322.0
2021-09-24 10:00:00	SPY	ETF	443.63	443.91	442.78	443.1	4468274.0
2021-09-24 10:30:00	SPY	ETF	443.1	443.28	442.21	442.66	3153915.0
2021-09-24 11:00:00	SPY	ETF	442.67	443.23	442.245	442.3	3220906.0
2021-09-24 11:30:00	SPY	ETF	442.3	443.39	442.14	443.21	2583208.0
2021-09-24 12:00:00	SPY	ETF	443.21	443.62	442.95	443.375	1919693.0
2021-09-24 12:30:00	SPY	ETF	443.37	443.67	443.25	443.4501	1328043.0
2021-09-24 13:00:00	SPY	ETF	443.47	443.56	443.19	443.49	1347664.0
2021-09-24 13:30:00	SPY	ETF	443.48	443.5	442.79	442.8079	1788978.0
2021-09-24 14:00:00	SPY	ETF	442.81	443.219	442.79	443.17	1689652.0
2021-09-24 14:30:00	SPY	ETF	443.1509	443.97	443.105	443.96	1585212.0
2021-09-24 15:00:00	SPY	ETF	443.96	444.28	443.36	444.075	3051009.0
2021-09-24 15:30:00	SPY	ETF	444.07	444.67	443.87	443.92	9303552.0
2021-09-24 16:00:00	SPY	ETF	443.93	444.15	443.8482	443.95	3104635.0
2021-09-24 16:30:00	SPY	ETF	443.96	444.03	443.91	443.98	291004.0
2021-09-24 17:00:00	SPY	ETF	443.89	444.13	443.89	443.95	37762.0
2021-09-24 17:30:00	SPY	ETF	443.97	444.27	443.91	444.2699	927805.0
2021-09-24 18:00:00	SPY	ETF	444.25	444.3	444.15	444.15	16679.0
2021-09-24 18:30:00	SPY	ETF	443.91	444.15	443.9	444.09	24987.0
2021-09-24 19:00:00	SPY	ETF	444.0	444.24	444.0	444.24	14842.0
2021-09-24 19:30:00	SPY	ETF	444.21	444.21	444.12	444.21	13526.0
2021-09-24 04:00:00	QQQ	ETF	372.23	372.23	370.75	371.23	51067.0
2021-09-24 04:30:00	QQQ	ETF	371.3	371.62	371.17	371.62	15962.0
2021-09-24 05:00:00	QQQ	ETF	371.71	371.71	371.29	371.42	14378.0
2021-09-24 05:30:00	QQQ	ETF	371.19	371.58	370.76	370.92	11327.0
2021-09-24 06:00:00	QQQ	ETF	370.88	371.59	370.88	371.3	23010.0
2021-09-24 06:30:00	QQQ	ETF	371.33	371.43	370.88	370.89	121625.0
2021-09-24 07:00:00	QQQ	ETF	371.0	371.27	370.5	371.04	114265.0
2021-09-24 07:30:00	QQQ	ETF	371.05	371.11	370.47	370.54	111506.0
2021-09-24 08:00:00	QQQ	ETF	371.15	372.95	370.15	370.5	207447.0
2021-09-24 08:30:00	QQQ	ETF	370.53	370.53	369.95	370.24	150557.0
2021-09-24 09:00:00	QQQ	ETF	370.19	370.66	370.08	370.641	316301.0
2021-09-24 09:30:00	QQQ	ETF	370.65	371.78	370.27	371.66	5026734.0
2021-09-24 10:00:00	QQQ	ETF	371.67	372.03	370.79	371.41	2431047.0
2021-09-24 10:30:00	QQQ	ETF	371.42	371.7599	370.66	370.955	2061593.0
2021-09-24 11:00:00	QQQ	ETF	370.97	371.64	370.72	370.7501	1318421.0
2021-09-24 11:30:00	QQQ	ETF	370.77	371.93	370.69	371.835	1647292.0
2021-09-24 12:00:00	QQQ	ETF	371.8392	372.5154	371.6	372.37	1073823.0
2021-09-24 12:30:00	QQQ	ETF	372.3925	372.75	372.22	372.59	908995.0

> showing 50 of 22,865 rows — these rows as CSV

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