PREVIEW / etf_30min / 2018-01-23

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-01-23.parquet
  size:    491 KB
  rows:    17,078

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
2018-01-23 04:00:00	SPY	ETF	283.02	283.26	283.02	283.19	6065.0
2018-01-23 04:30:00	SPY	ETF	283.16	283.16	283.14	283.15	790.0
2018-01-23 05:00:00	SPY	ETF	283.13	283.2	283.13	283.2	600.0
2018-01-23 05:30:00	SPY	ETF	283.06	283.06	282.96	282.98	4200.0
2018-01-23 06:00:00	SPY	ETF	282.95	282.95	282.18	282.18	57243.0
2018-01-23 06:30:00	SPY	ETF	282.22	282.48	282.08	282.45	80938.0
2018-01-23 07:00:00	SPY	ETF	282.48	282.66	282.4	282.43	79527.0
2018-01-23 07:30:00	SPY	ETF	282.43	282.66	282.43	282.5	91207.0
2018-01-23 08:00:00	SPY	ETF	283.51	283.51	282.37	282.49	407590.0
2018-01-23 08:30:00	SPY	ETF	282.5	282.59	282.37	282.37	200523.0
2018-01-23 09:00:00	SPY	ETF	282.37	282.75	282.34	282.74	495731.0
2018-01-23 09:30:00	SPY	ETF	282.74	283.31	282.37	282.65	9827429.0
2018-01-23 10:00:00	SPY	ETF	282.65	283.07	282.47	282.95	6518698.0
2018-01-23 10:30:00	SPY	ETF	282.96	283.53	282.84	283.45	5912363.0
2018-01-23 11:00:00	SPY	ETF	283.445	283.62	283.26	283.3371	9134321.0
2018-01-23 11:30:00	SPY	ETF	283.33	283.38	282.93	283.0625	3210334.0
2018-01-23 12:00:00	SPY	ETF	283.06	283.22	282.945	283.05	2788560.0
2018-01-23 12:30:00	SPY	ETF	283.045	283.18	282.84	283.08	4291257.0
2018-01-23 13:00:00	SPY	ETF	283.08	283.27	282.99	283.1699	7323785.0
2018-01-23 13:30:00	SPY	ETF	283.17	283.5	283.14	283.46	1661837.0
2018-01-23 14:00:00	SPY	ETF	283.47	283.47	282.88	283.13	5066767.0
2018-01-23 14:30:00	SPY	ETF	283.14	283.51	283.08	283.38	3771799.0
2018-01-23 15:00:00	SPY	ETF	283.38	283.41	283.02	283.285	3279386.0
2018-01-23 15:30:00	SPY	ETF	283.28	283.54	283.21	283.26	13127734.0
2018-01-23 16:00:00	SPY	ETF	283.24	283.29	283.01	283.13	5732884.0
2018-01-23 16:30:00	SPY	ETF	283.12	283.4571	282.76	283.03	5328461.0
2018-01-23 17:00:00	SPY	ETF	283.03	283.1591	282.93	282.96	70382.0
2018-01-23 17:30:00	SPY	ETF	282.96	282.99	282.92	282.92	4742706.0
2018-01-23 18:00:00	SPY	ETF	282.92	283.07	282.87	283.03	94609.0
2018-01-23 18:30:00	SPY	ETF	283.05	283.09	283.01	283.04	24181.0
2018-01-23 19:00:00	SPY	ETF	283.09	283.24	283.09	283.2	23131.0
2018-01-23 19:30:00	SPY	ETF	283.18	283.25	283.18	283.19	29700.0
2018-01-23 04:00:00	QQQ	ETF	168.88	168.94	168.88	168.88	12570.0
2018-01-23 04:30:00	QQQ	ETF	168.83	168.86	168.83	168.86	2780.0
2018-01-23 05:00:00	QQQ	ETF	168.84	168.84	168.83	168.83	2300.0
2018-01-23 05:30:00	QQQ	ETF	168.77	168.77	168.71	168.73	1400.0
2018-01-23 06:00:00	QQQ	ETF	168.6	168.6	168.2	168.22	51160.0
2018-01-23 06:30:00	QQQ	ETF	168.29	168.49	168.22	168.47	18870.0
2018-01-23 07:00:00	QQQ	ETF	168.46	168.58	168.46	168.51	91292.0
2018-01-23 07:30:00	QQQ	ETF	168.5	168.64	168.5	168.55	64211.0
2018-01-23 08:00:00	QQQ	ETF	168.58	169.07	168.49	168.54	265147.0
2018-01-23 08:30:00	QQQ	ETF	168.56	168.61	168.34	168.35	142049.0
2018-01-23 09:00:00	QQQ	ETF	168.34	168.67	168.33	168.65	121727.0
2018-01-23 09:30:00	QQQ	ETF	168.65	169.2275	168.555	168.82	5959942.0
2018-01-23 10:00:00	QQQ	ETF	168.82	169.33	168.72	169.26	2425744.0
2018-01-23 10:30:00	QQQ	ETF	169.27	169.53	169.18	169.47	1833442.0
2018-01-23 11:00:00	QQQ	ETF	169.47	169.61	169.3501	169.425	1491278.0
2018-01-23 11:30:00	QQQ	ETF	169.43	169.47	169.16	169.23	1154566.0
2018-01-23 12:00:00	QQQ	ETF	169.23	169.44	169.16	169.35	772184.0
2018-01-23 12:30:00	QQQ	ETF	169.35	169.4698	169.18	169.23	824475.0

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

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