PREVIEW / etf_30min / 2020-09-29

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-29.parquet
  size:    541 KB
  rows:    19,741

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-09-29 04:00:00	SPY	ETF	333.94	334.0	333.14	334.0	34138.0
2020-09-29 04:30:00	SPY	ETF	333.9	334.23	333.79	334.08	16550.0
2020-09-29 05:00:00	SPY	ETF	334.04	334.25	333.71	333.87	14991.0
2020-09-29 05:30:00	SPY	ETF	333.56	334.33	333.5	334.28	15056.0
2020-09-29 06:00:00	SPY	ETF	334.2	334.58	334.13	334.56	20737.0
2020-09-29 06:30:00	SPY	ETF	334.58	334.61	334.1	334.19	12020.0
2020-09-29 07:00:00	SPY	ETF	334.33	334.76	334.29	334.37	75000.0
2020-09-29 07:30:00	SPY	ETF	334.32	334.32	333.92	333.99	122903.0
2020-09-29 08:00:00	SPY	ETF	334.1001	336.0	333.59	334.07	278190.0
2020-09-29 08:30:00	SPY	ETF	334.13	334.35	334.0	334.28	141030.0
2020-09-29 09:00:00	SPY	ETF	334.23	334.31	333.85	334.0	225342.0
2020-09-29 09:30:00	SPY	ETF	333.97	334.44	333.43	333.885	3642514.0
2020-09-29 10:00:00	SPY	ETF	333.88	334.77	333.55	334.42	3621980.0
2020-09-29 10:30:00	SPY	ETF	334.43	334.53	332.64	332.95	4734632.0
2020-09-29 11:00:00	SPY	ETF	332.94	333.25	332.5	332.87	3001921.0
2020-09-29 11:30:00	SPY	ETF	332.875	333.35	331.8	332.15	3148286.0
2020-09-29 12:00:00	SPY	ETF	332.16	332.29	331.71	332.1801	2419458.0
2020-09-29 12:30:00	SPY	ETF	332.18	332.75	332.05	332.69	1792205.0
2020-09-29 13:00:00	SPY	ETF	332.695	332.71	331.6209	332.59	2333981.0
2020-09-29 13:30:00	SPY	ETF	332.59	333.55	332.58	333.26	1843407.0
2020-09-29 14:00:00	SPY	ETF	333.255	333.65	332.93	333.5925	2099992.0
2020-09-29 14:30:00	SPY	ETF	333.605	333.885	333.29	333.33	2203622.0
2020-09-29 15:00:00	SPY	ETF	333.32	333.7611	332.94	333.12	2821874.0
2020-09-29 15:30:00	SPY	ETF	333.13	333.33	332.37	332.39	8122171.0
2020-09-29 16:00:00	SPY	ETF	332.4	333.64	332.34	333.23	5639526.0
2020-09-29 16:30:00	SPY	ETF	333.29	333.45	332.9	332.9	468136.0
2020-09-29 17:00:00	SPY	ETF	332.74	332.9	332.69	332.75	77021.0
2020-09-29 17:30:00	SPY	ETF	332.75	332.8	332.7	332.79	31103.0
2020-09-29 18:00:00	SPY	ETF	332.79	333.2	332.72	333.03	64413.0
2020-09-29 18:30:00	SPY	ETF	333.08	333.58	332.88	333.38	121338.0
2020-09-29 19:00:00	SPY	ETF	333.38	333.65	333.35	333.57	41052.0
2020-09-29 19:30:00	SPY	ETF	333.6	333.61	333.35	333.55	51720.0
2020-09-29 04:00:00	QQQ	ETF	277.45	277.46	276.45	277.02	19771.0
2020-09-29 04:30:00	QQQ	ETF	276.94	277.28	276.84	277.11	9665.0
2020-09-29 05:00:00	QQQ	ETF	277.04	277.48	276.9	276.92	14047.0
2020-09-29 05:30:00	QQQ	ETF	276.8	277.4	276.7	277.35	20995.0
2020-09-29 06:00:00	QQQ	ETF	277.24	277.79	277.2	277.6	16045.0
2020-09-29 06:30:00	QQQ	ETF	277.69	277.74	277.07	277.3	24265.0
2020-09-29 07:00:00	QQQ	ETF	277.45	277.84	277.27	277.33	58259.0
2020-09-29 07:30:00	QQQ	ETF	277.36	277.36	276.79	276.81	122855.0
2020-09-29 08:00:00	QQQ	ETF	277.614	279.02	276.6	277.11	398355.0
2020-09-29 08:30:00	QQQ	ETF	277.15	277.44	276.87	277.24	64170.0
2020-09-29 09:00:00	QQQ	ETF	277.29	277.36	276.53	276.69	88907.0
2020-09-29 09:30:00	QQQ	ETF	276.72	277.56	276.34	276.78	2542404.0
2020-09-29 10:00:00	QQQ	ETF	276.78	277.71	276.38	277.0	2004048.0
2020-09-29 10:30:00	QQQ	ETF	277.019	277.0899	275.3719	276.06	2434879.0
2020-09-29 11:00:00	QQQ	ETF	276.07	277.13	275.65	276.78	1419449.0
2020-09-29 11:30:00	QQQ	ETF	276.78	277.17	275.77	276.231	1412267.0
2020-09-29 12:00:00	QQQ	ETF	276.23	276.38	275.9	276.18	905277.0
2020-09-29 12:30:00	QQQ	ETF	276.19	276.85	276.04	276.76	782490.0

> showing 50 of 19,741 rows — these rows as CSV

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