PREVIEW / etf_30min / 2017-11-27

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-27.parquet
  size:    440 KB
  rows:    15,398

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-11-27 04:00:00	SPY	ETF	260.35	260.62	260.35	260.55	9452.0
2017-11-27 04:30:00	SPY	ETF	260.52	260.52	260.4	260.4	28400.0
2017-11-27 05:00:00	SPY	ETF	260.5	260.5	260.5	260.5	400.0
2017-11-27 05:30:00	SPY	ETF	260.5	260.56	260.48	260.54	13271.0
2017-11-27 06:00:00	SPY	ETF	260.59	260.66	260.58	260.62	9133.0
2017-11-27 06:30:00	SPY	ETF	260.61	260.61	260.54	260.56	3504.0
2017-11-27 07:00:00	SPY	ETF	260.53	260.53	260.24	260.26	124087.0
2017-11-27 07:30:00	SPY	ETF	260.2	260.3	260.2	260.29	140126.0
2017-11-27 08:00:00	SPY	ETF	260.52	260.52	260.18	260.33	74807.0
2017-11-27 08:30:00	SPY	ETF	260.33	260.42	260.27	260.28	291502.0
2017-11-27 09:00:00	SPY	ETF	260.3	260.42	260.24	260.36	232858.0
2017-11-27 09:30:00	SPY	ETF	260.41	260.75	260.27	260.575	4195975.0
2017-11-27 10:00:00	SPY	ETF	260.58	260.67	260.47	260.619	2994384.0
2017-11-27 10:30:00	SPY	ETF	260.6107	260.6868	260.52	260.61	2283954.0
2017-11-27 11:00:00	SPY	ETF	260.62	260.63	260.08	260.105	6306539.0
2017-11-27 11:30:00	SPY	ETF	260.105	260.335	260.0	260.31	3198085.0
2017-11-27 12:00:00	SPY	ETF	260.31	260.315	260.21	260.29	2593834.0
2017-11-27 12:30:00	SPY	ETF	260.285	260.32	260.15	260.27	2419934.0
2017-11-27 13:00:00	SPY	ETF	260.27	260.44	260.265	260.36	1758333.0
2017-11-27 13:30:00	SPY	ETF	260.36	260.43	260.31	260.42	832098.0
2017-11-27 14:00:00	SPY	ETF	260.42	260.43	260.28	260.3362	868548.0
2017-11-27 14:30:00	SPY	ETF	260.335	260.39	260.27	260.39	2696525.0
2017-11-27 15:00:00	SPY	ETF	260.38	260.38	260.25	260.34	3374575.0
2017-11-27 15:30:00	SPY	ETF	260.34	260.42	260.25	260.26	7859077.0
2017-11-27 16:00:00	SPY	ETF	260.25	260.4	260.23	260.2346	7310540.0
2017-11-27 16:30:00	SPY	ETF	260.35	260.48	260.35	260.46	315038.0
2017-11-27 17:00:00	SPY	ETF	260.44	260.45	260.35	260.35	82320.0
2017-11-27 17:30:00	SPY	ETF	260.37	260.41	260.37	260.4	15318.0
2017-11-27 18:00:00	SPY	ETF	260.4	260.41	260.17	260.18	77108.0
2017-11-27 18:30:00	SPY	ETF	260.21	260.32	260.14	260.14	39365.0
2017-11-27 19:00:00	SPY	ETF	260.18	260.23	260.12	260.12	39982.0
2017-11-27 19:30:00	SPY	ETF	260.11	260.11	259.96	259.98	38871.0
2017-11-27 04:00:00	QQQ	ETF	156.4	156.43	156.4	156.43	10000.0
2017-11-27 04:30:00	QQQ	ETF	156.36	156.42	156.36	156.42	300.0
2017-11-27 05:00:00	QQQ	ETF	156.43	156.43	156.43	156.43	1500.0
2017-11-27 06:00:00	QQQ	ETF	156.45	156.55	156.45	156.45	3398.0
2017-11-27 06:30:00	QQQ	ETF	156.46	156.46	156.43	156.45	2200.0
2017-11-27 07:00:00	QQQ	ETF	156.46	156.46	156.24	156.25	43126.0
2017-11-27 07:30:00	QQQ	ETF	156.21	156.22	156.17	156.17	104102.0
2017-11-27 08:00:00	QQQ	ETF	156.16	156.45	156.08	156.14	103652.0
2017-11-27 08:30:00	QQQ	ETF	156.18	156.24	156.15	156.16	66654.0
2017-11-27 09:00:00	QQQ	ETF	156.16	156.24	156.13	156.19	168257.0
2017-11-27 09:30:00	QQQ	ETF	156.2	156.44	156.0547	156.3099	3176009.0
2017-11-27 10:00:00	QQQ	ETF	156.305	156.56	156.29	156.456	1742865.0
2017-11-27 10:30:00	QQQ	ETF	156.46	156.5	156.37	156.42	541705.0
2017-11-27 11:00:00	QQQ	ETF	156.43	156.46	155.83	155.87	2166531.0
2017-11-27 11:30:00	QQQ	ETF	155.87	156.17	155.86	156.13	1361432.0
2017-11-27 12:00:00	QQQ	ETF	156.13	156.19	156.07	156.18	853472.0
2017-11-27 12:30:00	QQQ	ETF	156.19	156.2	156.01	156.117	979943.0
2017-11-27 13:00:00	QQQ	ETF	156.115	156.3	156.115	156.2591	637610.0

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

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