PREVIEW / etf_30min / 2020-02-12

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-12.parquet
  size:    543 KB
  rows:    19,290

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-12 04:00:00	SPY	ETF	336.63	336.73	336.35	336.4	31429.0
2020-02-12 04:30:00	SPY	ETF	336.42	336.5	336.3	336.49	14025.0
2020-02-12 05:00:00	SPY	ETF	336.49	336.49	336.44	336.46	5318.0
2020-02-12 05:30:00	SPY	ETF	336.42	336.68	336.3	336.68	11274.0
2020-02-12 06:00:00	SPY	ETF	336.62	336.71	336.56	336.64	37653.0
2020-02-12 06:30:00	SPY	ETF	336.67	336.7	336.58	336.58	37645.0
2020-02-12 07:00:00	SPY	ETF	336.61	336.67	336.43	336.6	55742.0
2020-02-12 07:30:00	SPY	ETF	336.58	336.6	336.33	336.46	105139.0
2020-02-12 08:00:00	SPY	ETF	336.45	336.77	335.26	336.7	215471.0
2020-02-12 08:30:00	SPY	ETF	336.7	336.83	336.5702	336.69	75960.0
2020-02-12 09:00:00	SPY	ETF	336.74	336.98	336.7	336.83	298501.0
2020-02-12 09:30:00	SPY	ETF	336.83	337.28	336.6124	337.0	5549486.0
2020-02-12 10:00:00	SPY	ETF	337.01	337.2	336.43	336.82	2858462.0
2020-02-12 10:30:00	SPY	ETF	336.81	337.0	336.5	336.5763	2159052.0
2020-02-12 11:00:00	SPY	ETF	336.58	337.16	336.58	337.14	2097631.0
2020-02-12 11:30:00	SPY	ETF	337.145	337.2	336.86	336.99	1470618.0
2020-02-12 12:00:00	SPY	ETF	337.0	337.12	336.8	337.0364	1296583.0
2020-02-12 12:30:00	SPY	ETF	337.03	337.23	336.91	337.0	1809477.0
2020-02-12 13:00:00	SPY	ETF	337.0	337.05	336.53	336.76	3421829.0
2020-02-12 13:30:00	SPY	ETF	336.76	337.01	336.72	336.99	1588658.0
2020-02-12 14:00:00	SPY	ETF	336.99	337.17	336.93	337.0	1166421.0
2020-02-12 14:30:00	SPY	ETF	337.01	337.32	337.0	337.2	3649704.0
2020-02-12 15:00:00	SPY	ETF	337.19	337.39	336.92	337.2	2019583.0
2020-02-12 15:30:00	SPY	ETF	337.2	337.65	337.06	337.41	5906916.0
2020-02-12 16:00:00	SPY	ETF	337.42	337.64	337.053	337.54	4606697.0
2020-02-12 16:30:00	SPY	ETF	337.54	337.69	335.2577	337.63	1380990.0
2020-02-12 17:00:00	SPY	ETF	337.58	337.58	337.47	337.55	52954.0
2020-02-12 17:30:00	SPY	ETF	337.55	337.6	337.51	337.57	56431.0
2020-02-12 18:00:00	SPY	ETF	337.57	337.7	337.53	337.7	484406.0
2020-02-12 18:30:00	SPY	ETF	337.69	337.77	335.95	336.18	496233.0
2020-02-12 19:00:00	SPY	ETF	336.24	336.77	336.08	336.45	97693.0
2020-02-12 19:30:00	SPY	ETF	336.35	336.57	336.18	336.43	68254.0
2020-02-12 04:00:00	QQQ	ETF	233.07	233.26	233.07	233.1	23099.0
2020-02-12 04:30:00	QQQ	ETF	233.11	233.21	233.06	233.2	17365.0
2020-02-12 05:00:00	QQQ	ETF	233.13	233.17	233.06	233.12	3600.0
2020-02-12 05:30:00	QQQ	ETF	233.12	233.22	233.03	233.22	9168.0
2020-02-12 06:00:00	QQQ	ETF	233.25	233.38	233.2	233.27	19423.0
2020-02-12 06:30:00	QQQ	ETF	233.32	233.35	233.24	233.29	14510.0
2020-02-12 07:00:00	QQQ	ETF	233.28	233.3	233.13	233.22	46206.0
2020-02-12 07:30:00	QQQ	ETF	233.24	233.25	232.92	233.06	154578.0
2020-02-12 08:00:00	QQQ	ETF	233.07	233.35	232.0	233.17	137588.0
2020-02-12 08:30:00	QQQ	ETF	233.2	233.33	233.08	233.21	83116.0
2020-02-12 09:00:00	QQQ	ETF	233.23	233.4498	233.23	233.32	178140.0
2020-02-12 09:30:00	QQQ	ETF	233.34	233.875	232.84	233.35	3512526.0
2020-02-12 10:00:00	QQQ	ETF	233.36	233.56	232.8	233.17	2495878.0
2020-02-12 10:30:00	QQQ	ETF	233.17	233.31	232.91	233.12	1248317.0
2020-02-12 11:00:00	QQQ	ETF	233.1479	233.99	233.12	233.91	1015283.0
2020-02-12 11:30:00	QQQ	ETF	233.92	234.06	233.66	233.83	952081.0
2020-02-12 12:00:00	QQQ	ETF	233.837	234.04	233.68	234.0	503876.0
2020-02-12 12:30:00	QQQ	ETF	234.0014	234.26	233.91	234.138	914102.0

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

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