PREVIEW / stock_30min / 2018-06-06

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-06.parquet
  size:    1.7 MB
  rows:    85,267
  symbols: 2,841

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
2018-06-06 04:00:00	AAPL	Stock	48.375	48.5325	48.375	48.475	9032.0
2018-06-06 04:30:00	AAPL	Stock	48.455	48.455	48.455	48.455	504.0
2018-06-06 05:00:00	AAPL	Stock	48.445	48.475	48.4425	48.475	14572.0
2018-06-06 05:30:00	AAPL	Stock	48.465	48.465	48.4375	48.45	5764.0
2018-06-06 06:00:00	AAPL	Stock	48.47	48.475	48.4375	48.4375	20504.0
2018-06-06 06:30:00	AAPL	Stock	48.4325	48.45	48.4325	48.45	2000.0
2018-06-06 07:00:00	AAPL	Stock	48.4125	48.485	48.4025	48.48	113700.0
2018-06-06 07:30:00	AAPL	Stock	48.485	48.5	48.4775	48.4975	37236.0
2018-06-06 08:00:00	AAPL	Stock	48.45	48.5	48.4125	48.475	323828.0
2018-06-06 08:30:00	AAPL	Stock	48.465	48.475	48.3275	48.4225	389692.0
2018-06-06 09:00:00	AAPL	Stock	48.4125	48.4375	48.345	48.405	219488.0
2018-06-06 09:30:00	AAPL	Stock	48.3975	48.4825	48.2365	48.2525	10387376.0
2018-06-06 10:00:00	AAPL	Stock	48.25	48.265	48.06	48.1688	6902852.0
2018-06-06 10:30:00	AAPL	Stock	48.1675	48.2	47.98	48.1075	5024200.0
2018-06-06 11:00:00	AAPL	Stock	48.11	48.2925	48.1075	48.29	4251148.0
2018-06-06 11:30:00	AAPL	Stock	48.2925	48.3212	48.1825	48.2725	3205512.0
2018-06-06 12:00:00	AAPL	Stock	48.2722	48.2775	48.1725	48.2	2420040.0
2018-06-06 12:30:00	AAPL	Stock	48.1975	48.245	48.18	48.2425	1855576.0
2018-06-06 13:00:00	AAPL	Stock	48.2425	48.275	48.115	48.1775	2470128.0
2018-06-06 13:30:00	AAPL	Stock	48.1763	48.225	48.1475	48.1738	1938652.0
2018-06-06 14:00:00	AAPL	Stock	48.175	48.2838	48.175	48.2838	2403092.0
2018-06-06 14:30:00	AAPL	Stock	48.2848	48.3838	48.27	48.36	3713188.0
2018-06-06 15:00:00	AAPL	Stock	48.36	48.37	48.3125	48.345	2808120.0
2018-06-06 15:30:00	AAPL	Stock	48.345	48.52	48.3177	48.5125	11556600.0
2018-06-06 16:00:00	AAPL	Stock	48.5075	48.5075	48.425	48.4725	13549236.0
2018-06-06 16:30:00	AAPL	Stock	48.475	48.495	48.4575	48.4875	152328.0
2018-06-06 17:00:00	AAPL	Stock	48.4625	48.4875	48.455	48.4825	16584.0
2018-06-06 17:30:00	AAPL	Stock	48.48	48.4825	48.4775	48.4775	3184.0
2018-06-06 18:00:00	AAPL	Stock	48.48	48.4825	48.475	48.48	23920.0
2018-06-06 18:30:00	AAPL	Stock	48.475	48.48	48.465	48.4725	12296.0
2018-06-06 19:00:00	AAPL	Stock	48.4625	48.475	48.46	48.4625	6680.0
2018-06-06 19:30:00	AAPL	Stock	48.46	48.4675	48.4375	48.4625	25296.0
2018-06-06 04:00:00	MSFT	Stock	102.33	102.67	102.33	102.67	1125.0
2018-06-06 04:30:00	MSFT	Stock	102.6	102.7	102.6	102.7	340.0
2018-06-06 05:00:00	MSFT	Stock	102.7	102.7	102.7	102.7	779.0
2018-06-06 05:30:00	MSFT	Stock	102.69	102.69	102.6	102.6	589.0
2018-06-06 06:30:00	MSFT	Stock	102.74	102.74	102.74	102.74	176.0
2018-06-06 07:00:00	MSFT	Stock	102.51	102.85	102.51	102.72	4392.0
2018-06-06 07:30:00	MSFT	Stock	102.6	102.76	102.58	102.7	2192.0
2018-06-06 08:00:00	MSFT	Stock	102.6	102.77	102.5	102.74	10311.0
2018-06-06 08:30:00	MSFT	Stock	102.77	102.84	102.58	102.61	18262.0
2018-06-06 09:00:00	MSFT	Stock	102.65	102.65	102.41	102.45	34888.0
2018-06-06 09:30:00	MSFT	Stock	102.48	102.6	102.2	102.24	2726822.0
2018-06-06 10:00:00	MSFT	Stock	102.245	102.33	101.92	102.1	1382415.0
2018-06-06 10:30:00	MSFT	Stock	102.09	102.24	101.92	102.095	1459375.0
2018-06-06 11:00:00	MSFT	Stock	102.095	102.5	102.08	102.466	911722.0
2018-06-06 11:30:00	MSFT	Stock	102.46	102.55	102.42	102.5	878404.0
2018-06-06 12:00:00	MSFT	Stock	102.5	102.55	102.19	102.229	650585.0
2018-06-06 12:30:00	MSFT	Stock	102.22	102.29	102.15	102.22	554476.0
2018-06-06 13:00:00	MSFT	Stock	102.23	102.27	101.9	102.07	588990.0

> showing 50 of 85,267 rows — these rows as CSV

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