PREVIEW / etf_30min / 2020-10-05

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-05.parquet
  size:    564 KB
  rows:    20,949

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-10-05 04:00:00	SPY	ETF	335.19	335.77	335.02	335.5	50382.0
2020-10-05 04:30:00	SPY	ETF	335.53	335.75	335.45	335.68	12338.0
2020-10-05 05:00:00	SPY	ETF	335.41	335.83	335.41	335.74	4425.0
2020-10-05 05:30:00	SPY	ETF	335.65	336.13	335.63	336.13	21501.0
2020-10-05 06:00:00	SPY	ETF	336.03	336.03	335.65	335.73	7775.0
2020-10-05 06:30:00	SPY	ETF	335.8	336.3	335.8	336.3	25468.0
2020-10-05 07:00:00	SPY	ETF	336.31	336.67	336.05	336.17	133835.0
2020-10-05 07:30:00	SPY	ETF	336.18	336.48	336.1	336.1	125093.0
2020-10-05 08:00:00	SPY	ETF	335.9796	336.65	335.2	335.97	95990.0
2020-10-05 08:30:00	SPY	ETF	335.94	336.16	335.84	336.05	200770.0
2020-10-05 09:00:00	SPY	ETF	336.06	336.31	336.0	336.05	166720.0
2020-10-05 09:30:00	SPY	ETF	336.06	337.23	336.01	336.58	4343947.0
2020-10-05 10:00:00	SPY	ETF	336.59	337.835	336.58	337.65	2836817.0
2020-10-05 10:30:00	SPY	ETF	337.66	338.57	337.66	338.255	3150261.0
2020-10-05 11:00:00	SPY	ETF	338.25	338.87	338.17	338.54	3116266.0
2020-10-05 11:30:00	SPY	ETF	338.53	338.57	338.16	338.4259	1547408.0
2020-10-05 12:00:00	SPY	ETF	338.44	338.61	338.245	338.57	919813.0
2020-10-05 12:30:00	SPY	ETF	338.57	338.695	338.43	338.6199	1266102.0
2020-10-05 13:00:00	SPY	ETF	338.62	338.76	338.22	338.465	1276976.0
2020-10-05 13:30:00	SPY	ETF	338.46	338.48	337.72	337.845	2325173.0
2020-10-05 14:00:00	SPY	ETF	337.85	338.2381	337.51	337.975	2419771.0
2020-10-05 14:30:00	SPY	ETF	337.98	339.19	337.98	339.17	2984040.0
2020-10-05 15:00:00	SPY	ETF	339.16	339.94	338.93	339.85	3563267.0
2020-10-05 15:30:00	SPY	ETF	339.87	339.96	339.39	339.73	10148611.0
2020-10-05 16:00:00	SPY	ETF	339.72	339.8177	339.2	339.22	3122239.0
2020-10-05 16:30:00	SPY	ETF	339.24	339.76	339.2	339.24	230711.0
2020-10-05 17:00:00	SPY	ETF	339.35	339.76	339.11	339.29	47217.0
2020-10-05 17:30:00	SPY	ETF	339.32	339.33	339.2	339.25	59460.0
2020-10-05 18:00:00	SPY	ETF	339.25	339.57	339.25	339.5	40372.0
2020-10-05 18:30:00	SPY	ETF	339.5	339.67	339.5	339.53	41324.0
2020-10-05 19:00:00	SPY	ETF	339.59	339.59	338.7	339.22	102604.0
2020-10-05 19:30:00	SPY	ETF	339.17	339.2	338.72	338.84	48912.0
2020-10-05 04:00:00	QQQ	ETF	275.47	276.39	275.47	276.2	263316.0
2020-10-05 04:30:00	QQQ	ETF	276.2	276.5	276.04	276.28	212202.0
2020-10-05 05:00:00	QQQ	ETF	276.08	276.46	276.04	276.45	61093.0
2020-10-05 05:30:00	QQQ	ETF	276.21	276.8	276.16	276.8	25204.0
2020-10-05 06:00:00	QQQ	ETF	276.8	277.0	276.5	276.57	15690.0
2020-10-05 06:30:00	QQQ	ETF	276.5	277.12	276.5	277.12	36708.0
2020-10-05 07:00:00	QQQ	ETF	277.11	277.17	276.33	276.47	160831.0
2020-10-05 07:30:00	QQQ	ETF	276.49	276.74	276.23	276.26	69223.0
2020-10-05 08:00:00	QQQ	ETF	277.0002	277.1399	275.56	275.99	165426.0
2020-10-05 08:30:00	QQQ	ETF	275.97	276.33	275.73	276.06	114526.0
2020-10-05 09:00:00	QQQ	ETF	276.08	276.42	276.04	276.35	188455.0
2020-10-05 09:30:00	QQQ	ETF	276.33	277.46	276.23	277.315	3279810.0
2020-10-05 10:00:00	QQQ	ETF	277.32	278.55	277.315	278.31	1995850.0
2020-10-05 10:30:00	QQQ	ETF	278.33	278.99	278.3	278.42	1601469.0
2020-10-05 11:00:00	QQQ	ETF	278.42	279.07	278.15	278.88	1261893.0
2020-10-05 11:30:00	QQQ	ETF	278.88	278.96	278.26	278.8001	1008593.0
2020-10-05 12:00:00	QQQ	ETF	278.81	279.3	278.56	279.27	875311.0
2020-10-05 12:30:00	QQQ	ETF	279.261	279.32	278.9	279.25	725973.0

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

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