PREVIEW / etf_30min / 2019-10-15

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-15.parquet
  size:    506 KB
  rows:    17,628

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
2019-10-15 04:00:00	SPY	ETF	297.32	297.43	297.2	297.32	9171.0
2019-10-15 04:30:00	SPY	ETF	297.5	297.62	297.05	297.05	9922.0
2019-10-15 05:00:00	SPY	ETF	297.03	297.18	297.03	297.13	1300.0
2019-10-15 05:30:00	SPY	ETF	297.18	297.29	297.11	297.29	2826.0
2019-10-15 06:00:00	SPY	ETF	297.28	297.38	296.56	296.61	23618.0
2019-10-15 06:30:00	SPY	ETF	296.67	296.99	296.64	296.9	24127.0
2019-10-15 07:00:00	SPY	ETF	296.85	297.17	296.8	297.03	30238.0
2019-10-15 07:30:00	SPY	ETF	297.03	297.24	296.68	296.86	102049.0
2019-10-15 08:00:00	SPY	ETF	296.86	297.6	296.65	296.89	106612.0
2019-10-15 08:30:00	SPY	ETF	296.86	296.94	296.77	296.83	58917.0
2019-10-15 09:00:00	SPY	ETF	296.82	297.15	296.79	297.09	206515.0
2019-10-15 09:30:00	SPY	ETF	297.1	297.5763	296.97	297.41	4044968.0
2019-10-15 10:00:00	SPY	ETF	297.42	298.61	297.41	298.415	4143656.0
2019-10-15 10:30:00	SPY	ETF	298.415	299.445	298.38	299.44	5588350.0
2019-10-15 11:00:00	SPY	ETF	299.45	299.6	298.87	299.25	4477676.0
2019-10-15 11:30:00	SPY	ETF	299.24	299.28	298.87	299.22	2438282.0
2019-10-15 12:00:00	SPY	ETF	299.24	299.39	299.01	299.09	1737781.0
2019-10-15 12:30:00	SPY	ETF	299.085	299.39	299.07	299.37	1900707.0
2019-10-15 13:00:00	SPY	ETF	299.38	299.46	299.1	299.23	2036668.0
2019-10-15 13:30:00	SPY	ETF	299.22	299.62	299.19	299.48	1635165.0
2019-10-15 14:00:00	SPY	ETF	299.475	299.7	299.33	299.565	1676271.0
2019-10-15 14:30:00	SPY	ETF	299.5651	299.6	299.16	299.29	1606281.0
2019-10-15 15:00:00	SPY	ETF	299.29	299.41	299.0	299.4	2494880.0
2019-10-15 15:30:00	SPY	ETF	299.41	299.43	298.87	298.9	7342045.0
2019-10-15 16:00:00	SPY	ETF	298.91	299.21	298.82	299.17	4096748.0
2019-10-15 16:30:00	SPY	ETF	299.17	299.2	298.97	299.1	148367.0
2019-10-15 17:00:00	SPY	ETF	299.1	299.16	298.88	299.14	350997.0
2019-10-15 17:30:00	SPY	ETF	299.17	299.19	298.88	299.12	42183.0
2019-10-15 18:00:00	SPY	ETF	299.11	299.11	298.85	299.04	64597.0
2019-10-15 18:30:00	SPY	ETF	299.05	299.13	298.95	298.95	10821.0
2019-10-15 19:00:00	SPY	ETF	298.91	298.93	298.75	298.8	16135.0
2019-10-15 19:30:00	SPY	ETF	298.8	298.89	298.76	298.88	29851.0
2019-10-15 04:00:00	QQQ	ETF	192.13	192.17	192.03	192.14	3397.0
2019-10-15 04:30:00	QQQ	ETF	192.2	192.4	191.91	191.95	10460.0
2019-10-15 05:00:00	QQQ	ETF	191.95	192.15	191.95	192.02	1100.0
2019-10-15 05:30:00	QQQ	ETF	192.07	192.13	192.03	192.13	4936.0
2019-10-15 06:00:00	QQQ	ETF	192.18	192.2	191.64	191.68	15675.0
2019-10-15 06:30:00	QQQ	ETF	191.68	191.88	191.65	191.77	41150.0
2019-10-15 07:00:00	QQQ	ETF	191.72	191.81	191.53	191.75	35833.0
2019-10-15 07:30:00	QQQ	ETF	191.73	191.86	191.49	191.66	71357.0
2019-10-15 08:00:00	QQQ	ETF	191.67	192.36	191.55	191.75	41938.0
2019-10-15 08:30:00	QQQ	ETF	191.75	191.81	191.62	191.65	40096.0
2019-10-15 09:00:00	QQQ	ETF	191.64	191.8	191.6	191.63	138901.0
2019-10-15 09:30:00	QQQ	ETF	191.65	192.3	191.56	192.11	2783112.0
2019-10-15 10:00:00	QQQ	ETF	192.12	192.92	192.11	192.78	1672099.0
2019-10-15 10:30:00	QQQ	ETF	192.8	193.54	192.73	193.54	2610856.0
2019-10-15 11:00:00	QQQ	ETF	193.54	193.63	193.08	193.345	1817508.0
2019-10-15 11:30:00	QQQ	ETF	193.34	193.43	193.02	193.4	1199423.0
2019-10-15 12:00:00	QQQ	ETF	193.41	193.55	193.23	193.27	753892.0
2019-10-15 12:30:00	QQQ	ETF	193.265	193.5	193.26	193.47	458061.0

> showing 50 of 17,628 rows — these rows as CSV

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