PREVIEW / etf_30min / 2020-02-07

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-07.parquet
  size:    537 KB
  rows:    19,068

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-07 04:00:00	SPY	ETF	333.78	333.81	333.57	333.57	31541.0
2020-02-07 04:30:00	SPY	ETF	333.4	333.64	333.08	333.08	11671.0
2020-02-07 05:00:00	SPY	ETF	333.15	333.15	332.71	332.94	8954.0
2020-02-07 05:30:00	SPY	ETF	332.9	332.91	332.56	332.56	11236.0
2020-02-07 06:00:00	SPY	ETF	332.5	332.97	332.34	332.85	14267.0
2020-02-07 06:30:00	SPY	ETF	332.82	332.96	332.71	332.96	27126.0
2020-02-07 07:00:00	SPY	ETF	333.0	333.26	332.93	333.07	60215.0
2020-02-07 07:30:00	SPY	ETF	333.12	333.28	333.07	333.28	46390.0
2020-02-07 08:00:00	SPY	ETF	333.18	334.2	332.95	333.54	241014.0
2020-02-07 08:30:00	SPY	ETF	333.65	334.0	332.56	332.87	1076540.0
2020-02-07 09:00:00	SPY	ETF	332.83	333.1	332.6	332.77	379258.0
2020-02-07 09:30:00	SPY	ETF	332.82	333.0	331.96	332.29	6404457.0
2020-02-07 10:00:00	SPY	ETF	332.29	333.0	331.93	332.955	3725713.0
2020-02-07 10:30:00	SPY	ETF	332.95	333.9941	332.71	332.83	3370239.0
2020-02-07 11:00:00	SPY	ETF	332.84	333.4	332.6	333.33	3193213.0
2020-02-07 11:30:00	SPY	ETF	333.32	333.62	332.91	333.18	2357636.0
2020-02-07 12:00:00	SPY	ETF	333.19	333.49	333.05	333.43	2952318.0
2020-02-07 12:30:00	SPY	ETF	333.43	333.4439	333.02	333.21	3083506.0
2020-02-07 13:00:00	SPY	ETF	333.21	333.21	332.91	333.11	1372035.0
2020-02-07 13:30:00	SPY	ETF	333.11	333.18	332.27	332.27	4083140.0
2020-02-07 14:00:00	SPY	ETF	332.28	332.28	331.6	332.0	6064491.0
2020-02-07 14:30:00	SPY	ETF	332.0	332.41	331.97	332.35	3467934.0
2020-02-07 15:00:00	SPY	ETF	332.36	332.53	332.055	332.24	3295154.0
2020-02-07 15:30:00	SPY	ETF	332.245	332.64	331.83	332.2	8365905.0
2020-02-07 16:00:00	SPY	ETF	332.21	332.33	331.95	332.11	6590144.0
2020-02-07 16:30:00	SPY	ETF	332.11	332.2	331.86	331.87	829909.0
2020-02-07 17:00:00	SPY	ETF	332.03	332.09	331.71	331.9	1659929.0
2020-02-07 17:30:00	SPY	ETF	331.89	331.89	331.6	331.77	107467.0
2020-02-07 18:00:00	SPY	ETF	331.73	331.79	331.6	331.6999	16097.0
2020-02-07 18:30:00	SPY	ETF	331.7	331.74	331.55	331.62	22862.0
2020-02-07 19:00:00	SPY	ETF	331.69	331.73	331.6	331.63	10373.0
2020-02-07 19:30:00	SPY	ETF	331.64	331.76	331.61	331.68	11775.0
2020-02-07 04:00:00	QQQ	ETF	229.97	230.0	229.74	229.74	33520.0
2020-02-07 04:30:00	QQQ	ETF	229.68	229.83	229.34	229.36	26408.0
2020-02-07 05:00:00	QQQ	ETF	229.43	229.43	229.0	229.21	68187.0
2020-02-07 05:30:00	QQQ	ETF	229.2	229.23	228.94	228.99	15995.0
2020-02-07 06:00:00	QQQ	ETF	228.95	229.37	228.8	229.23	50253.0
2020-02-07 06:30:00	QQQ	ETF	229.18	229.4	229.17	229.38	10972.0
2020-02-07 07:00:00	QQQ	ETF	229.38	229.63	229.35	229.47	60311.0
2020-02-07 07:30:00	QQQ	ETF	229.52	229.62	229.38	229.57	41322.0
2020-02-07 08:00:00	QQQ	ETF	229.42	230.37	229.36	229.75	73195.0
2020-02-07 08:30:00	QQQ	ETF	229.81	230.19	228.96	229.22	644138.0
2020-02-07 09:00:00	QQQ	ETF	229.2	229.4	229.0	229.15	117586.0
2020-02-07 09:30:00	QQQ	ETF	229.16	229.48	228.54	228.87	2822972.0
2020-02-07 10:00:00	QQQ	ETF	228.87	229.47	228.61	229.3975	2171663.0
2020-02-07 10:30:00	QQQ	ETF	229.39	229.86	229.39	229.58	1151339.0
2020-02-07 11:00:00	QQQ	ETF	229.5899	230.1786	229.36	230.15	1096221.0
2020-02-07 11:30:00	QQQ	ETF	230.14	230.44	229.93	230.16	1305664.0
2020-02-07 12:00:00	QQQ	ETF	230.16	230.42	230.0301	230.37	717331.0
2020-02-07 12:30:00	QQQ	ETF	230.37	230.37	230.035	230.1798	432570.0

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

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