PREVIEW / stock_30min / 2018-07-20

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-20.parquet
  size:    1.6 MB
  rows:    81,386
  symbols: 2,781

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-07-20 04:30:00	AAPL	Stock	48.1225	48.125	48.0725	48.0725	9016.0
2018-07-20 05:30:00	AAPL	Stock	48.075	48.1225	48.075	48.1225	5584.0
2018-07-20 06:00:00	AAPL	Stock	48.015	48.09	47.78	47.8475	38180.0
2018-07-20 06:30:00	AAPL	Stock	47.8475	47.975	47.8475	47.975	5516.0
2018-07-20 07:00:00	AAPL	Stock	47.99	48.025	47.8925	47.96	40592.0
2018-07-20 07:30:00	AAPL	Stock	47.96	48.0	47.93	47.95	38064.0
2018-07-20 08:00:00	AAPL	Stock	47.995	48.025	47.9025	47.92	71968.0
2018-07-20 08:30:00	AAPL	Stock	47.905	47.945	47.8775	47.9	225124.0
2018-07-20 09:00:00	AAPL	Stock	47.9125	48.075	47.9	47.94	224616.0
2018-07-20 09:30:00	AAPL	Stock	47.94	48.075	47.8925	48.015	10774072.0
2018-07-20 10:00:00	AAPL	Stock	48.015	48.071	47.985	48.0025	3671164.0
2018-07-20 10:30:00	AAPL	Stock	48.0025	48.1075	47.97	48.0375	2981340.0
2018-07-20 11:00:00	AAPL	Stock	48.0375	48.083	48.02	48.0675	2532752.0
2018-07-20 11:30:00	AAPL	Stock	48.0675	48.0775	47.97	48.0125	2048236.0
2018-07-20 12:00:00	AAPL	Stock	48.0125	48.0125	47.9025	47.9662	3472620.0
2018-07-20 12:30:00	AAPL	Stock	47.965	48.025	47.9328	47.97	2662704.0
2018-07-20 13:00:00	AAPL	Stock	47.9675	48.0112	47.9138	47.9312	1750916.0
2018-07-20 13:30:00	AAPL	Stock	47.93	47.9675	47.915	47.95	1315736.0
2018-07-20 14:00:00	AAPL	Stock	47.95	47.9638	47.92	47.955	1917180.0
2018-07-20 14:30:00	AAPL	Stock	47.9538	47.965	47.8175	47.8575	2427180.0
2018-07-20 15:00:00	AAPL	Stock	47.855	47.87	47.6175	47.6698	4210156.0
2018-07-20 15:30:00	AAPL	Stock	47.6725	47.995	47.5425	47.9175	13801556.0
2018-07-20 16:00:00	AAPL	Stock	47.9175	47.9175	47.6925	47.83	16672420.0
2018-07-20 16:30:00	AAPL	Stock	47.835	47.85	47.8	47.81	21332.0
2018-07-20 17:00:00	AAPL	Stock	47.86	47.86	47.8075	47.85	1066344.0
2018-07-20 17:30:00	AAPL	Stock	47.86	47.86	47.84	47.84	6420.0
2018-07-20 18:00:00	AAPL	Stock	47.84	47.845	47.8275	47.83	24232.0
2018-07-20 18:30:00	AAPL	Stock	47.8275	47.8275	47.815	47.8175	6372.0
2018-07-20 19:00:00	AAPL	Stock	47.8225	47.85	47.8225	47.8225	7612.0
2018-07-20 19:30:00	AAPL	Stock	47.85	47.85	47.82	47.8325	7952.0
2018-07-20 04:00:00	MSFT	Stock	107.99	108.33	107.81	108.33	4345.0
2018-07-20 04:30:00	MSFT	Stock	108.15	108.5	108.12	108.31	11827.0
2018-07-20 05:00:00	MSFT	Stock	108.31	108.93	108.31	108.93	6479.0
2018-07-20 05:30:00	MSFT	Stock	108.75	108.75	108.33	108.43	5818.0
2018-07-20 06:00:00	MSFT	Stock	108.5	108.5	107.6	107.6	13817.0
2018-07-20 06:30:00	MSFT	Stock	107.6	108.4	107.6	108.25	15944.0
2018-07-20 07:00:00	MSFT	Stock	108.24	108.3	107.7	108.09	89488.0
2018-07-20 07:30:00	MSFT	Stock	108.14	108.34	107.62	107.81	87830.0
2018-07-20 08:00:00	MSFT	Stock	107.9	108.35	107.5	107.99	267506.0
2018-07-20 08:30:00	MSFT	Stock	108.0	108.19	107.85	107.98	265943.0
2018-07-20 09:00:00	MSFT	Stock	107.95	108.2	107.27	108.15	868515.0
2018-07-20 09:30:00	MSFT	Stock	108.15	108.2	106.7	107.22	12609406.0
2018-07-20 10:00:00	MSFT	Stock	107.22	107.47	106.72	107.23	5820600.0
2018-07-20 10:30:00	MSFT	Stock	107.225	107.45	106.91	107.3	3469617.0
2018-07-20 11:00:00	MSFT	Stock	107.3	107.56	107.02	107.45	2671426.0
2018-07-20 11:30:00	MSFT	Stock	107.44	107.46	106.95	107.2	2319075.0
2018-07-20 12:00:00	MSFT	Stock	107.195	107.196	106.59	106.615	2220071.0
2018-07-20 12:30:00	MSFT	Stock	106.61	107.07	106.42	106.835	5766584.0
2018-07-20 13:00:00	MSFT	Stock	106.84	107.05	106.63	106.76	1639547.0
2018-07-20 13:30:00	MSFT	Stock	106.75	106.89	106.605	106.845	1131615.0

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

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