PREVIEW / etf_30min / 2020-08-20

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-20.parquet
  size:    544 KB
  rows:    19,934

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-08-20 04:00:00	SPY	ETF	336.54	336.54	335.07	335.27	28547.0
2020-08-20 04:30:00	SPY	ETF	335.2	336.07	335.03	336.07	16983.0
2020-08-20 05:00:00	SPY	ETF	335.91	336.15	335.82	335.82	12439.0
2020-08-20 05:30:00	SPY	ETF	336.02	336.23	335.95	336.1	8303.0
2020-08-20 06:00:00	SPY	ETF	336.13	336.59	336.08	336.41	29584.0
2020-08-20 06:30:00	SPY	ETF	336.48	336.87	336.4	336.87	15593.0
2020-08-20 07:00:00	SPY	ETF	336.76	336.83	336.41	336.48	60108.0
2020-08-20 07:30:00	SPY	ETF	336.48	336.65	336.15	336.27	78131.0
2020-08-20 08:00:00	SPY	ETF	336.5699	336.79	335.3	336.15	216099.0
2020-08-20 08:30:00	SPY	ETF	336.01	336.16	335.7	335.88	260609.0
2020-08-20 09:00:00	SPY	ETF	335.88	335.92	335.29	335.35	799540.0
2020-08-20 09:30:00	SPY	ETF	335.36	336.78	335.22	336.74	5704685.0
2020-08-20 10:00:00	SPY	ETF	336.75	337.33	336.52	337.1483	3226537.0
2020-08-20 10:30:00	SPY	ETF	337.143	337.53	336.84	337.16	2681019.0
2020-08-20 11:00:00	SPY	ETF	337.16	337.26	336.76	337.235	1950955.0
2020-08-20 11:30:00	SPY	ETF	337.23	337.82	337.09	337.69	1996980.0
2020-08-20 12:00:00	SPY	ETF	337.69	337.86	337.52	337.585	1584243.0
2020-08-20 12:30:00	SPY	ETF	337.585	337.71	337.25	337.32	1269132.0
2020-08-20 13:00:00	SPY	ETF	337.33	337.52	337.13	337.4623	1115584.0
2020-08-20 13:30:00	SPY	ETF	337.47	337.75	337.43	337.5823	1037354.0
2020-08-20 14:00:00	SPY	ETF	337.58	338.12	337.53	338.05	2159593.0
2020-08-20 14:30:00	SPY	ETF	338.04	338.24	337.885	338.22	1963840.0
2020-08-20 15:00:00	SPY	ETF	338.22	338.6135	337.77	338.028	3213572.0
2020-08-20 15:30:00	SPY	ETF	338.03	338.8	337.84	338.25	8968544.0
2020-08-20 16:00:00	SPY	ETF	338.31	338.73	338.01	338.14	1870381.0
2020-08-20 16:30:00	SPY	ETF	338.14	338.48	338.09	338.35	724707.0
2020-08-20 17:00:00	SPY	ETF	338.35	338.38	338.17	338.3	350851.0
2020-08-20 17:30:00	SPY	ETF	338.3	338.36	338.2	338.35	63778.0
2020-08-20 18:00:00	SPY	ETF	338.33	338.69	338.33	338.68	89778.0
2020-08-20 18:30:00	SPY	ETF	338.69	338.85	338.65	338.65	37395.0
2020-08-20 19:00:00	SPY	ETF	338.68	338.79	338.64	338.74	9732.0
2020-08-20 19:30:00	SPY	ETF	338.76	339.0	338.72	338.96	50118.0
2020-08-20 20:00:00	SPY	ETF	338.97	338.97	338.97	338.97	510.0
2020-08-20 04:00:00	QQQ	ETF	275.5	275.57	274.76	274.89	21633.0
2020-08-20 04:30:00	QQQ	ETF	274.86	275.57	274.86	275.56	6990.0
2020-08-20 05:00:00	QQQ	ETF	275.49	275.54	275.4	275.44	10029.0
2020-08-20 05:30:00	QQQ	ETF	275.54	276.08	275.53	275.95	16439.0
2020-08-20 06:00:00	QQQ	ETF	275.88	276.43	275.88	276.38	32691.0
2020-08-20 06:30:00	QQQ	ETF	276.35	276.57	276.23	276.52	18118.0
2020-08-20 07:00:00	QQQ	ETF	276.47	276.5	275.96	276.05	58209.0
2020-08-20 07:30:00	QQQ	ETF	276.06	276.4	276.01	276.17	42182.0
2020-08-20 08:00:00	QQQ	ETF	276.25	276.46	274.67	276.12	129990.0
2020-08-20 08:30:00	QQQ	ETF	276.06	276.11	275.62	275.79	69165.0
2020-08-20 09:00:00	QQQ	ETF	275.71	275.76	275.2204	275.29	279429.0
2020-08-20 09:30:00	QQQ	ETF	275.29	277.55	274.86	277.34	3269109.0
2020-08-20 10:00:00	QQQ	ETF	277.34	277.65	276.87	277.26	2036270.0
2020-08-20 10:30:00	QQQ	ETF	277.25	278.11	276.98	277.955	2037553.0
2020-08-20 11:00:00	QQQ	ETF	277.96	278.12	277.29	278.04	1183955.0
2020-08-20 11:30:00	QQQ	ETF	278.055	278.71	277.915	278.61	1435157.0
2020-08-20 12:00:00	QQQ	ETF	278.605	278.72	278.26	278.29	975193.0

> showing 50 of 19,934 rows — these rows as CSV

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