PREVIEW / stock_30min / 2018-08-10

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-10.parquet
  size:    1.7 MB
  rows:    82,151
  symbols: 2,773

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-10 04:00:00	AAPL	Stock	51.975	51.975	51.75	51.8025	27440.0
2018-08-10 04:30:00	AAPL	Stock	51.8125	51.85	51.78	51.8475	15920.0
2018-08-10 05:00:00	AAPL	Stock	51.8475	51.8725	51.8475	51.8725	6724.0
2018-08-10 05:30:00	AAPL	Stock	51.8725	51.8725	51.8125	51.825	21248.0
2018-08-10 06:00:00	AAPL	Stock	51.8	51.8775	51.8	51.8725	18920.0
2018-08-10 06:30:00	AAPL	Stock	51.8725	51.9	51.8575	51.8875	24424.0
2018-08-10 07:00:00	AAPL	Stock	51.9175	51.9675	51.8875	51.9225	101124.0
2018-08-10 07:30:00	AAPL	Stock	51.9125	51.9375	51.85	51.85	74944.0
2018-08-10 08:00:00	AAPL	Stock	51.9105	51.9625	51.8375	51.88	254876.0
2018-08-10 08:30:00	AAPL	Stock	51.885	51.9325	51.8625	51.8625	169208.0
2018-08-10 09:00:00	AAPL	Stock	51.8575	51.87	51.8	51.825	410732.0
2018-08-10 09:30:00	AAPL	Stock	51.84	52.275	51.8075	52.0125	13929948.0
2018-08-10 10:00:00	AAPL	Stock	52.0125	52.225	51.9675	52.1225	7457124.0
2018-08-10 10:30:00	AAPL	Stock	52.1225	52.2475	51.97	51.9975	7690840.0
2018-08-10 11:00:00	AAPL	Stock	51.995	52.1175	51.9625	52.0725	5524308.0
2018-08-10 11:30:00	AAPL	Stock	52.0725	52.125	51.9662	51.995	3966868.0
2018-08-10 12:00:00	AAPL	Stock	51.9925	52.0415	51.95	52.0175	2751892.0
2018-08-10 12:30:00	AAPL	Stock	52.02	52.04	51.9375	51.972	2498244.0
2018-08-10 13:00:00	AAPL	Stock	51.97	51.985	51.8875	51.905	2471704.0
2018-08-10 13:30:00	AAPL	Stock	51.905	51.9125	51.6675	51.7325	5138352.0
2018-08-10 14:00:00	AAPL	Stock	51.7325	51.8225	51.67	51.6875	4383928.0
2018-08-10 14:30:00	AAPL	Stock	51.69	51.8375	51.69	51.8062	3797320.0
2018-08-10 15:00:00	AAPL	Stock	51.8075	51.985	51.7682	51.9588	5615684.0
2018-08-10 15:30:00	AAPL	Stock	51.96	51.9725	51.87	51.8875	7633808.0
2018-08-10 16:00:00	AAPL	Stock	51.8825	51.94	51.8825	51.9125	6233528.0
2018-08-10 16:30:00	AAPL	Stock	51.9125	51.93	51.8925	51.925	11972.0
2018-08-10 17:00:00	AAPL	Stock	51.905	51.9125	51.893	51.905	16348.0
2018-08-10 17:30:00	AAPL	Stock	51.8925	51.8925	51.8825	51.8825	25688.0
2018-08-10 18:00:00	AAPL	Stock	51.9075	51.925	51.9075	51.925	2340.0
2018-08-10 18:30:00	AAPL	Stock	51.9075	51.935	51.9075	51.935	9320.0
2018-08-10 19:00:00	AAPL	Stock	51.9375	51.945	51.9375	51.9375	11884.0
2018-08-10 19:30:00	AAPL	Stock	51.9375	51.9375	51.915	51.925	19400.0
2018-08-10 04:00:00	MSFT	Stock	109.0	109.01	109.0	109.01	1000.0
2018-08-10 07:00:00	MSFT	Stock	109.45	109.46	109.45	109.46	470.0
2018-08-10 07:30:00	MSFT	Stock	109.43	109.45	109.15	109.15	2789.0
2018-08-10 08:00:00	MSFT	Stock	109.034	109.5	109.03	109.35	9077.0
2018-08-10 08:30:00	MSFT	Stock	109.3	109.45	109.3	109.31	15414.0
2018-08-10 09:00:00	MSFT	Stock	109.3	109.31	109.1	109.24	15989.0
2018-08-10 09:30:00	MSFT	Stock	109.25	109.69	109.0	109.27	2226575.0
2018-08-10 10:00:00	MSFT	Stock	109.27	109.65	109.1	109.49	1038612.0
2018-08-10 10:30:00	MSFT	Stock	109.48	109.66	109.13	109.415	1121031.0
2018-08-10 11:00:00	MSFT	Stock	109.43	109.59	109.35	109.49	652040.0
2018-08-10 11:30:00	MSFT	Stock	109.49	109.6	109.31	109.37	597635.0
2018-08-10 12:00:00	MSFT	Stock	109.37	109.42	109.25	109.35	560050.0
2018-08-10 12:30:00	MSFT	Stock	109.34	109.47	109.28	109.38	416650.0
2018-08-10 13:00:00	MSFT	Stock	109.37	109.375	109.18	109.205	421837.0
2018-08-10 13:30:00	MSFT	Stock	109.21	109.25	108.77	108.9	901830.0
2018-08-10 14:00:00	MSFT	Stock	108.9	108.985	108.46	108.47	1170249.0
2018-08-10 14:30:00	MSFT	Stock	108.47	108.7	108.38	108.626	797558.0
2018-08-10 15:00:00	MSFT	Stock	108.62	109.13	108.5	109.055	1051504.0

> showing 50 of 82,151 rows — these rows as CSV

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