PREVIEW / etf_30min / 2017-04-27

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-27.parquet
  size:    427 KB
  rows:    14,579

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-04-27 04:30:00	SPY	ETF	238.4	238.41	238.33	238.33	2752.0
2017-04-27 05:00:00	SPY	ETF	238.28	238.32	238.28	238.32	403.0
2017-04-27 05:30:00	SPY	ETF	238.38	238.38	238.31	238.37	8103.0
2017-04-27 06:00:00	SPY	ETF	238.36	238.36	238.31	238.31	1453.0
2017-04-27 06:30:00	SPY	ETF	238.39	238.49	238.32	238.44	15664.0
2017-04-27 07:00:00	SPY	ETF	238.44	238.73	238.43	238.73	124944.0
2017-04-27 07:30:00	SPY	ETF	238.69	238.7	238.6	238.6	202944.0
2017-04-27 08:00:00	SPY	ETF	238.6	238.72	238.37	238.62	322155.0
2017-04-27 08:30:00	SPY	ETF	238.62	238.75	238.42	238.56	467427.0
2017-04-27 09:00:00	SPY	ETF	238.57	238.79	238.48	238.76	197781.0
2017-04-27 09:30:00	SPY	ETF	238.77	238.8	238.37	238.585	5520154.0
2017-04-27 10:00:00	SPY	ETF	238.59	238.84	238.45	238.49	4047613.0
2017-04-27 10:30:00	SPY	ETF	238.49	238.74	238.03	238.2208	5128289.0
2017-04-27 11:00:00	SPY	ETF	238.23	238.39	238.14	238.2	3621320.0
2017-04-27 11:30:00	SPY	ETF	238.2	238.3	237.98	238.11	3485430.0
2017-04-27 12:00:00	SPY	ETF	238.11	238.29	238.1015	238.19	1916881.0
2017-04-27 12:30:00	SPY	ETF	238.18	238.94	238.18	238.93	3500921.0
2017-04-27 13:00:00	SPY	ETF	238.93	238.95	238.735	238.8	3042977.0
2017-04-27 13:30:00	SPY	ETF	238.8	238.83	238.635	238.68	1796342.0
2017-04-27 14:00:00	SPY	ETF	238.68	238.73	238.55	238.63	1996912.0
2017-04-27 14:30:00	SPY	ETF	238.63	238.81	238.62	238.72	1611816.0
2017-04-27 15:00:00	SPY	ETF	238.715	238.72	238.41	238.61	2555243.0
2017-04-27 15:30:00	SPY	ETF	238.61	238.68	238.42	238.61	6623911.0
2017-04-27 16:00:00	SPY	ETF	238.61	238.75	238.52	238.67	9865544.0
2017-04-27 16:30:00	SPY	ETF	238.67	238.86	238.59	238.82	254542.0
2017-04-27 17:00:00	SPY	ETF	238.8	238.83	238.71	238.76	114500.0
2017-04-27 17:30:00	SPY	ETF	238.78	238.81	238.6	238.72	81793.0
2017-04-27 18:00:00	SPY	ETF	238.71	238.74	238.56	238.62	115854.0
2017-04-27 18:30:00	SPY	ETF	238.62	238.67	238.6	238.67	21310.0
2017-04-27 19:00:00	SPY	ETF	238.67	238.68	238.65	238.65	5052.0
2017-04-27 19:30:00	SPY	ETF	238.65	238.69	238.58	238.6	60831.0
2017-04-27 05:00:00	QQQ	ETF	134.94	134.94	134.94	134.94	100.0
2017-04-27 05:30:00	QQQ	ETF	134.96	134.96	134.96	134.96	399.0
2017-04-27 06:30:00	QQQ	ETF	134.95	135.0	134.95	135.0	1932.0
2017-04-27 07:00:00	QQQ	ETF	135.05	135.21	135.05	135.21	31099.0
2017-04-27 07:30:00	QQQ	ETF	135.18	135.2	135.14	135.15	14869.0
2017-04-27 08:00:00	QQQ	ETF	135.15	135.19	135.14	135.14	12350.0
2017-04-27 08:30:00	QQQ	ETF	135.11	135.18	135.06	135.12	40724.0
2017-04-27 09:00:00	QQQ	ETF	135.17	135.29	135.15	135.27	63975.0
2017-04-27 09:30:00	QQQ	ETF	135.28	135.451	135.19	135.42	2125862.0
2017-04-27 10:00:00	QQQ	ETF	135.42	135.61	135.41	135.46	1297459.0
2017-04-27 10:30:00	QQQ	ETF	135.46	135.6	135.325	135.41	822143.0
2017-04-27 11:00:00	QQQ	ETF	135.4	135.54	135.37	135.44	726791.0
2017-04-27 11:30:00	QQQ	ETF	135.44	135.53	135.35	135.47	629769.0
2017-04-27 12:00:00	QQQ	ETF	135.48	135.51	135.41	135.4239	501371.0
2017-04-27 12:30:00	QQQ	ETF	135.4225	135.68	135.41	135.67	636147.0
2017-04-27 13:00:00	QQQ	ETF	135.6607	135.68	135.61	135.65	531106.0
2017-04-27 13:30:00	QQQ	ETF	135.65	135.66	135.56	135.5762	469544.0
2017-04-27 14:00:00	QQQ	ETF	135.57	135.615	135.48	135.53	432461.0
2017-04-27 14:30:00	QQQ	ETF	135.52	135.65	135.52	135.62	487652.0

> showing 50 of 14,579 rows — these rows as CSV

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