PREVIEW / stock_30min / 2018-10-16

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-16.parquet
  size:    1.7 MB
  rows:    84,400
  symbols: 2,767

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-10-16 04:00:00	AAPL	Stock	54.5	54.725	54.5	54.63	6288.0
2018-10-16 04:30:00	AAPL	Stock	54.625	54.625	54.5	54.5	10280.0
2018-10-16 05:30:00	AAPL	Stock	54.6	54.6	54.6	54.6	2400.0
2018-10-16 06:00:00	AAPL	Stock	54.5975	54.65	54.575	54.65	13836.0
2018-10-16 06:30:00	AAPL	Stock	54.6875	54.6875	54.6725	54.6725	1184.0
2018-10-16 07:00:00	AAPL	Stock	54.6725	54.6725	54.5	54.625	115560.0
2018-10-16 07:30:00	AAPL	Stock	54.625	54.6875	54.6	54.6875	110272.0
2018-10-16 08:00:00	AAPL	Stock	54.6	54.79	54.515	54.7375	275160.0
2018-10-16 08:30:00	AAPL	Stock	54.7375	54.825	54.7225	54.7875	161276.0
2018-10-16 09:00:00	AAPL	Stock	54.795	54.88	54.7	54.7225	299940.0
2018-10-16 09:30:00	AAPL	Stock	54.7425	54.825	54.45	54.635	14102744.0
2018-10-16 10:00:00	AAPL	Stock	54.6225	54.715	54.32	54.4025	8370292.0
2018-10-16 10:30:00	AAPL	Stock	54.4025	54.61	54.1908	54.5735	8097756.0
2018-10-16 11:00:00	AAPL	Stock	54.5725	54.8	54.4875	54.7475	7129616.0
2018-10-16 11:30:00	AAPL	Stock	54.7425	55.0575	54.705	55.0375	6148880.0
2018-10-16 12:00:00	AAPL	Stock	55.0375	55.1575	54.8275	54.93	5838072.0
2018-10-16 12:30:00	AAPL	Stock	54.9325	55.0275	54.875	55.0125	3045272.0
2018-10-16 13:00:00	AAPL	Stock	55.0188	55.125	54.99	55.075	3573508.0
2018-10-16 13:30:00	AAPL	Stock	55.08	55.265	55.0575	55.155	3864600.0
2018-10-16 14:00:00	AAPL	Stock	55.155	55.4625	55.1325	55.4438	4520552.0
2018-10-16 14:30:00	AAPL	Stock	55.4435	55.4875	55.285	55.335	4848400.0
2018-10-16 15:00:00	AAPL	Stock	55.335	55.57	55.27	55.5	5899220.0
2018-10-16 15:30:00	AAPL	Stock	55.4975	55.7475	55.4825	55.5325	12023260.0
2018-10-16 16:00:00	AAPL	Stock	55.5375	55.8125	55.381	55.78	8538968.0
2018-10-16 16:30:00	AAPL	Stock	55.775	55.8	55.7	55.7	169688.0
2018-10-16 17:00:00	AAPL	Stock	55.7448	55.7875	55.5375	55.7525	72324.0
2018-10-16 17:30:00	AAPL	Stock	55.7625	55.7975	55.755	55.7975	33184.0
2018-10-16 18:00:00	AAPL	Stock	55.7575	55.775	55.75	55.755	14408.0
2018-10-16 18:30:00	AAPL	Stock	55.75	55.785	55.7175	55.75	52564.0
2018-10-16 19:00:00	AAPL	Stock	55.775	55.785	55.7225	55.7225	18884.0
2018-10-16 19:30:00	AAPL	Stock	55.7625	55.8	55.73	55.7875	33936.0
2018-10-16 04:00:00	MSFT	Stock	108.23	108.55	108.23	108.55	600.0
2018-10-16 04:30:00	MSFT	Stock	108.5	108.9	108.5	108.9	2550.0
2018-10-16 05:00:00	MSFT	Stock	108.8	108.8	108.6	108.6	2610.0
2018-10-16 05:30:00	MSFT	Stock	108.4	108.5	108.4	108.5	1379.0
2018-10-16 06:00:00	MSFT	Stock	108.6	108.75	108.6	108.7	1155.0
2018-10-16 06:30:00	MSFT	Stock	108.7	108.7	108.61	108.61	225.0
2018-10-16 07:00:00	MSFT	Stock	108.8	108.8	108.51	108.63	2753.0
2018-10-16 07:30:00	MSFT	Stock	108.6	108.75	108.6	108.74	3043.0
2018-10-16 08:00:00	MSFT	Stock	108.65	108.95	108.5	108.83	15205.0
2018-10-16 08:30:00	MSFT	Stock	108.84	109.2	108.83	109.1	14420.0
2018-10-16 09:00:00	MSFT	Stock	109.1	109.55	108.85	109.54	68236.0
2018-10-16 09:30:00	MSFT	Stock	109.6	109.98	108.95	109.78	3485074.0
2018-10-16 10:00:00	MSFT	Stock	109.775	109.91	109.134	109.185	2114313.0
2018-10-16 10:30:00	MSFT	Stock	109.18	110.04	109.0	109.97	1876994.0
2018-10-16 11:00:00	MSFT	Stock	109.965	110.62	109.77	110.51	1651245.0
2018-10-16 11:30:00	MSFT	Stock	110.505	110.87	110.415	110.858	1355607.0
2018-10-16 12:00:00	MSFT	Stock	110.855	110.9	110.39	110.7	1140496.0
2018-10-16 12:30:00	MSFT	Stock	110.7	110.71	110.465	110.605	821929.0
2018-10-16 13:00:00	MSFT	Stock	110.6	110.72	110.51	110.605	1070361.0

> showing 50 of 84,400 rows — these rows as CSV

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