PREVIEW / etf_30min / 2020-04-01

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-01.parquet
  size:    582 KB
  rows:    21,486

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
2020-04-01 04:00:00	SPY	ETF	251.84	251.98	248.6	249.12	141662.0
2020-04-01 04:30:00	SPY	ETF	249.19	249.85	248.35	249.7	176045.0
2020-04-01 05:00:00	SPY	ETF	249.7	250.76	249.15	250.05	122562.0
2020-04-01 05:30:00	SPY	ETF	250.1	250.66	249.83	250.3	32070.0
2020-04-01 06:00:00	SPY	ETF	250.25	251.01	249.48	249.78	113746.0
2020-04-01 06:30:00	SPY	ETF	249.82	250.22	248.95	249.4	212508.0
2020-04-01 07:00:00	SPY	ETF	249.46	249.67	248.37	249.12	354268.0
2020-04-01 07:30:00	SPY	ETF	249.1	249.69	248.7	248.75	541515.0
2020-04-01 08:00:00	SPY	ETF	248.74	257.75	247.29	248.41	1482812.0
2020-04-01 08:30:00	SPY	ETF	248.31	249.45	248.25	248.5	936898.0
2020-04-01 09:00:00	SPY	ETF	248.58	249.3	247.41	247.95	1205753.0
2020-04-01 09:30:00	SPY	ETF	247.98	249.88	247.61	248.89	18974093.0
2020-04-01 10:00:00	SPY	ETF	248.92	250.45	248.18	249.45	14733351.0
2020-04-01 10:30:00	SPY	ETF	249.45	250.72	249.04	250.23	11828979.0
2020-04-01 11:00:00	SPY	ETF	250.22	251.44	249.29	249.41	12003500.0
2020-04-01 11:30:00	SPY	ETF	249.42	250.03	248.27	248.75	9769924.0
2020-04-01 12:00:00	SPY	ETF	248.72	248.76	247.2	247.31	10946326.0
2020-04-01 12:30:00	SPY	ETF	247.315	247.94	245.81	246.242	12580305.0
2020-04-01 13:00:00	SPY	ETF	246.225	247.55	245.94	247.1	10265819.0
2020-04-01 13:30:00	SPY	ETF	247.105	248.15	246.42	247.9	7070071.0
2020-04-01 14:00:00	SPY	ETF	247.9	248.7101	246.92	247.21	10128142.0
2020-04-01 14:30:00	SPY	ETF	247.21	257.6591	245.73	245.79	14074139.0
2020-04-01 15:00:00	SPY	ETF	245.775	246.48	245.01	245.01	8867073.0
2020-04-01 15:30:00	SPY	ETF	245.02	247.24	243.9	246.12	29274253.0
2020-04-01 16:00:00	SPY	ETF	246.09	248.6285	245.1	245.28	10476926.0
2020-04-01 16:30:00	SPY	ETF	245.26	246.27	245.26	246.12	680756.0
2020-04-01 17:00:00	SPY	ETF	246.12	246.12	245.85	245.88	210590.0
2020-04-01 17:30:00	SPY	ETF	245.88	246.14	245.75	246.14	85410.0
2020-04-01 18:00:00	SPY	ETF	246.14	247.9	246.14	247.0	416860.0
2020-04-01 18:30:00	SPY	ETF	246.98	247.36	246.15	246.5	373059.0
2020-04-01 19:00:00	SPY	ETF	246.49	247.03	246.07	246.88	204487.0
2020-04-01 19:30:00	SPY	ETF	246.9	247.59	246.77	247.5	186176.0
2020-04-01 04:00:00	QQQ	ETF	185.61	186.04	184.78	184.89	37302.0
2020-04-01 04:30:00	QQQ	ETF	184.95	185.3	184.31	185.16	43094.0
2020-04-01 05:00:00	QQQ	ETF	185.51	186.0	184.83	185.48	17836.0
2020-04-01 05:30:00	QQQ	ETF	185.55	185.9	185.21	185.59	32033.0
2020-04-01 06:00:00	QQQ	ETF	185.78	186.14	185.07	185.32	33956.0
2020-04-01 06:30:00	QQQ	ETF	185.37	185.55	184.69	185.08	141514.0
2020-04-01 07:00:00	QQQ	ETF	185.1	185.18	184.58	185.01	189190.0
2020-04-01 07:30:00	QQQ	ETF	185.03	185.5	184.78	184.92	282632.0
2020-04-01 08:00:00	QQQ	ETF	184.91	188.12	183.85	184.75	471194.0
2020-04-01 08:30:00	QQQ	ETF	184.7	185.45	184.65	184.78	180551.0
2020-04-01 09:00:00	QQQ	ETF	184.84	185.44	184.55	184.78	464576.0
2020-04-01 09:30:00	QQQ	ETF	184.78	186.385	184.69	185.21	5876732.0
2020-04-01 10:00:00	QQQ	ETF	185.22	186.47	184.78	186.01	4007168.0
2020-04-01 10:30:00	QQQ	ETF	186.01	187.04	185.71	186.7011	3035182.0
2020-04-01 11:00:00	QQQ	ETF	186.68	187.66	186.18	186.23	2770486.0
2020-04-01 11:30:00	QQQ	ETF	186.25	186.52	185.22	185.58	2507654.0
2020-04-01 12:00:00	QQQ	ETF	185.56	185.56	184.45	184.5	2452008.0
2020-04-01 12:30:00	QQQ	ETF	184.51	184.85	183.18	183.46	3511081.0

> showing 50 of 21,486 rows — these rows as CSV

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