PREVIEW / stock_30min / 2018-08-03

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-03.parquet
  size:    1.6 MB
  rows:    81,654
  symbols: 2,779

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-08-03 04:00:00	AAPL	Stock	51.65	51.75	51.625	51.665	25132.0
2018-08-03 04:30:00	AAPL	Stock	51.67	51.67	51.655	51.655	17560.0
2018-08-03 05:00:00	AAPL	Stock	51.66	51.66	51.66	51.66	568.0
2018-08-03 05:30:00	AAPL	Stock	51.7	51.7075	51.665	51.685	4492.0
2018-08-03 06:00:00	AAPL	Stock	51.685	51.685	51.6625	51.675	2980.0
2018-08-03 06:30:00	AAPL	Stock	51.6625	51.7425	51.6625	51.725	16812.0
2018-08-03 07:00:00	AAPL	Stock	51.74	51.8475	51.74	51.825	226072.0
2018-08-03 07:30:00	AAPL	Stock	51.84	51.92	51.84	51.8925	236872.0
2018-08-03 08:00:00	AAPL	Stock	51.7625	51.92	51.7125	51.825	403284.0
2018-08-03 08:30:00	AAPL	Stock	51.8	51.825	51.705	51.7325	376112.0
2018-08-03 09:00:00	AAPL	Stock	51.7325	51.8375	51.72	51.7575	318376.0
2018-08-03 09:30:00	AAPL	Stock	51.7575	51.8375	51.37	51.545	23698496.0
2018-08-03 10:00:00	AAPL	Stock	51.545	51.8475	51.5375	51.8015	12133848.0
2018-08-03 10:30:00	AAPL	Stock	51.8	51.89	51.64	51.6525	8972664.0
2018-08-03 11:00:00	AAPL	Stock	51.655	51.8475	51.625	51.82	6358860.0
2018-08-03 11:30:00	AAPL	Stock	51.8225	51.8325	51.7275	51.755	4784448.0
2018-08-03 12:00:00	AAPL	Stock	51.7575	52.035	51.755	52.0085	8005060.0
2018-08-03 12:30:00	AAPL	Stock	52.0088	52.185	52.0075	52.115	8147572.0
2018-08-03 13:00:00	AAPL	Stock	52.1125	52.1675	52.02	52.0475	5113080.0
2018-08-03 13:30:00	AAPL	Stock	52.045	52.08	51.95	52.0588	4006748.0
2018-08-03 14:00:00	AAPL	Stock	52.0592	52.06	51.8985	51.94	4073624.0
2018-08-03 14:30:00	AAPL	Stock	51.9425	51.9575	51.8325	51.87	4664604.0
2018-08-03 15:00:00	AAPL	Stock	51.87	51.99	51.8575	51.8935	5069380.0
2018-08-03 15:30:00	AAPL	Stock	51.895	52.0	51.8775	51.995	10067596.0
2018-08-03 16:00:00	AAPL	Stock	51.975	52.0422	51.9375	52.0175	7366352.0
2018-08-03 16:30:00	AAPL	Stock	52.02	52.025	51.9975	52.0125	245828.0
2018-08-03 17:00:00	AAPL	Stock	52.02	52.025	52.0075	52.0075	28172.0
2018-08-03 17:30:00	AAPL	Stock	52.01	52.01	51.9825	51.9825	44000.0
2018-08-03 18:00:00	AAPL	Stock	51.9875	52.02	51.9775	52.0	25424.0
2018-08-03 18:30:00	AAPL	Stock	52.0	52.01	51.99	51.99	11948.0
2018-08-03 19:00:00	AAPL	Stock	51.9875	52.0175	51.9875	52.005	24436.0
2018-08-03 19:30:00	AAPL	Stock	52.005	52.005	51.9825	51.9825	27256.0
2018-08-03 04:00:00	MSFT	Stock	107.7	107.7	107.7	107.7	602.0
2018-08-03 05:00:00	MSFT	Stock	107.89	107.89	107.89	107.89	217.0
2018-08-03 05:30:00	MSFT	Stock	107.9	108.0	107.9	108.0	379.0
2018-08-03 06:00:00	MSFT	Stock	108.05	108.05	108.05	108.05	432.0
2018-08-03 06:30:00	MSFT	Stock	108.0	108.0	108.0	108.0	500.0
2018-08-03 07:00:00	MSFT	Stock	107.96	108.15	107.96	108.15	609.0
2018-08-03 07:30:00	MSFT	Stock	108.06	108.12	108.04	108.12	4376.0
2018-08-03 08:00:00	MSFT	Stock	108.0	108.15	107.75	107.82	18329.0
2018-08-03 08:30:00	MSFT	Stock	107.88	107.88	107.64	107.64	7839.0
2018-08-03 09:00:00	MSFT	Stock	107.7	107.96	107.69	107.7	8528.0
2018-08-03 09:30:00	MSFT	Stock	107.73	107.84	106.82	107.41	2593815.0
2018-08-03 10:00:00	MSFT	Stock	107.4	107.7	107.24	107.66	1501833.0
2018-08-03 10:30:00	MSFT	Stock	107.65	107.67	107.17	107.41	1182644.0
2018-08-03 11:00:00	MSFT	Stock	107.41	107.546	107.22	107.445	927637.0
2018-08-03 11:30:00	MSFT	Stock	107.447	107.45	107.09	107.095	638613.0
2018-08-03 12:00:00	MSFT	Stock	107.1	107.48	107.1	107.345	663653.0
2018-08-03 12:30:00	MSFT	Stock	107.34	107.48	107.23	107.289	518668.0
2018-08-03 13:00:00	MSFT	Stock	107.286	107.53	107.23	107.374	491414.0

> showing 50 of 81,654 rows — these rows as CSV

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