PREVIEW / etf_30min / 2020-09-01

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-01.parquet
  size:    583 KB
  rows:    21,557

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-01 04:00:00	SPY	ETF	351.27	351.43	350.98	351.35	34609.0
2020-09-01 04:30:00	SPY	ETF	351.04	351.28	350.45	350.5	22528.0
2020-09-01 05:00:00	SPY	ETF	350.61	351.15	350.48	351.15	13304.0
2020-09-01 05:30:00	SPY	ETF	351.16	351.26	350.89	350.96	13965.0
2020-09-01 06:00:00	SPY	ETF	350.96	351.1	350.84	351.1	12599.0
2020-09-01 06:30:00	SPY	ETF	351.08	351.22	350.93	351.15	16625.0
2020-09-01 07:00:00	SPY	ETF	351.06	351.11	350.67	350.7	159097.0
2020-09-01 07:30:00	SPY	ETF	350.68	350.68	350.46	350.54	123611.0
2020-09-01 08:00:00	SPY	ETF	350.54	351.55	350.4999	350.75	89855.0
2020-09-01 08:30:00	SPY	ETF	350.73	350.92	350.2	350.32	145560.0
2020-09-01 09:00:00	SPY	ETF	350.23	350.29	349.45	350.21	371779.0
2020-09-01 09:30:00	SPY	ETF	350.21	350.59	349.24	350.473	6413657.0
2020-09-01 10:00:00	SPY	ETF	350.48	351.4	350.18	351.38	3828167.0
2020-09-01 10:30:00	SPY	ETF	351.39	351.4	350.6	350.66	4974971.0
2020-09-01 11:00:00	SPY	ETF	350.67	351.22	350.39	350.795	3906802.0
2020-09-01 11:30:00	SPY	ETF	350.79	351.07	350.641	350.7601	1657556.0
2020-09-01 12:00:00	SPY	ETF	350.77	351.18	350.69	350.96	2193147.0
2020-09-01 12:30:00	SPY	ETF	350.955	351.21	350.8	351.2077	1229156.0
2020-09-01 13:00:00	SPY	ETF	351.201	351.2099	350.85	351.0	1952037.0
2020-09-01 13:30:00	SPY	ETF	351.01	351.49	350.925	351.32	1568225.0
2020-09-01 14:00:00	SPY	ETF	351.33	351.81	351.25	351.7316	3186571.0
2020-09-01 14:30:00	SPY	ETF	351.73	351.91	351.6	351.84	3075195.0
2020-09-01 15:00:00	SPY	ETF	351.84	351.9	351.39	351.52	3845879.0
2020-09-01 15:30:00	SPY	ETF	351.525	352.69	351.41	352.56	8933927.0
2020-09-01 16:00:00	SPY	ETF	352.56	352.79	351.8155	352.7	5450546.0
2020-09-01 16:30:00	SPY	ETF	352.7	353.05	352.6	352.99	300343.0
2020-09-01 17:00:00	SPY	ETF	353.0	353.0	352.88	352.9	72490.0
2020-09-01 17:30:00	SPY	ETF	352.9199	352.99	352.87	352.99	19238.0
2020-09-01 18:00:00	SPY	ETF	352.92	352.95	352.75	352.81	38470.0
2020-09-01 18:30:00	SPY	ETF	352.81	352.97	352.74	352.93	16135.0
2020-09-01 19:00:00	SPY	ETF	352.89	353.35	352.6	353.3	28970.0
2020-09-01 19:30:00	SPY	ETF	353.31	353.58	353.17	353.57	36196.0
2020-09-01 04:00:00	QQQ	ETF	297.97	298.31	297.84	298.24	50411.0
2020-09-01 04:30:00	QQQ	ETF	298.14	298.25	297.85	297.92	37321.0
2020-09-01 05:00:00	QQQ	ETF	297.94	298.52	297.94	298.45	15436.0
2020-09-01 05:30:00	QQQ	ETF	298.43	298.81	298.43	298.54	37101.0
2020-09-01 06:00:00	QQQ	ETF	298.48	298.58	298.4	298.53	18801.0
2020-09-01 06:30:00	QQQ	ETF	298.49	298.65	298.39	298.63	17393.0
2020-09-01 07:00:00	QQQ	ETF	298.61	298.61	297.92	298.0	130524.0
2020-09-01 07:30:00	QQQ	ETF	297.98	298.0	297.66	297.86	100947.0
2020-09-01 08:00:00	QQQ	ETF	297.8701	298.5296	296.72	298.14	147166.0
2020-09-01 08:30:00	QQQ	ETF	298.15	298.37	297.3	297.37	246779.0
2020-09-01 09:00:00	QQQ	ETF	297.31	297.59	296.9304	297.57	255596.0
2020-09-01 09:30:00	QQQ	ETF	297.6	297.97	295.79	297.56	4643492.0
2020-09-01 10:00:00	QQQ	ETF	297.59	299.32	297.45	299.31	3486850.0
2020-09-01 10:30:00	QQQ	ETF	299.31	299.32	298.08	298.14	2347510.0
2020-09-01 11:00:00	QQQ	ETF	298.14	298.8	297.72	298.28	2373874.0
2020-09-01 11:30:00	QQQ	ETF	298.29	298.43	297.82	298.13	1689354.0
2020-09-01 12:00:00	QQQ	ETF	298.128	299.02	298.04	298.6358	1197011.0
2020-09-01 12:30:00	QQQ	ETF	298.63	298.94	298.342	298.86	897353.0

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

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