PREVIEW / etf_30min / 2017-07-12

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-12.parquet
  size:    432 KB
  rows:    15,080

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
2017-07-12 04:30:00	SPY	ETF	242.33	242.33	242.33	242.33	600.0
2017-07-12 05:00:00	SPY	ETF	242.33	242.33	242.28	242.33	1110.0
2017-07-12 05:30:00	SPY	ETF	242.43	242.64	242.43	242.62	11550.0
2017-07-12 06:00:00	SPY	ETF	242.62	242.62	242.55	242.55	29200.0
2017-07-12 06:30:00	SPY	ETF	242.64	242.73	242.64	242.7	35550.0
2017-07-12 07:00:00	SPY	ETF	242.65	242.76	242.65	242.76	50668.0
2017-07-12 07:30:00	SPY	ETF	242.72	242.72	242.61	242.62	20431.0
2017-07-12 08:00:00	SPY	ETF	242.19	242.76	242.19	242.64	58764.0
2017-07-12 08:30:00	SPY	ETF	242.64	243.46	242.64	243.36	453483.0
2017-07-12 09:00:00	SPY	ETF	243.37	243.43	242.4923	243.32	692538.0
2017-07-12 09:30:00	SPY	ETF	243.3	244.03	243.3	243.87	7122186.0
2017-07-12 10:00:00	SPY	ETF	243.87	244.1	243.77	243.97	4991029.0
2017-07-12 10:30:00	SPY	ETF	243.975	244.06	243.62	243.645	3061768.0
2017-07-12 11:00:00	SPY	ETF	243.6401	243.89	243.5627	243.815	2341530.0
2017-07-12 11:30:00	SPY	ETF	243.82	243.84	243.68	243.799	1707847.0
2017-07-12 12:00:00	SPY	ETF	243.8	243.965	243.52	243.7999	2920866.0
2017-07-12 12:30:00	SPY	ETF	243.8	243.87	243.685	243.86	1865094.0
2017-07-12 13:00:00	SPY	ETF	243.87	243.95	243.755	243.8565	2243894.0
2017-07-12 13:30:00	SPY	ETF	243.86	244.08	243.845	244.07	1524788.0
2017-07-12 14:00:00	SPY	ETF	244.06	244.2	243.945	244.12	1665486.0
2017-07-12 14:30:00	SPY	ETF	244.12	244.15	244.0	244.06	4495342.0
2017-07-12 15:00:00	SPY	ETF	244.06	244.2	244.04	244.095	2700282.0
2017-07-12 15:30:00	SPY	ETF	244.09	244.16	243.88	243.98	8056838.0
2017-07-12 16:00:00	SPY	ETF	243.97	244.06	243.83	243.83	11173942.0
2017-07-12 16:30:00	SPY	ETF	243.83	244.0	243.81	243.94	211989.0
2017-07-12 17:00:00	SPY	ETF	243.94	244.02	243.93	243.96	284466.0
2017-07-12 17:30:00	SPY	ETF	243.96	244.1	243.96	244.0	211743.0
2017-07-12 18:00:00	SPY	ETF	244.0	244.02	243.92	243.99	211732.0
2017-07-12 18:30:00	SPY	ETF	243.99	244.02	243.97	244.02	23989.0
2017-07-12 19:00:00	SPY	ETF	244.02	244.02	243.95	244.01	36394.0
2017-07-12 19:30:00	SPY	ETF	244.01	244.04	243.98	244.04	33127.0
2017-07-12 04:00:00	QQQ	ETF	139.18	139.18	139.16	139.16	3698.0
2017-07-12 04:30:00	QQQ	ETF	139.2	139.2	139.18	139.18	701.0
2017-07-12 05:30:00	QQQ	ETF	139.25	139.43	139.22	139.43	9077.0
2017-07-12 06:00:00	QQQ	ETF	139.45	139.45	139.45	139.45	2000.0
2017-07-12 06:30:00	QQQ	ETF	139.48	139.66	139.48	139.58	15000.0
2017-07-12 07:00:00	QQQ	ETF	139.59	139.67	139.55	139.67	47876.0
2017-07-12 07:30:00	QQQ	ETF	139.61	139.63	139.53	139.53	24756.0
2017-07-12 08:00:00	QQQ	ETF	139.54	139.65	139.52	139.61	21805.0
2017-07-12 08:30:00	QQQ	ETF	139.6	140.31	139.6	140.3	701237.0
2017-07-12 09:00:00	QQQ	ETF	140.28	140.38	140.18	140.2	574711.0
2017-07-12 09:30:00	QQQ	ETF	140.21	140.39	139.955	140.0801	5341285.0
2017-07-12 10:00:00	QQQ	ETF	140.1	140.46	140.1	140.36	2735282.0
2017-07-12 10:30:00	QQQ	ETF	140.36	140.37	140.01	140.16	2537615.0
2017-07-12 11:00:00	QQQ	ETF	140.155	140.44	140.14	140.39	1288311.0
2017-07-12 11:30:00	QQQ	ETF	140.39	140.41	140.26	140.37	712204.0
2017-07-12 12:00:00	QQQ	ETF	140.38	140.51	140.22	140.41	1567201.0
2017-07-12 12:30:00	QQQ	ETF	140.405	140.45	140.315	140.43	667792.0
2017-07-12 13:00:00	QQQ	ETF	140.44	140.52	140.34	140.43	796457.0
2017-07-12 13:30:00	QQQ	ETF	140.425	140.62	140.4	140.6	1230455.0

> showing 50 of 15,080 rows — these rows as CSV

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