PREVIEW / etf_30min / 2020-02-10

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-10.parquet
  size:    537 KB
  rows:    18,987

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-02-10 04:00:00	SPY	ETF	331.77	332.44	331.77	332.11	37775.0
2020-02-10 04:30:00	SPY	ETF	332.04	332.1	331.75	331.82	5529.0
2020-02-10 05:00:00	SPY	ETF	331.67	331.75	331.59	331.66	2100.0
2020-02-10 05:30:00	SPY	ETF	331.75	332.5	331.61	332.24	61734.0
2020-02-10 06:00:00	SPY	ETF	332.23	332.31	332.2	332.3	4698.0
2020-02-10 06:30:00	SPY	ETF	332.41	332.41	332.18	332.18	13319.0
2020-02-10 07:00:00	SPY	ETF	332.23	332.4	331.93	332.04	88271.0
2020-02-10 07:30:00	SPY	ETF	332.04	332.21	331.9	331.99	91570.0
2020-02-10 08:00:00	SPY	ETF	331.98	332.44	331.5	332.16	151087.0
2020-02-10 08:30:00	SPY	ETF	332.13	332.17	331.6	331.65	185446.0
2020-02-10 09:00:00	SPY	ETF	331.67	331.75	331.06	331.23	383825.0
2020-02-10 09:30:00	SPY	ETF	331.23	332.79	331.19	332.78	5481264.0
2020-02-10 10:00:00	SPY	ETF	332.7891	333.35	332.74	333.31	3330669.0
2020-02-10 10:30:00	SPY	ETF	333.31	333.7	333.21	333.325	2342478.0
2020-02-10 11:00:00	SPY	ETF	333.32	333.5	333.13	333.425	2763111.0
2020-02-10 11:30:00	SPY	ETF	333.44	333.7082	333.252	333.38	1873086.0
2020-02-10 12:00:00	SPY	ETF	333.37	333.38	333.03	333.15	1823904.0
2020-02-10 12:30:00	SPY	ETF	333.15	333.2151	332.88	333.05	1238000.0
2020-02-10 13:00:00	SPY	ETF	333.05	333.34	333.0	333.21	1746317.0
2020-02-10 13:30:00	SPY	ETF	333.2	333.3693	333.11	333.19	1146448.0
2020-02-10 14:00:00	SPY	ETF	333.195	333.39	333.015	333.37	1162838.0
2020-02-10 14:30:00	SPY	ETF	333.379	333.82	333.3201	333.8	1619751.0
2020-02-10 15:00:00	SPY	ETF	333.8	334.2	333.77	334.15	3301380.0
2020-02-10 15:30:00	SPY	ETF	334.15	334.72	333.91	334.69	6321492.0
2020-02-10 16:00:00	SPY	ETF	334.7	334.89	334.3484	334.83	5001678.0
2020-02-10 16:30:00	SPY	ETF	334.82	334.85	334.73	334.78	249130.0
2020-02-10 17:00:00	SPY	ETF	334.82	334.82	334.69	334.73	53408.0
2020-02-10 17:30:00	SPY	ETF	334.7	334.75	334.68	334.7	58954.0
2020-02-10 18:00:00	SPY	ETF	334.7	334.82	334.52	334.79	70963.0
2020-02-10 18:30:00	SPY	ETF	334.7	334.75	334.59	334.7	11742.0
2020-02-10 19:00:00	SPY	ETF	334.69	335.0	334.52	334.98	125981.0
2020-02-10 19:30:00	SPY	ETF	334.99	335.31	334.94	335.13	78098.0
2020-02-10 04:00:00	QQQ	ETF	228.89	229.41	228.89	229.26	15782.0
2020-02-10 04:30:00	QQQ	ETF	229.22	229.25	229.01	229.01	7747.0
2020-02-10 05:00:00	QQQ	ETF	229.06	229.06	228.83	228.94	8850.0
2020-02-10 05:30:00	QQQ	ETF	229.01	229.62	228.91	229.41	67956.0
2020-02-10 06:00:00	QQQ	ETF	229.38	229.45	229.37	229.44	5338.0
2020-02-10 06:30:00	QQQ	ETF	229.55	229.59	229.4	229.4	9155.0
2020-02-10 07:00:00	QQQ	ETF	229.45	229.57	229.18	229.27	57091.0
2020-02-10 07:30:00	QQQ	ETF	229.26	229.38	229.11	229.18	64070.0
2020-02-10 08:00:00	QQQ	ETF	229.47	229.7	228.63	229.2702	181433.0
2020-02-10 08:30:00	QQQ	ETF	229.31	229.32	228.87	228.91	128763.0
2020-02-10 09:00:00	QQQ	ETF	228.9	228.98	228.42	228.43	182130.0
2020-02-10 09:30:00	QQQ	ETF	228.43	230.09	228.38	230.08	3970013.0
2020-02-10 10:00:00	QQQ	ETF	230.074	230.425	229.99	230.4002	1480510.0
2020-02-10 10:30:00	QQQ	ETF	230.42	230.818	230.29	230.3271	1188804.0
2020-02-10 11:00:00	QQQ	ETF	230.36	230.6812	230.23	230.65	660163.0
2020-02-10 11:30:00	QQQ	ETF	230.66	230.98	230.57	230.77	990170.0
2020-02-10 12:00:00	QQQ	ETF	230.75	230.77	230.36	230.46	556615.0
2020-02-10 12:30:00	QQQ	ETF	230.45	230.61	230.28	230.5	433965.0

> showing 50 of 18,987 rows — these rows as CSV

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