PREVIEW / etf_30min / 2021-11-19

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-19.parquet
  size:    642 KB
  rows:    24,873

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-11-19 04:00:00	SPY	ETF	470.53	472.0	470.53	470.79	8196.0
2021-11-19 04:30:00	SPY	ETF	470.81	470.81	469.67	469.67	28044.0
2021-11-19 05:00:00	SPY	ETF	469.57	469.57	468.0	469.16	71976.0
2021-11-19 05:30:00	SPY	ETF	469.17	469.55	468.96	469.55	8139.0
2021-11-19 06:00:00	SPY	ETF	469.55	469.57	468.82	469.1	36077.0
2021-11-19 06:30:00	SPY	ETF	469.01	469.02	468.2	468.44	35930.0
2021-11-19 07:00:00	SPY	ETF	468.46	468.95	468.42	468.89	57249.0
2021-11-19 07:30:00	SPY	ETF	468.86	468.95	468.01	468.31	132707.0
2021-11-19 08:00:00	SPY	ETF	468.31	471.52	468.03	468.54	194946.0
2021-11-19 08:30:00	SPY	ETF	468.53	469.73	468.26	468.92	193260.0
2021-11-19 09:00:00	SPY	ETF	468.89	469.93	468.54	469.57	380875.0
2021-11-19 09:30:00	SPY	ETF	469.61	470.21	468.71	470.18	4972129.0
2021-11-19 10:00:00	SPY	ETF	470.18	470.21	468.81	468.8564	2922785.0
2021-11-19 10:30:00	SPY	ETF	468.85	469.81	468.8	469.35	2510874.0
2021-11-19 11:00:00	SPY	ETF	469.35	470.13	469.32	470.08	1432825.0
2021-11-19 11:30:00	SPY	ETF	470.1	470.2	469.81	469.97	1346833.0
2021-11-19 12:00:00	SPY	ETF	469.9713	470.47	469.97	470.42	1494397.0
2021-11-19 12:30:00	SPY	ETF	470.42	470.94	470.18	470.31	1511194.0
2021-11-19 13:00:00	SPY	ETF	470.32	470.44	469.2	469.21	1975750.0
2021-11-19 13:30:00	SPY	ETF	469.2	469.55	468.5	469.54	2912455.0
2021-11-19 14:00:00	SPY	ETF	469.53	469.85	469.42	469.4201	1702548.0
2021-11-19 14:30:00	SPY	ETF	469.44	469.6	469.1032	469.4	1723163.0
2021-11-19 15:00:00	SPY	ETF	469.395	469.54	468.89	469.22	2081425.0
2021-11-19 15:30:00	SPY	ETF	469.21	469.37	468.66	468.92	5529115.0
2021-11-19 16:00:00	SPY	ETF	468.9	469.14	468.8	469.07	2283113.0
2021-11-19 16:30:00	SPY	ETF	469.07	469.32	469.03	469.32	141313.0
2021-11-19 17:00:00	SPY	ETF	469.13	469.45	469.13	469.27	65119.0
2021-11-19 17:30:00	SPY	ETF	469.23	469.25	469.1	469.24	24653.0
2021-11-19 18:00:00	SPY	ETF	469.24	469.25	469.2	469.21	2214.0
2021-11-19 18:30:00	SPY	ETF	469.21	469.23	469.05	469.2	6533.0
2021-11-19 19:00:00	SPY	ETF	469.24	469.24	469.1	469.24	5284.0
2021-11-19 19:30:00	SPY	ETF	469.18	469.23	469.01	469.17	7336.0
2021-11-19 04:00:00	QQQ	ETF	403.12	403.96	403.12	403.67	23858.0
2021-11-19 04:30:00	QQQ	ETF	403.7	403.76	403.15	403.15	57592.0
2021-11-19 05:00:00	QQQ	ETF	403.21	403.29	402.43	403.14	58683.0
2021-11-19 05:30:00	QQQ	ETF	403.18	403.44	403.1	403.3	24816.0
2021-11-19 06:00:00	QQQ	ETF	403.34	403.42	403.0	403.37	30175.0
2021-11-19 06:30:00	QQQ	ETF	403.39	403.39	402.62	402.97	38622.0
2021-11-19 07:00:00	QQQ	ETF	402.98	403.5	402.92	403.39	82287.0
2021-11-19 07:30:00	QQQ	ETF	403.36	403.58	403.08	403.36	79746.0
2021-11-19 08:00:00	QQQ	ETF	403.0	403.85	402.051	403.46	187939.0
2021-11-19 08:30:00	QQQ	ETF	403.47	403.81	403.22	403.8	264278.0
2021-11-19 09:00:00	QQQ	ETF	403.79	403.89	402.96	403.38	548271.0
2021-11-19 09:30:00	QQQ	ETF	403.43	405.02	402.58	404.92	4070513.0
2021-11-19 10:00:00	QQQ	ETF	404.94	405.04	403.36	403.3601	3098969.0
2021-11-19 10:30:00	QQQ	ETF	403.37	404.54	403.34	403.78	1805432.0
2021-11-19 11:00:00	QQQ	ETF	403.78	404.8	403.71	404.7989	1261778.0
2021-11-19 11:30:00	QQQ	ETF	404.7996	405.25	404.502	404.71	1493896.0
2021-11-19 12:00:00	QQQ	ETF	404.72	405.09	404.57	404.8	990117.0
2021-11-19 12:30:00	QQQ	ETF	404.79	405.3	404.3	404.4	983721.0

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

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