PREVIEW / etf_30min / 2020-02-11

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-11.parquet
  size:    540 KB
  rows:    18,996

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-02-11 04:00:00	SPY	ETF	335.48	335.55	335.1	335.37	7255.0
2020-02-11 04:30:00	SPY	ETF	335.37	335.45	335.2	335.44	6855.0
2020-02-11 05:00:00	SPY	ETF	335.5	335.63	335.5	335.63	5109.0
2020-02-11 05:30:00	SPY	ETF	335.64	335.75	335.63	335.7	11688.0
2020-02-11 06:00:00	SPY	ETF	335.7	335.73	335.51	335.52	5387.0
2020-02-11 06:30:00	SPY	ETF	335.51	335.64	335.43	335.47	35647.0
2020-02-11 07:00:00	SPY	ETF	335.44	335.8	335.44	335.77	47110.0
2020-02-11 07:30:00	SPY	ETF	335.84	335.94	335.78	335.84	54962.0
2020-02-11 08:00:00	SPY	ETF	335.53	335.96	335.4501	335.94	71986.0
2020-02-11 08:30:00	SPY	ETF	335.92	336.04	335.63	336.01	135457.0
2020-02-11 09:00:00	SPY	ETF	336.0	336.26	335.92	336.14	203552.0
2020-02-11 09:30:00	SPY	ETF	336.16	336.29	335.51	336.0114	5730556.0
2020-02-11 10:00:00	SPY	ETF	336.01	336.97	336.01	336.89	5471732.0
2020-02-11 10:30:00	SPY	ETF	336.9	337.02	336.44	336.55	6780421.0
2020-02-11 11:00:00	SPY	ETF	336.555	336.71	336.23	336.28	3419069.0
2020-02-11 11:30:00	SPY	ETF	336.285	336.3	335.62	335.8583	3803691.0
2020-02-11 12:00:00	SPY	ETF	335.85	336.23	335.76	336.1054	1656922.0
2020-02-11 12:30:00	SPY	ETF	336.11	336.3	335.99	336.29	1212365.0
2020-02-11 13:00:00	SPY	ETF	336.28	336.48	336.12	336.21	1443981.0
2020-02-11 13:30:00	SPY	ETF	336.21	336.33	335.62	335.87	2247338.0
2020-02-11 14:00:00	SPY	ETF	335.87	335.9241	335.29	335.59	2776221.0
2020-02-11 14:30:00	SPY	ETF	335.59	335.91	335.43	335.5	3579831.0
2020-02-11 15:00:00	SPY	ETF	335.51	335.685	334.75	335.31	5081682.0
2020-02-11 15:30:00	SPY	ETF	335.31	335.59	335.01	335.29	5683288.0
2020-02-11 16:00:00	SPY	ETF	335.29	335.48	335.19	335.28	3233310.0
2020-02-11 16:30:00	SPY	ETF	335.28	335.5	335.26	335.45	1266513.0
2020-02-11 17:00:00	SPY	ETF	335.43	335.5	335.36	335.49	84832.0
2020-02-11 17:30:00	SPY	ETF	335.44	335.54	335.44	335.53	13116.0
2020-02-11 18:00:00	SPY	ETF	335.58	335.75	335.48	335.67	28026.0
2020-02-11 18:30:00	SPY	ETF	335.67	335.82	335.59	335.66	13072.0
2020-02-11 19:00:00	SPY	ETF	335.64	335.76	335.4	335.47	21324.0
2020-02-11 19:30:00	SPY	ETF	335.44	335.44	335.13	335.35	26105.0
2020-02-11 04:00:00	QQQ	ETF	232.8	232.83	232.52	232.67	24110.0
2020-02-11 04:30:00	QQQ	ETF	232.65	232.77	232.61	232.77	6156.0
2020-02-11 05:00:00	QQQ	ETF	232.78	232.96	232.78	232.88	18895.0
2020-02-11 05:30:00	QQQ	ETF	232.92	233.05	232.9	232.96	18404.0
2020-02-11 06:00:00	QQQ	ETF	232.99	233.02	232.84	232.84	8563.0
2020-02-11 06:30:00	QQQ	ETF	232.83	232.85	232.69	232.69	16170.0
2020-02-11 07:00:00	QQQ	ETF	232.72	233.16	232.72	233.14	51607.0
2020-02-11 07:30:00	QQQ	ETF	233.14	233.16	232.97	233.06	39072.0
2020-02-11 08:00:00	QQQ	ETF	232.78	233.14	231.97	233.07	83375.0
2020-02-11 08:30:00	QQQ	ETF	233.05	233.21	232.84	233.18	132851.0
2020-02-11 09:00:00	QQQ	ETF	233.16	233.37	233.08	233.21	136231.0
2020-02-11 09:30:00	QQQ	ETF	233.21	233.3351	232.3	232.77	3145865.0
2020-02-11 10:00:00	QQQ	ETF	232.7701	233.73	232.7701	233.69	2447303.0
2020-02-11 10:30:00	QQQ	ETF	233.69	234.02	233.6	233.78	1728775.0
2020-02-11 11:00:00	QQQ	ETF	233.75	233.98	233.63	233.66	979798.0
2020-02-11 11:30:00	QQQ	ETF	233.665	233.6899	232.65	232.8101	2525255.0
2020-02-11 12:00:00	QQQ	ETF	232.81	233.22	232.73	233.01	1078357.0
2020-02-11 12:30:00	QQQ	ETF	233.01	233.29	232.8801	233.29	825482.0

> showing 50 of 18,996 rows — these rows as CSV

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