PREVIEW / etf_30min / 2017-08-04

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-04.parquet
  size:    419 KB
  rows:    14,576

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-08-04 04:00:00	SPY	ETF	247.3	247.33	247.3	247.33	1200.0
2017-08-04 04:30:00	SPY	ETF	247.32	247.32	247.32	247.32	200.0
2017-08-04 05:00:00	SPY	ETF	247.33	247.42	247.33	247.42	300.0
2017-08-04 05:30:00	SPY	ETF	247.43	247.43	247.36	247.36	35800.0
2017-08-04 06:00:00	SPY	ETF	247.39	247.39	247.39	247.39	500.0
2017-08-04 06:30:00	SPY	ETF	247.42	247.42	247.39	247.39	15500.0
2017-08-04 07:00:00	SPY	ETF	247.41	247.5	247.4	247.5	53184.0
2017-08-04 07:30:00	SPY	ETF	247.48	247.58	247.48	247.55	52024.0
2017-08-04 08:00:00	SPY	ETF	247.47	247.63	247.44	247.44	361504.0
2017-08-04 08:30:00	SPY	ETF	247.5	247.73	247.44	247.5	399644.0
2017-08-04 09:00:00	SPY	ETF	247.49	247.59	247.47	247.53	120978.0
2017-08-04 09:30:00	SPY	ETF	247.52	247.79	247.24	247.27	4731909.0
2017-08-04 10:00:00	SPY	ETF	247.26	247.54	246.97	247.51	4195234.0
2017-08-04 10:30:00	SPY	ETF	247.5	247.58	247.17	247.315	6317721.0
2017-08-04 11:00:00	SPY	ETF	247.32	247.48	247.18	247.37	3387951.0
2017-08-04 11:30:00	SPY	ETF	247.365	247.48	247.27	247.43	2738193.0
2017-08-04 12:00:00	SPY	ETF	247.42	247.45	247.28	247.37	1182852.0
2017-08-04 12:30:00	SPY	ETF	247.37	247.38	247.21	247.32	1711137.0
2017-08-04 13:00:00	SPY	ETF	247.33	247.39	247.2544	247.32	1673780.0
2017-08-04 13:30:00	SPY	ETF	247.32	247.43	247.31	247.405	1203364.0
2017-08-04 14:00:00	SPY	ETF	247.4	247.44	247.16	247.17	2522680.0
2017-08-04 14:30:00	SPY	ETF	247.16	247.3	247.14	247.22	1988003.0
2017-08-04 15:00:00	SPY	ETF	247.22	247.34	247.2	247.27	2884110.0
2017-08-04 15:30:00	SPY	ETF	247.28	247.46	247.145	247.4	11548885.0
2017-08-04 16:00:00	SPY	ETF	247.41	247.4646	247.24	247.31	10848874.0
2017-08-04 16:30:00	SPY	ETF	247.31	247.41	247.22	247.24	1137113.0
2017-08-04 17:00:00	SPY	ETF	247.23	247.3	247.22	247.28	27454.0
2017-08-04 17:30:00	SPY	ETF	247.26	247.3	247.25	247.3	9037.0
2017-08-04 18:00:00	SPY	ETF	247.3	247.33	247.3	247.33	5537.0
2017-08-04 18:30:00	SPY	ETF	247.3	247.3	247.3	247.3	4453.0
2017-08-04 19:00:00	SPY	ETF	247.3	247.38	247.3	247.34	6839.0
2017-08-04 19:30:00	SPY	ETF	247.33	247.36	247.32	247.32	2102.0
2017-08-04 04:00:00	QQQ	ETF	143.56	143.57	143.55	143.55	6231.0
2017-08-04 04:30:00	QQQ	ETF	143.61	143.62	143.61	143.62	923.0
2017-08-04 06:00:00	QQQ	ETF	143.62	143.62	143.62	143.62	600.0
2017-08-04 06:30:00	QQQ	ETF	143.64	143.68	143.59	143.59	3000.0
2017-08-04 07:00:00	QQQ	ETF	143.6	143.65	143.6	143.62	35911.0
2017-08-04 07:30:00	QQQ	ETF	143.63	143.72	143.63	143.67	65907.0
2017-08-04 08:00:00	QQQ	ETF	143.67	143.72	143.6	143.62	86886.0
2017-08-04 08:30:00	QQQ	ETF	143.67	143.84	143.46	143.5	158158.0
2017-08-04 09:00:00	QQQ	ETF	143.51	143.71	143.51	143.67	115241.0
2017-08-04 09:30:00	QQQ	ETF	143.65	143.97	143.3077	143.327	3069217.0
2017-08-04 10:00:00	QQQ	ETF	143.33	143.74	143.06	143.715	3157035.0
2017-08-04 10:30:00	QQQ	ETF	143.71	143.8	143.47	143.64	1627708.0
2017-08-04 11:00:00	QQQ	ETF	143.65	143.9	143.56	143.8	1152221.0
2017-08-04 11:30:00	QQQ	ETF	143.79	143.8678	143.6	143.74	746614.0
2017-08-04 12:00:00	QQQ	ETF	143.75	143.75	143.49	143.57	319020.0
2017-08-04 12:30:00	QQQ	ETF	143.5784	143.58	143.33	143.51	653615.0
2017-08-04 13:00:00	QQQ	ETF	143.52	143.5898	143.39	143.465	498214.0
2017-08-04 13:30:00	QQQ	ETF	143.465	143.61	143.46	143.55	467820.0

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

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