PREVIEW / etf_30min / 2020-09-28

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-28.parquet
  size:    555 KB
  rows:    20,599

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-28 04:00:00	SPY	ETF	331.17	331.7	330.87	331.6	37047.0
2020-09-28 04:30:00	SPY	ETF	331.47	331.74	331.18	331.19	9232.0
2020-09-28 05:00:00	SPY	ETF	331.2	331.45	331.2	331.4	16250.0
2020-09-28 05:30:00	SPY	ETF	331.49	331.72	331.46	331.67	21228.0
2020-09-28 06:00:00	SPY	ETF	331.95	333.19	331.95	332.96	22781.0
2020-09-28 06:30:00	SPY	ETF	333.13	333.22	332.85	333.01	23666.0
2020-09-28 07:00:00	SPY	ETF	332.95	333.01	332.61	332.68	154107.0
2020-09-28 07:30:00	SPY	ETF	332.69	333.17	332.69	333.08	115069.0
2020-09-28 08:00:00	SPY	ETF	332.8301	333.59	329.85	333.39	236353.0
2020-09-28 08:30:00	SPY	ETF	333.4	333.55	333.19	333.33	175259.0
2020-09-28 09:00:00	SPY	ETF	333.33	333.41	332.94	333.22	171344.0
2020-09-28 09:30:00	SPY	ETF	333.22	333.85	332.15	332.76	7387039.0
2020-09-28 10:00:00	SPY	ETF	332.77	334.59	332.315	333.99	5511851.0
2020-09-28 10:30:00	SPY	ETF	333.99	334.47	332.78	333.1	4402898.0
2020-09-28 11:00:00	SPY	ETF	333.1	333.99	333.0	333.75	3177099.0
2020-09-28 11:30:00	SPY	ETF	333.76	334.26	333.39	333.7	2624672.0
2020-09-28 12:00:00	SPY	ETF	333.7	333.81	333.11	333.46	2395619.0
2020-09-28 12:30:00	SPY	ETF	333.475	334.225	333.19	334.19	2523546.0
2020-09-28 13:00:00	SPY	ETF	334.2	334.5	333.815	334.24	3305661.0
2020-09-28 13:30:00	SPY	ETF	334.26	334.81	334.26	334.63	2135473.0
2020-09-28 14:00:00	SPY	ETF	334.63	334.82	334.175	334.5	2496941.0
2020-09-28 14:30:00	SPY	ETF	334.5	334.96	334.4	334.7336	3286382.0
2020-09-28 15:00:00	SPY	ETF	334.72	334.78	334.08	334.6	3729901.0
2020-09-28 15:30:00	SPY	ETF	334.595	334.605	333.54	334.2	12847995.0
2020-09-28 16:00:00	SPY	ETF	334.19	334.57	333.9	334.5	5490075.0
2020-09-28 16:30:00	SPY	ETF	334.5	334.98	334.19	334.73	267425.0
2020-09-28 17:00:00	SPY	ETF	334.72	334.8	334.58	334.73	37425.0
2020-09-28 17:30:00	SPY	ETF	334.73	334.76	334.19	334.75	73650.0
2020-09-28 18:00:00	SPY	ETF	334.75	335.02	334.62	334.96	102699.0
2020-09-28 18:30:00	SPY	ETF	334.96	335.21	334.93	335.03	64455.0
2020-09-28 19:00:00	SPY	ETF	335.05	335.37	335.01	335.23	39509.0
2020-09-28 19:30:00	SPY	ETF	335.23	335.46	335.18	335.37	33232.0
2020-09-28 04:00:00	QQQ	ETF	274.0	274.67	273.8	274.4	25026.0
2020-09-28 04:30:00	QQQ	ETF	274.71	274.95	274.38	274.44	7111.0
2020-09-28 05:00:00	QQQ	ETF	274.53	274.85	274.53	274.73	13806.0
2020-09-28 05:30:00	QQQ	ETF	274.84	275.1	274.84	274.91	8009.0
2020-09-28 06:00:00	QQQ	ETF	275.0	276.45	274.88	276.11	41024.0
2020-09-28 06:30:00	QQQ	ETF	276.24	276.58	276.1	276.15	29685.0
2020-09-28 07:00:00	QQQ	ETF	276.17	276.4	275.73	276.15	143587.0
2020-09-28 07:30:00	QQQ	ETF	276.12	276.68	276.09	276.62	265371.0
2020-09-28 08:00:00	QQQ	ETF	276.2699	277.19	272.65	276.9	400635.0
2020-09-28 08:30:00	QQQ	ETF	276.96	277.16	276.5898	276.67	132683.0
2020-09-28 09:00:00	QQQ	ETF	276.7	276.8698	276.43	276.6	376973.0
2020-09-28 09:30:00	QQQ	ETF	276.6	276.63	274.47	274.995	5536628.0
2020-09-28 10:00:00	QQQ	ETF	275.01	276.02	274.2745	275.54	3771276.0
2020-09-28 10:30:00	QQQ	ETF	275.54	276.005	274.06	274.21	2588452.0
2020-09-28 11:00:00	QQQ	ETF	274.202	275.63	274.125	275.36	2630330.0
2020-09-28 11:30:00	QQQ	ETF	275.4	275.75	274.53	274.795	1675334.0
2020-09-28 12:00:00	QQQ	ETF	274.81	274.8196	273.8548	274.32	1624873.0
2020-09-28 12:30:00	QQQ	ETF	274.31	275.3	274.01	275.3	1011152.0

> showing 50 of 20,599 rows — these rows as CSV

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