PREVIEW / etf_30min / 2021-04-13

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-13.parquet
  size:    619 KB
  rows:    23,306

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-04-13 04:00:00	SPY	ETF	411.76	411.8	411.7	411.79	2900.0
2021-04-13 04:30:00	SPY	ETF	411.73	411.77	411.64	411.64	2410.0
2021-04-13 05:00:00	SPY	ETF	411.67	411.81	411.61	411.79	1328.0
2021-04-13 05:30:00	SPY	ETF	411.63	412.16	411.63	412.16	9590.0
2021-04-13 06:00:00	SPY	ETF	412.18	412.23	411.65	411.65	12139.0
2021-04-13 06:30:00	SPY	ETF	411.65	411.7	411.09	411.22	100306.0
2021-04-13 07:00:00	SPY	ETF	411.25	411.3	409.68	410.15	594436.0
2021-04-13 07:30:00	SPY	ETF	410.15	410.68	410.03	410.41	197722.0
2021-04-13 08:00:00	SPY	ETF	410.41	411.79	409.96	410.58	151782.0
2021-04-13 08:30:00	SPY	ETF	410.62	411.8	410.3	411.8	481029.0
2021-04-13 09:00:00	SPY	ETF	411.77	411.91	411.42	411.54	385905.0
2021-04-13 09:30:00	SPY	ETF	411.53	411.84	411.12	411.8	4484973.0
2021-04-13 10:00:00	SPY	ETF	411.8	412.15	411.74	411.95	3790783.0
2021-04-13 10:30:00	SPY	ETF	411.95	412.2	411.72	411.82	2462123.0
2021-04-13 11:00:00	SPY	ETF	411.827	412.07	411.75	412.06	1649724.0
2021-04-13 11:30:00	SPY	ETF	412.0599	412.21	411.74	412.077	1720121.0
2021-04-13 12:00:00	SPY	ETF	412.08	412.19	411.91	411.96	1237326.0
2021-04-13 12:30:00	SPY	ETF	411.965	412.12	411.61	411.625	2046944.0
2021-04-13 13:00:00	SPY	ETF	411.6219	412.05	411.54	411.975	3421868.0
2021-04-13 13:30:00	SPY	ETF	411.98	412.27	411.94	412.18	2489701.0
2021-04-13 14:00:00	SPY	ETF	412.185	412.72	412.15	412.6981	3252325.0
2021-04-13 14:30:00	SPY	ETF	412.695	413.12	412.6628	413.045	2752556.0
2021-04-13 15:00:00	SPY	ETF	413.04	413.529	413.04	413.36	3457652.0
2021-04-13 15:30:00	SPY	ETF	413.35	413.42	412.7	412.8299	9685628.0
2021-04-13 16:00:00	SPY	ETF	412.81	412.98	412.76	412.9	2152059.0
2021-04-13 16:30:00	SPY	ETF	412.93	413.06	412.85	412.94	139405.0
2021-04-13 17:00:00	SPY	ETF	412.97	412.98	412.85	412.86	55879.0
2021-04-13 17:30:00	SPY	ETF	412.86	412.95	412.84	412.95	45517.0
2021-04-13 18:00:00	SPY	ETF	412.95	412.95	412.7	412.78	61461.0
2021-04-13 18:30:00	SPY	ETF	412.86	412.86	412.65	412.75	22148.0
2021-04-13 19:00:00	SPY	ETF	412.72	412.75	412.58	412.68	21780.0
2021-04-13 19:30:00	SPY	ETF	412.66	412.78	412.6	412.64	27407.0
2021-04-13 04:00:00	QQQ	ETF	336.64	336.79	336.58	336.63	13042.0
2021-04-13 04:30:00	QQQ	ETF	336.62	336.72	336.49	336.56	11505.0
2021-04-13 05:00:00	QQQ	ETF	336.51	336.62	336.37	336.54	10369.0
2021-04-13 05:30:00	QQQ	ETF	336.5	336.77	336.43	336.76	27467.0
2021-04-13 06:00:00	QQQ	ETF	336.84	336.91	336.42	336.43	23861.0
2021-04-13 06:30:00	QQQ	ETF	336.33	336.5	336.11	336.29	14064.0
2021-04-13 07:00:00	QQQ	ETF	336.31	336.46	335.81	336.19	131289.0
2021-04-13 07:30:00	QQQ	ETF	336.19	336.58	336.14	336.44	60284.0
2021-04-13 08:00:00	QQQ	ETF	336.53	337.0	335.82	336.85	104162.0
2021-04-13 08:30:00	QQQ	ETF	336.79	338.52	336.46	338.35	490017.0
2021-04-13 09:00:00	QQQ	ETF	338.39	338.68	338.12	338.16	281119.0
2021-04-13 09:30:00	QQQ	ETF	338.24	339.95	338.02	339.8	3882378.0
2021-04-13 10:00:00	QQQ	ETF	339.82	339.985	338.8	339.42	2326810.0
2021-04-13 10:30:00	QQQ	ETF	339.425	339.68	339.07	339.27	1600430.0
2021-04-13 11:00:00	QQQ	ETF	339.26	339.6	338.7	339.07	1606244.0
2021-04-13 11:30:00	QQQ	ETF	339.055	339.29	338.41	338.922	1378149.0
2021-04-13 12:00:00	QQQ	ETF	338.93	339.28	338.745	339.0882	1044229.0
2021-04-13 12:30:00	QQQ	ETF	339.09	339.36	338.805	338.9001	898515.0

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

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