PREVIEW / etf_30min / 2019-09-12

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-12.parquet
  size:    523 KB
  rows:    18,149

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-09-12 04:00:00	SPY	ETF	301.15	301.22	301.02	301.15	3624.0
2019-09-12 04:30:00	SPY	ETF	301.19	301.19	300.95	300.95	6628.0
2019-09-12 05:00:00	SPY	ETF	301.04	301.05	300.98	300.98	3655.0
2019-09-12 05:30:00	SPY	ETF	300.94	300.94	300.89	300.93	4025.0
2019-09-12 06:00:00	SPY	ETF	300.98	301.02	300.78	300.78	52695.0
2019-09-12 06:30:00	SPY	ETF	300.93	300.95	300.78	300.78	14665.0
2019-09-12 07:00:00	SPY	ETF	300.82	301.0	300.79	300.93	117661.0
2019-09-12 07:30:00	SPY	ETF	300.9	301.57	300.54	301.25	824002.0
2019-09-12 08:00:00	SPY	ETF	300.8499	301.84	300.79	301.12	542723.0
2019-09-12 08:30:00	SPY	ETF	301.02	301.43	301.0	301.22	389105.0
2019-09-12 09:00:00	SPY	ETF	301.23	301.41	301.1	301.25	283145.0
2019-09-12 09:30:00	SPY	ETF	301.25	301.66	300.41	300.89	9320979.0
2019-09-12 10:00:00	SPY	ETF	300.91	302.37	300.67	302.0	9677610.0
2019-09-12 10:30:00	SPY	ETF	302.02	302.15	300.46	300.84	9133607.0
2019-09-12 11:00:00	SPY	ETF	300.84	301.62	300.63	301.48	4062681.0
2019-09-12 11:30:00	SPY	ETF	301.49	301.85	301.39	301.79	2997255.0
2019-09-12 12:00:00	SPY	ETF	301.78	301.84	301.45	301.73	2914629.0
2019-09-12 12:30:00	SPY	ETF	301.735	302.11	301.69	302.05	2202660.0
2019-09-12 13:00:00	SPY	ETF	302.05	302.46	301.9802	302.07	2688877.0
2019-09-12 13:30:00	SPY	ETF	302.07	302.37	302.03	302.18	2412846.0
2019-09-12 14:00:00	SPY	ETF	302.19	302.23	301.87	302.03	4505827.0
2019-09-12 14:30:00	SPY	ETF	302.03	302.42	301.94	302.15	2494108.0
2019-09-12 15:00:00	SPY	ETF	302.15	302.2	301.88	301.9	3544946.0
2019-09-12 15:30:00	SPY	ETF	301.91	302.09	301.13	301.27	8651219.0
2019-09-12 16:00:00	SPY	ETF	301.27	301.55	301.2647	301.35	3406547.0
2019-09-12 16:30:00	SPY	ETF	301.36	301.45	301.11	301.15	154438.0
2019-09-12 17:00:00	SPY	ETF	301.28	301.28	301.15	301.24	34970.0
2019-09-12 17:30:00	SPY	ETF	301.25	301.4	301.17	301.37	127256.0
2019-09-12 18:00:00	SPY	ETF	301.33	301.78	301.32	301.64	285298.0
2019-09-12 18:30:00	SPY	ETF	301.64	301.69	301.57	301.67	28864.0
2019-09-12 19:00:00	SPY	ETF	301.69	301.69	301.6	301.6	7674.0
2019-09-12 19:30:00	SPY	ETF	301.6	301.75	301.59	301.75	34717.0
2019-09-12 04:00:00	QQQ	ETF	193.49	193.49	193.19	193.3	13484.0
2019-09-12 04:30:00	QQQ	ETF	193.32	193.34	193.06	193.09	6160.0
2019-09-12 05:00:00	QQQ	ETF	193.1	193.21	193.08	193.11	4550.0
2019-09-12 05:30:00	QQQ	ETF	193.11	193.18	193.04	193.16	8327.0
2019-09-12 06:00:00	QQQ	ETF	193.18	193.18	192.95	192.95	11370.0
2019-09-12 06:30:00	QQQ	ETF	193.01	193.09	192.99	192.99	15250.0
2019-09-12 07:00:00	QQQ	ETF	193.05	193.26	193.05	193.19	54047.0
2019-09-12 07:30:00	QQQ	ETF	193.15	193.74	192.9	193.56	148705.0
2019-09-12 08:00:00	QQQ	ETF	193.21	193.85	193.05	193.48	248854.0
2019-09-12 08:30:00	QQQ	ETF	193.46	193.9	193.46	193.69	160835.0
2019-09-12 09:00:00	QQQ	ETF	193.71	193.93	193.59	193.65	180473.0
2019-09-12 09:30:00	QQQ	ETF	193.64	194.1	192.97	193.5	4022936.0
2019-09-12 10:00:00	QQQ	ETF	193.52	194.71	193.38	194.45	4270516.0
2019-09-12 10:30:00	QQQ	ETF	194.4416	194.56	193.1127	193.57	3084999.0
2019-09-12 11:00:00	QQQ	ETF	193.55	193.95	193.29	193.83	1396723.0
2019-09-12 11:30:00	QQQ	ETF	193.82	194.0	193.63	193.91	749423.0
2019-09-12 12:00:00	QQQ	ETF	193.92	193.94	193.53	193.73	838446.0
2019-09-12 12:30:00	QQQ	ETF	193.73	194.04	193.725	194.0	548204.0

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

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