PREVIEW / etf_30min / 2020-03-03

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-03.parquet
  size:    608 KB
  rows:    22,036

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-03-03 04:00:00	SPY	ETF	308.71	309.47	308.18	308.76	61495.0
2020-03-03 04:30:00	SPY	ETF	308.56	310.0	308.53	309.75	60179.0
2020-03-03 05:00:00	SPY	ETF	310.09	310.1	309.19	309.83	14382.0
2020-03-03 05:30:00	SPY	ETF	309.66	309.88	309.2	309.38	44437.0
2020-03-03 06:00:00	SPY	ETF	309.52	309.52	307.57	307.91	99374.0
2020-03-03 06:30:00	SPY	ETF	307.9	308.47	307.62	307.98	184865.0
2020-03-03 07:00:00	SPY	ETF	307.8	309.1	307.7	309.03	485227.0
2020-03-03 07:30:00	SPY	ETF	309.0	309.78	305.35	306.76	1799929.0
2020-03-03 08:00:00	SPY	ETF	306.73	310.0	304.8	308.19	1285900.0
2020-03-03 08:30:00	SPY	ETF	308.19	308.5203	305.85	307.69	1546573.0
2020-03-03 09:00:00	SPY	ETF	307.71	309.7	307.24	309.49	978088.0
2020-03-03 09:30:00	SPY	ETF	309.5	309.55	304.9	305.94	19047488.0
2020-03-03 10:00:00	SPY	ETF	305.94	313.84	305.82	309.5	44393755.0
2020-03-03 10:30:00	SPY	ETF	309.5	311.19	307.0	310.42	14421995.0
2020-03-03 11:00:00	SPY	ETF	310.38	310.66	302.54	303.35	24181584.0
2020-03-03 11:30:00	SPY	ETF	303.36	307.53	303.0	307.32	17116076.0
2020-03-03 12:00:00	SPY	ETF	307.32	308.26	305.11	305.62	8922217.0
2020-03-03 12:30:00	SPY	ETF	305.62	306.73	304.57	305.12	8402156.0
2020-03-03 13:00:00	SPY	ETF	305.12	305.89	301.29	302.6399	13938415.0
2020-03-03 13:30:00	SPY	ETF	302.64	303.47	300.03	300.21	14279283.0
2020-03-03 14:00:00	SPY	ETF	300.19	300.96	297.57	300.34	28659629.0
2020-03-03 14:30:00	SPY	ETF	300.3364	303.0	298.41	301.35	18859464.0
2020-03-03 15:00:00	SPY	ETF	301.37	304.24	300.81	304.14	20038781.0
2020-03-03 15:30:00	SPY	ETF	304.12	304.14	299.29	300.34	39269083.0
2020-03-03 16:00:00	SPY	ETF	300.37	302.07	299.57	300.0	16072961.0
2020-03-03 16:30:00	SPY	ETF	300.08	300.46	299.24	299.24	1300294.0
2020-03-03 17:00:00	SPY	ETF	299.24	300.24	298.9	299.22	1086797.0
2020-03-03 17:30:00	SPY	ETF	299.21	299.22	298.8	298.94	137560.0
2020-03-03 18:00:00	SPY	ETF	298.95	299.78	298.0	299.22	254167.0
2020-03-03 18:30:00	SPY	ETF	299.11	309.0078	298.51	299.34	282713.0
2020-03-03 19:00:00	SPY	ETF	299.29	301.5	299.29	300.97	376347.0
2020-03-03 19:30:00	SPY	ETF	301.1	303.0	301.1	302.17	362876.0
2020-03-03 04:00:00	QQQ	ETF	216.24	216.84	215.8	216.3	58099.0
2020-03-03 04:30:00	QQQ	ETF	216.16	217.2	216.03	217.05	68509.0
2020-03-03 05:00:00	QQQ	ETF	216.93	217.3	216.59	217.15	35129.0
2020-03-03 05:30:00	QQQ	ETF	217.11	217.27	216.74	217.16	62064.0
2020-03-03 06:00:00	QQQ	ETF	216.99	217.0	215.64	215.8	133879.0
2020-03-03 06:30:00	QQQ	ETF	215.99	216.26	215.64	216.05	166226.0
2020-03-03 07:00:00	QQQ	ETF	215.89	216.99	215.83	216.9	327841.0
2020-03-03 07:30:00	QQQ	ETF	216.91	217.5	214.5	215.43	1049298.0
2020-03-03 08:00:00	QQQ	ETF	215.39	217.13	213.2	216.29	807032.0
2020-03-03 08:30:00	QQQ	ETF	216.17	216.71	215.02	215.87	1056365.0
2020-03-03 09:00:00	QQQ	ETF	215.78	217.29	215.52	217.17	1490937.0
2020-03-03 09:30:00	QQQ	ETF	217.12	217.16	213.3	214.1309	10946890.0
2020-03-03 10:00:00	QQQ	ETF	214.14	219.61	214.06	217.09	16889499.0
2020-03-03 10:30:00	QQQ	ETF	217.08	218.37	216.49	217.83	7606013.0
2020-03-03 11:00:00	QQQ	ETF	217.8	217.99	212.32	212.69	8569100.0
2020-03-03 11:30:00	QQQ	ETF	212.67	215.61	212.5	215.46	5120844.0
2020-03-03 12:00:00	QQQ	ETF	215.43	216.18	213.81	214.08	4517116.0
2020-03-03 12:30:00	QQQ	ETF	214.08	215.06	213.36	213.78	3933701.0

> showing 50 of 22,036 rows — these rows as CSV

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