PREVIEW / etf_30min / 2020-11-23

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-23.parquet
  size:    589 KB
  rows:    22,179

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-11-23 04:00:00	SPY	ETF	357.74	357.94	357.5	357.8	30560.0
2020-11-23 04:30:00	SPY	ETF	357.72	357.76	357.29	357.76	12440.0
2020-11-23 05:00:00	SPY	ETF	357.67	357.73	357.57	357.7	2691.0
2020-11-23 05:30:00	SPY	ETF	357.59	357.68	357.45	357.49	5334.0
2020-11-23 06:00:00	SPY	ETF	357.58	357.59	357.34	357.34	18112.0
2020-11-23 06:30:00	SPY	ETF	357.28	357.28	357.13	357.27	59846.0
2020-11-23 07:00:00	SPY	ETF	357.3	357.66	356.88	357.65	103946.0
2020-11-23 07:30:00	SPY	ETF	357.68	357.78	357.56	357.6	144535.0
2020-11-23 08:00:00	SPY	ETF	357.25	357.7604	356.4	357.44	156637.0
2020-11-23 08:30:00	SPY	ETF	357.39	357.82	355.92	356.95	436963.0
2020-11-23 09:00:00	SPY	ETF	356.93	357.25	356.64	357.24	127326.0
2020-11-23 09:30:00	SPY	ETF	357.28	358.82	357.25	358.15	4685973.0
2020-11-23 10:00:00	SPY	ETF	358.14	358.26	356.0	356.085	4336274.0
2020-11-23 10:30:00	SPY	ETF	356.09	357.28	355.89	357.091	3002952.0
2020-11-23 11:00:00	SPY	ETF	357.09	357.22	355.27	355.64	4235240.0
2020-11-23 11:30:00	SPY	ETF	355.635	356.0	354.865	355.78	3398229.0
2020-11-23 12:00:00	SPY	ETF	355.775	356.29	355.19	356.05	3362378.0
2020-11-23 12:30:00	SPY	ETF	356.06	356.66	356.0	356.65	4715915.0
2020-11-23 13:00:00	SPY	ETF	356.655	356.94	356.53	356.62	2248530.0
2020-11-23 13:30:00	SPY	ETF	356.63	357.02	356.4	356.76	1798357.0
2020-11-23 14:00:00	SPY	ETF	356.77	356.89	356.22	356.495	2923621.0
2020-11-23 14:30:00	SPY	ETF	356.495	357.63	356.446	357.62	2057122.0
2020-11-23 15:00:00	SPY	ETF	357.62	358.37	357.5421	357.715	4409440.0
2020-11-23 15:30:00	SPY	ETF	357.72	357.95	356.9802	357.47	8985421.0
2020-11-23 16:00:00	SPY	ETF	357.5	357.6	357.26	357.48	8450836.0
2020-11-23 16:30:00	SPY	ETF	357.48	357.57	357.35	357.53	1553204.0
2020-11-23 17:00:00	SPY	ETF	357.36	357.65	357.36	357.64	16729.0
2020-11-23 17:30:00	SPY	ETF	357.65	357.8	357.59	357.75	32459.0
2020-11-23 18:00:00	SPY	ETF	357.75	359.63	357.6	359.51	270870.0
2020-11-23 18:30:00	SPY	ETF	359.49	359.64	358.74	359.1	149274.0
2020-11-23 19:00:00	SPY	ETF	359.14	359.38	357.46	359.26	158597.0
2020-11-23 19:30:00	SPY	ETF	359.27	359.41	359.11	359.16	49904.0
2020-11-23 04:00:00	QQQ	ETF	291.65	291.9	291.54	291.72	19780.0
2020-11-23 04:30:00	QQQ	ETF	291.75	291.77	291.51	291.68	9763.0
2020-11-23 05:00:00	QQQ	ETF	291.61	291.65	291.49	291.51	5153.0
2020-11-23 05:30:00	QQQ	ETF	291.43	291.63	291.43	291.51	14030.0
2020-11-23 06:00:00	QQQ	ETF	291.43	291.5	291.27	291.38	29726.0
2020-11-23 06:30:00	QQQ	ETF	291.35	291.45	291.34	291.45	54471.0
2020-11-23 07:00:00	QQQ	ETF	291.45	291.45	291.12	291.44	38879.0
2020-11-23 07:30:00	QQQ	ETF	291.46	291.64	291.38	291.56	34586.0
2020-11-23 08:00:00	QQQ	ETF	291.38	291.84	291.2501	291.4	133168.0
2020-11-23 08:30:00	QQQ	ETF	291.33	291.65	290.7	291.37	186840.0
2020-11-23 09:00:00	QQQ	ETF	291.342	291.62	291.24	291.46	63371.0
2020-11-23 09:30:00	QQQ	ETF	291.41	292.75	291.41	292.06	2446268.0
2020-11-23 10:00:00	QQQ	ETF	292.07	292.25	289.59	289.86	2297621.0
2020-11-23 10:30:00	QQQ	ETF	289.88	290.75	289.67	290.52	1721075.0
2020-11-23 11:00:00	QQQ	ETF	290.52	290.6	288.1301	288.64	2542076.0
2020-11-23 11:30:00	QQQ	ETF	288.61	289.24	288.07	289.0	1402299.0
2020-11-23 12:00:00	QQQ	ETF	288.96	289.73	288.48	289.62	934300.0
2020-11-23 12:30:00	QQQ	ETF	289.63	290.1302	289.485	290.11	609313.0

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

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