PREVIEW / etf_30min / 2021-11-11

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-11.parquet
  size:    607 KB
  rows:    23,620

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-11 04:00:00	SPY	ETF	464.66	465.41	464.66	465.35	38881.0
2021-11-11 04:30:00	SPY	ETF	465.38	465.46	465.28	465.36	14525.0
2021-11-11 05:00:00	SPY	ETF	465.4	465.65	465.4	465.47	10217.0
2021-11-11 05:30:00	SPY	ETF	465.49	465.49	465.03	465.21	8912.0
2021-11-11 06:00:00	SPY	ETF	465.2	465.4	465.2	465.26	5014.0
2021-11-11 06:30:00	SPY	ETF	465.37	465.5	465.26	465.43	7934.0
2021-11-11 07:00:00	SPY	ETF	465.5	465.66	465.3	465.45	54181.0
2021-11-11 07:30:00	SPY	ETF	465.41	465.5	465.24	465.44	39127.0
2021-11-11 08:00:00	SPY	ETF	465.4025	465.58	465.23	465.35	144297.0
2021-11-11 08:30:00	SPY	ETF	465.34	465.49	465.22	465.45	95129.0
2021-11-11 09:00:00	SPY	ETF	465.43	465.46	465.11	465.18	136343.0
2021-11-11 09:30:00	SPY	ETF	465.21	465.29	464.23	465.02	4098685.0
2021-11-11 10:00:00	SPY	ETF	465.02	465.06	464.2254	464.26	2479292.0
2021-11-11 10:30:00	SPY	ETF	464.26	464.82	463.93	464.54	3045436.0
2021-11-11 11:00:00	SPY	ETF	464.53	464.725	464.24	464.4317	1523904.0
2021-11-11 11:30:00	SPY	ETF	464.43	465.095	464.39	464.681	1644608.0
2021-11-11 12:00:00	SPY	ETF	464.68	464.835	463.84	464.235	1314445.0
2021-11-11 12:30:00	SPY	ETF	464.23	464.71	464.14	464.44	783299.0
2021-11-11 13:00:00	SPY	ETF	464.44	464.44	463.905	464.28	982270.0
2021-11-11 13:30:00	SPY	ETF	464.27	464.515	464.16	464.39	941688.0
2021-11-11 14:00:00	SPY	ETF	464.4	464.77	464.32	464.43	994889.0
2021-11-11 14:30:00	SPY	ETF	464.43	464.84	464.18	464.26	1054147.0
2021-11-11 15:00:00	SPY	ETF	464.26	464.42	463.83	464.29	1648621.0
2021-11-11 15:30:00	SPY	ETF	464.28	464.45	463.75	463.81	4560805.0
2021-11-11 16:00:00	SPY	ETF	463.82	464.21	463.77	464.08	1725201.0
2021-11-11 16:30:00	SPY	ETF	464.08	464.23	463.77	464.19	280967.0
2021-11-11 17:00:00	SPY	ETF	464.2	464.2	464.03	464.12	23930.0
2021-11-11 17:30:00	SPY	ETF	464.13	464.19	464.13	464.14	31408.0
2021-11-11 18:00:00	SPY	ETF	464.19	464.41	464.14	464.4	26537.0
2021-11-11 18:30:00	SPY	ETF	463.77	464.61	463.77	464.6	25535.0
2021-11-11 19:00:00	SPY	ETF	464.62	465.02	464.62	464.98	46680.0
2021-11-11 19:30:00	SPY	ETF	464.98	465.32	464.95	465.0	31813.0
2021-11-11 04:00:00	QQQ	ETF	390.53	391.87	390.53	391.83	44918.0
2021-11-11 04:30:00	QQQ	ETF	391.88	392.15	391.85	392.0	21184.0
2021-11-11 05:00:00	QQQ	ETF	391.97	392.35	391.92	391.98	21650.0
2021-11-11 05:30:00	QQQ	ETF	391.95	391.96	391.44	391.96	21695.0
2021-11-11 06:00:00	QQQ	ETF	391.92	392.11	391.76	391.88	9402.0
2021-11-11 06:30:00	QQQ	ETF	392.0	392.21	391.89	392.12	30799.0
2021-11-11 07:00:00	QQQ	ETF	392.1	392.28	391.88	392.06	68100.0
2021-11-11 07:30:00	QQQ	ETF	392.06	392.31	391.83	392.18	99238.0
2021-11-11 08:00:00	QQQ	ETF	392.09	392.46	390.0	392.44	134865.0
2021-11-11 08:30:00	QQQ	ETF	392.45	392.81	392.33	392.69	194464.0
2021-11-11 09:00:00	QQQ	ETF	392.71	392.76	392.31	392.5304	210233.0
2021-11-11 09:30:00	QQQ	ETF	392.57	392.75	391.35	392.36	3657364.0
2021-11-11 10:00:00	QQQ	ETF	392.36	392.48	391.06	391.24	2968439.0
2021-11-11 10:30:00	QQQ	ETF	391.24	392.32	390.97	391.8699	2671909.0
2021-11-11 11:00:00	QQQ	ETF	391.87	392.11	391.3237	391.79	1234226.0
2021-11-11 11:30:00	QQQ	ETF	391.79	392.37	391.7	391.86	1165571.0
2021-11-11 12:00:00	QQQ	ETF	391.86	391.9584	390.6	391.01	1941365.0
2021-11-11 12:30:00	QQQ	ETF	391.02	391.64	390.9002	391.33	1046743.0

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

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