PREVIEW / etf_30min / 2017-06-06

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-06.parquet
  size:    432 KB
  rows:    14,958

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-06-06 04:00:00	SPY	ETF	243.73	243.73	243.5	243.5	47353.0
2017-06-06 04:30:00	SPY	ETF	243.55	243.69	243.55	243.65	1660.0
2017-06-06 05:00:00	SPY	ETF	243.65	243.67	243.55	243.55	2710.0
2017-06-06 05:30:00	SPY	ETF	243.6	243.61	243.55	243.57	1891.0
2017-06-06 06:00:00	SPY	ETF	243.52	243.57	243.5	243.5	1930.0
2017-06-06 06:30:00	SPY	ETF	243.48	243.5	243.38	243.4	55835.0
2017-06-06 07:00:00	SPY	ETF	243.42	243.43	243.13	243.15	224505.0
2017-06-06 07:30:00	SPY	ETF	243.14	243.24	243.05	243.24	75930.0
2017-06-06 08:00:00	SPY	ETF	243.1	243.42	243.07	243.24	156475.0
2017-06-06 08:30:00	SPY	ETF	243.24	243.32	243.22	243.3	126430.0
2017-06-06 09:00:00	SPY	ETF	243.29	243.33	243.19	243.31	222170.0
2017-06-06 09:30:00	SPY	ETF	243.34	243.7	243.12	243.66	5268193.0
2017-06-06 10:00:00	SPY	ETF	243.66	243.83	243.47	243.72	3727448.0
2017-06-06 10:30:00	SPY	ETF	243.72	243.933	243.51	243.53	2901066.0
2017-06-06 11:00:00	SPY	ETF	243.53	243.56	243.375	243.44	1779072.0
2017-06-06 11:30:00	SPY	ETF	243.44	243.82	243.41	243.66	2405284.0
2017-06-06 12:00:00	SPY	ETF	243.66	243.73	243.57	243.61	1723937.0
2017-06-06 12:30:00	SPY	ETF	243.62	243.71	243.55	243.665	1123197.0
2017-06-06 13:00:00	SPY	ETF	243.67	243.69	243.42	243.5	1292863.0
2017-06-06 13:30:00	SPY	ETF	243.5	243.52	243.4	243.501	2105610.0
2017-06-06 14:00:00	SPY	ETF	243.51	243.7	243.51	243.67	2723834.0
2017-06-06 14:30:00	SPY	ETF	243.67	243.98	243.66	243.87	3661222.0
2017-06-06 15:00:00	SPY	ETF	243.88	243.93	243.46	243.51	3750447.0
2017-06-06 15:30:00	SPY	ETF	243.52	243.53	243.17	243.25	9120599.0
2017-06-06 16:00:00	SPY	ETF	243.26	243.52	243.21	243.46	5565601.0
2017-06-06 16:30:00	SPY	ETF	243.47	243.48	243.21	243.39	694133.0
2017-06-06 17:00:00	SPY	ETF	243.21	243.36	243.21	243.36	72450.0
2017-06-06 17:30:00	SPY	ETF	243.35	243.36	243.3	243.34	52400.0
2017-06-06 18:00:00	SPY	ETF	243.34	243.47	243.34	243.42	25617.0
2017-06-06 18:30:00	SPY	ETF	243.44	243.5	243.44	243.48	15130.0
2017-06-06 19:00:00	SPY	ETF	243.47	243.47	243.2566	243.43	440139.0
2017-06-06 19:30:00	SPY	ETF	243.44	243.48	243.44	243.47	15130.0
2017-06-06 04:00:00	QQQ	ETF	143.41	143.41	143.33	143.33	3095.0
2017-06-06 05:30:00	QQQ	ETF	143.33	143.4	143.33	143.4	2400.0
2017-06-06 06:30:00	QQQ	ETF	143.35	143.36	143.32	143.33	15900.0
2017-06-06 07:00:00	QQQ	ETF	143.3	143.31	143.15	143.15	11187.0
2017-06-06 07:30:00	QQQ	ETF	143.15	143.15	143.06	143.14	43313.0
2017-06-06 08:00:00	QQQ	ETF	143.11	143.15	143.08	143.1	41510.0
2017-06-06 08:30:00	QQQ	ETF	143.12	143.2	143.12	143.2	23780.0
2017-06-06 09:00:00	QQQ	ETF	143.19	143.29	143.16	143.28	103389.0
2017-06-06 09:30:00	QQQ	ETF	143.28	143.59	143.17	143.51	2995501.0
2017-06-06 10:00:00	QQQ	ETF	143.52	143.67	143.34	143.62	1291349.0
2017-06-06 10:30:00	QQQ	ETF	143.62	143.73	143.54	143.55	522599.0
2017-06-06 11:00:00	QQQ	ETF	143.555	143.58	143.35	143.4066	687232.0
2017-06-06 11:30:00	QQQ	ETF	143.4	143.55	143.4	143.5	645487.0
2017-06-06 12:00:00	QQQ	ETF	143.5	143.53	143.42	143.44	294499.0
2017-06-06 12:30:00	QQQ	ETF	143.45	143.51	143.4	143.49	308264.0
2017-06-06 13:00:00	QQQ	ETF	143.49	143.5	143.2999	143.37	716092.0
2017-06-06 13:30:00	QQQ	ETF	143.37	143.39	143.33	143.38	384307.0
2017-06-06 14:00:00	QQQ	ETF	143.39	143.49	143.365	143.47	565449.0

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

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