PREVIEW / etf_30min / 2019-07-31

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-31.parquet
  size:    512 KB
  rows:    17,984

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-07-31 04:00:00	SPY	ETF	301.11	301.34	301.11	301.33	3310.0
2019-07-31 04:30:00	SPY	ETF	301.26	301.26	301.07	301.23	3638.0
2019-07-31 05:00:00	SPY	ETF	301.26	301.32	301.26	301.32	1700.0
2019-07-31 05:30:00	SPY	ETF	301.28	301.28	301.12	301.26	4300.0
2019-07-31 06:00:00	SPY	ETF	301.26	301.28	300.99	301.08	4507.0
2019-07-31 06:30:00	SPY	ETF	301.05	301.05	300.92	301.02	8345.0
2019-07-31 07:00:00	SPY	ETF	301.02	301.24	301.02	301.17	11903.0
2019-07-31 07:30:00	SPY	ETF	301.2	301.29	301.1	301.22	29764.0
2019-07-31 08:00:00	SPY	ETF	301.02	301.28	300.7619	301.15	218657.0
2019-07-31 08:30:00	SPY	ETF	301.13	301.28	301.13	301.17	78131.0
2019-07-31 09:00:00	SPY	ETF	301.16	301.16	300.94	300.99	131616.0
2019-07-31 09:30:00	SPY	ETF	300.99	301.06	300.73	300.8972	3705828.0
2019-07-31 10:00:00	SPY	ETF	300.89	300.95	300.535	300.551	1903287.0
2019-07-31 10:30:00	SPY	ETF	300.55	300.67	300.3	300.65	2487856.0
2019-07-31 11:00:00	SPY	ETF	300.66	301.07	300.62	300.92	2119725.0
2019-07-31 11:30:00	SPY	ETF	300.92	301.2	300.795	301.17	1401764.0
2019-07-31 12:00:00	SPY	ETF	301.17	301.2	300.93	300.9769	2170552.0
2019-07-31 12:30:00	SPY	ETF	300.975	300.995	300.81	300.94	1531229.0
2019-07-31 13:00:00	SPY	ETF	300.935	301.08	300.86	300.94	1320779.0
2019-07-31 13:30:00	SPY	ETF	300.935	301.035	300.6	300.96	2682621.0
2019-07-31 14:00:00	SPY	ETF	300.91	300.91	299.82	300.23	10100288.0
2019-07-31 14:30:00	SPY	ETF	300.23	300.63	295.2	297.62	26383916.0
2019-07-31 15:00:00	SPY	ETF	297.61	299.3	296.57	298.985	18021150.0
2019-07-31 15:30:00	SPY	ETF	298.98	298.985	297.37	297.38	16717507.0
2019-07-31 16:00:00	SPY	ETF	297.36	297.8685	297.13	297.2	9750630.0
2019-07-31 16:30:00	SPY	ETF	297.2	297.43	296.72	296.78	505985.0
2019-07-31 17:00:00	SPY	ETF	296.85	296.97	296.7	296.94	293954.0
2019-07-31 17:30:00	SPY	ETF	296.92	297.43	296.53	296.68	111002.0
2019-07-31 18:00:00	SPY	ETF	296.57	296.6899	296.13	296.67	160981.0
2019-07-31 18:30:00	SPY	ETF	296.65	296.82	296.51	296.76	37353.0
2019-07-31 19:00:00	SPY	ETF	296.77	297.08	296.73	297.03	33747.0
2019-07-31 19:30:00	SPY	ETF	297.0	297.08	296.73	296.73	31374.0
2019-07-31 04:00:00	QQQ	ETF	194.39	194.6	194.34	194.6	14021.0
2019-07-31 04:30:00	QQQ	ETF	194.58	194.6	194.44	194.45	11400.0
2019-07-31 05:00:00	QQQ	ETF	194.54	194.57	194.5	194.55	22654.0
2019-07-31 05:30:00	QQQ	ETF	194.53	194.55	194.44	194.55	3890.0
2019-07-31 06:00:00	QQQ	ETF	194.55	194.59	194.32	194.34	14660.0
2019-07-31 06:30:00	QQQ	ETF	194.32	194.41	194.23	194.33	32470.0
2019-07-31 07:00:00	QQQ	ETF	194.35	194.5	194.33	194.48	61161.0
2019-07-31 07:30:00	QQQ	ETF	194.47	194.56	194.39	194.49	22385.0
2019-07-31 08:00:00	QQQ	ETF	194.51	194.54	193.78	194.48	27598.0
2019-07-31 08:30:00	QQQ	ETF	194.49	194.56	194.45	194.48	23721.0
2019-07-31 09:00:00	QQQ	ETF	194.49	194.49	194.28	194.3	89845.0
2019-07-31 09:30:00	QQQ	ETF	194.31	194.34	193.83	194.11	2598693.0
2019-07-31 10:00:00	QQQ	ETF	194.12	194.43	194.02	194.0647	1168204.0
2019-07-31 10:30:00	QQQ	ETF	194.05	194.16	193.79	194.12	1517516.0
2019-07-31 11:00:00	QQQ	ETF	194.12	194.4	194.0	194.21	1108510.0
2019-07-31 11:30:00	QQQ	ETF	194.21	194.32	194.14	194.285	453213.0
2019-07-31 12:00:00	QQQ	ETF	194.29	194.31	193.98	194.04	571559.0
2019-07-31 12:30:00	QQQ	ETF	194.04	194.06	193.91	194.04	692715.0

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

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