PREVIEW / etf_30min / 2021-11-26

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-26.parquet
  size:    467 KB
  rows:    17,384

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-26 04:00:00	SPY	ETF	465.0	465.0	460.17	460.35	194554.0
2021-11-26 04:30:00	SPY	ETF	460.33	461.2	459.75	460.63	76311.0
2021-11-26 05:00:00	SPY	ETF	460.95	461.8	460.77	461.66	119177.0
2021-11-26 05:30:00	SPY	ETF	461.71	461.76	460.12	461.16	37501.0
2021-11-26 06:00:00	SPY	ETF	460.94	461.98	460.85	461.64	127851.0
2021-11-26 06:30:00	SPY	ETF	461.41	461.54	460.74	461.16	106503.0
2021-11-26 07:00:00	SPY	ETF	461.07	462.41	461.02	461.57	365474.0
2021-11-26 07:30:00	SPY	ETF	461.52	462.28	461.52	461.59	698150.0
2021-11-26 08:00:00	SPY	ETF	461.6199	465.39	459.6	461.7	719580.0
2021-11-26 08:30:00	SPY	ETF	461.64	461.87	461.2	461.58	568938.0
2021-11-26 09:00:00	SPY	ETF	461.6	462.49	461.44	462.38	456363.0
2021-11-26 09:30:00	SPY	ETF	462.38	463.9	460.62	461.49	13253085.0
2021-11-26 10:00:00	SPY	ETF	461.48	461.51	459.0416	461.01	10467307.0
2021-11-26 10:30:00	SPY	ETF	461.02	461.4	459.74	460.23	7413296.0
2021-11-26 11:00:00	SPY	ETF	460.22	460.22	458.135	458.95	6964493.0
2021-11-26 11:30:00	SPY	ETF	458.95	459.72	458.34	458.93	7218498.0
2021-11-26 12:00:00	SPY	ETF	458.94	460.68	458.62	460.62	6556817.0
2021-11-26 12:30:00	SPY	ETF	460.625	461.5	457.77	459.03	19444777.0
2021-11-26 13:00:00	SPY	ETF	459.04	459.68	457.0	458.1	5178196.0
2021-11-26 13:30:00	SPY	ETF	458.1	458.97	457.5	457.55	411223.0
2021-11-26 14:00:00	SPY	ETF	457.59	458.97	457.0	457.25	170118.0
2021-11-26 14:30:00	SPY	ETF	457.26	457.3	456.94	457.08	69502.0
2021-11-26 15:00:00	SPY	ETF	457.16	457.16	456.9	457.16	49646.0
2021-11-26 15:30:00	SPY	ETF	457.14	457.14	456.88	456.93	54129.0
2021-11-26 16:00:00	SPY	ETF	456.93	457.19	456.86	456.86	47998.0
2021-11-26 16:30:00	SPY	ETF	456.95	457.2	456.95	457.1	18682.0
2021-11-26 04:00:00	QQQ	ETF	395.08	395.32	393.68	393.92	119437.0
2021-11-26 04:30:00	QQQ	ETF	393.84	394.27	393.19	393.9	148026.0
2021-11-26 05:00:00	QQQ	ETF	393.84	394.69	393.83	394.6	79953.0
2021-11-26 05:30:00	QQQ	ETF	394.6	394.6	393.91	394.37	45247.0
2021-11-26 06:00:00	QQQ	ETF	394.33	395.48	394.31	395.36	76752.0
2021-11-26 06:30:00	QQQ	ETF	395.25	395.25	394.38	394.75	156759.0
2021-11-26 07:00:00	QQQ	ETF	394.8	396.23	394.64	395.43	265471.0
2021-11-26 07:30:00	QQQ	ETF	395.35	395.84	394.76	394.86	271019.0
2021-11-26 08:00:00	QQQ	ETF	394.9	397.0	393.34	395.16	602840.0
2021-11-26 08:30:00	QQQ	ETF	395.1	395.23	394.51	394.76	311635.0
2021-11-26 09:00:00	QQQ	ETF	394.76	398.76	394.73	396.11	440810.0
2021-11-26 09:30:00	QQQ	ETF	396.11	397.54	394.15	395.65	8002754.0
2021-11-26 10:00:00	QQQ	ETF	395.64	395.85	392.87	394.38	5755502.0
2021-11-26 10:30:00	QQQ	ETF	394.3401	394.6073	392.51	393.0288	3141437.0
2021-11-26 11:00:00	QQQ	ETF	393.02	393.02	390.76	391.8611	3677598.0
2021-11-26 11:30:00	QQQ	ETF	391.84	392.6504	391.39	391.95	3450218.0
2021-11-26 12:00:00	QQQ	ETF	391.96	393.0587	391.54	393.01	3322854.0
2021-11-26 12:30:00	QQQ	ETF	392.99	393.41	389.77	390.99	7914621.0
2021-11-26 13:00:00	QQQ	ETF	391.0	391.68	390.75	391.32	1736767.0
2021-11-26 13:30:00	QQQ	ETF	391.3201	391.53	391.2	391.24	163745.0
2021-11-26 14:00:00	QQQ	ETF	391.2	391.37	390.75	391.2	25019.0
2021-11-26 14:30:00	QQQ	ETF	391.2	391.23	390.72	390.86	11983.0
2021-11-26 15:00:00	QQQ	ETF	391.01	391.01	390.51	390.51	17857.0
2021-11-26 15:30:00	QQQ	ETF	390.57	390.73	390.36	390.65	14420.0

> showing 50 of 17,384 rows — these rows as CSV

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