PREVIEW / etf_30min / 2020-09-09

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-09.parquet
  size:    571 KB
  rows:    21,126

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-09 04:00:00	SPY	ETF	335.45	336.83	335.36	336.22	142066.0
2020-09-09 04:30:00	SPY	ETF	336.2	336.25	335.48	335.86	20202.0
2020-09-09 05:00:00	SPY	ETF	335.7	336.05	335.23	336.05	11220.0
2020-09-09 05:30:00	SPY	ETF	336.14	336.83	335.82	336.83	22733.0
2020-09-09 06:00:00	SPY	ETF	336.77	337.01	336.09	336.12	38343.0
2020-09-09 06:30:00	SPY	ETF	336.12	336.21	335.65	335.92	114354.0
2020-09-09 07:00:00	SPY	ETF	335.93	336.01	335.15	335.83	674129.0
2020-09-09 07:30:00	SPY	ETF	335.9	336.48	335.27	336.3	399435.0
2020-09-09 08:00:00	SPY	ETF	336.3	337.08	332.0	336.6	360195.0
2020-09-09 08:30:00	SPY	ETF	336.66	336.99	336.15	336.4	442945.0
2020-09-09 09:00:00	SPY	ETF	336.35	337.85	336.29	337.55	657219.0
2020-09-09 09:30:00	SPY	ETF	337.55	338.16	336.61	338.158	10875382.0
2020-09-09 10:00:00	SPY	ETF	338.16	339.84	338.11	339.41	11001788.0
2020-09-09 10:30:00	SPY	ETF	339.41	339.87	339.0175	339.37	6006821.0
2020-09-09 11:00:00	SPY	ETF	339.39	340.3499	338.92	340.03	3666420.0
2020-09-09 11:30:00	SPY	ETF	340.03	340.56	339.8	340.25	3420234.0
2020-09-09 12:00:00	SPY	ETF	340.27	340.82	337.14	340.5677	3370565.0
2020-09-09 12:30:00	SPY	ETF	340.57	341.39	340.55	341.15	3152092.0
2020-09-09 13:00:00	SPY	ETF	341.16	342.23	341.16	341.77	4462473.0
2020-09-09 13:30:00	SPY	ETF	341.755	342.09	341.04	341.14	3974244.0
2020-09-09 14:00:00	SPY	ETF	341.1502	341.55	340.7	340.98	4055131.0
2020-09-09 14:30:00	SPY	ETF	340.98	341.99	340.98	341.68	3531669.0
2020-09-09 15:00:00	SPY	ETF	341.67	342.43	341.67	342.24	4305581.0
2020-09-09 15:30:00	SPY	ETF	342.25	342.46	339.63	339.76	16581485.0
2020-09-09 16:00:00	SPY	ETF	339.75	340.2	338.99	340.16	5801017.0
2020-09-09 16:30:00	SPY	ETF	340.14	340.14	339.58	339.62	666628.0
2020-09-09 17:00:00	SPY	ETF	339.62	339.79	339.31	339.5	174385.0
2020-09-09 17:30:00	SPY	ETF	339.49	339.6	339.44	339.5	80441.0
2020-09-09 18:00:00	SPY	ETF	339.56	340.47	339.56	340.25	291841.0
2020-09-09 18:30:00	SPY	ETF	340.25	341.0	340.19	340.84	128566.0
2020-09-09 19:00:00	SPY	ETF	340.77	341.12	340.73	340.73	205297.0
2020-09-09 19:30:00	SPY	ETF	340.74	340.99	339.87	340.9	348973.0
2020-09-09 04:00:00	QQQ	ETF	272.98	274.79	272.98	274.25	77152.0
2020-09-09 04:30:00	QQQ	ETF	274.38	274.58	273.56	274.16	36910.0
2020-09-09 05:00:00	QQQ	ETF	274.24	274.71	273.6	274.57	40302.0
2020-09-09 05:30:00	QQQ	ETF	274.62	275.28	274.02	275.28	36540.0
2020-09-09 06:00:00	QQQ	ETF	275.27	275.52	274.4	274.63	45833.0
2020-09-09 06:30:00	QQQ	ETF	274.65	274.97	274.23	274.61	105301.0
2020-09-09 07:00:00	QQQ	ETF	274.67	274.72	272.96	274.1	433835.0
2020-09-09 07:30:00	QQQ	ETF	274.1	274.34	273.05	274.12	333077.0
2020-09-09 08:00:00	QQQ	ETF	273.9001	275.07	270.05	273.53	479338.0
2020-09-09 08:30:00	QQQ	ETF	273.53	274.45	273.13	273.3	397782.0
2020-09-09 09:00:00	QQQ	ETF	273.25	275.58	273.2	275.48	620988.0
2020-09-09 09:30:00	QQQ	ETF	275.5	275.84	273.0	274.76	9773368.0
2020-09-09 10:00:00	QQQ	ETF	274.78	277.14	274.14	276.86	5634018.0
2020-09-09 10:30:00	QQQ	ETF	276.86	277.74	276.45	277.39	3588617.0
2020-09-09 11:00:00	QQQ	ETF	277.42	278.35	276.01	277.37	2877207.0
2020-09-09 11:30:00	QQQ	ETF	277.36	277.9676	276.82	277.72	1812008.0
2020-09-09 12:00:00	QQQ	ETF	277.73	278.6	277.53	278.24	1389450.0
2020-09-09 12:30:00	QQQ	ETF	278.26	279.285	278.226	279.245	1666305.0

> showing 50 of 21,126 rows — these rows as CSV

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