PREVIEW / stock_30min / 2018-10-09

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-09.parquet
  size:    1.7 MB
  rows:    84,413
  symbols: 2,800

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-09 04:00:00	AAPL	Stock	55.8675	55.8675	55.7975	55.7975	2476.0
2018-10-09 04:30:00	AAPL	Stock	55.75	55.86	55.75	55.86	816.0
2018-10-09 05:00:00	AAPL	Stock	55.8275	55.8325	55.8	55.8	6912.0
2018-10-09 05:30:00	AAPL	Stock	55.775	55.775	55.775	55.775	400.0
2018-10-09 06:00:00	AAPL	Stock	55.695	55.75	55.675	55.675	3756.0
2018-10-09 06:30:00	AAPL	Stock	55.725	55.79	55.725	55.79	9264.0
2018-10-09 07:00:00	AAPL	Stock	55.845	55.845	55.5525	55.6325	121324.0
2018-10-09 07:30:00	AAPL	Stock	55.65	55.65	55.435	55.475	125184.0
2018-10-09 08:00:00	AAPL	Stock	55.4975	55.85	55.47	55.58	295700.0
2018-10-09 08:30:00	AAPL	Stock	55.5975	55.85	55.5975	55.8425	253228.0
2018-10-09 09:00:00	AAPL	Stock	55.825	55.9075	55.6525	55.9075	333856.0
2018-10-09 09:30:00	AAPL	Stock	55.9075	56.2325	55.5615	56.0338	15170732.0
2018-10-09 10:00:00	AAPL	Stock	56.0325	56.595	55.8325	56.57	9816824.0
2018-10-09 10:30:00	AAPL	Stock	56.572	56.7625	56.51	56.585	9588048.0
2018-10-09 11:00:00	AAPL	Stock	56.59	56.72	56.28	56.622	6947756.0
2018-10-09 11:30:00	AAPL	Stock	56.625	56.695	56.52	56.6375	3396432.0
2018-10-09 12:00:00	AAPL	Stock	56.6412	56.7175	56.4	56.42	3577028.0
2018-10-09 12:30:00	AAPL	Stock	56.425	56.54	56.2325	56.356	3513816.0
2018-10-09 13:00:00	AAPL	Stock	56.35	56.555	56.2075	56.4775	3240340.0
2018-10-09 13:30:00	AAPL	Stock	56.475	56.48	56.1942	56.4075	3126120.0
2018-10-09 14:00:00	AAPL	Stock	56.4025	56.57	56.325	56.47	2898392.0
2018-10-09 14:30:00	AAPL	Stock	56.475	56.7048	56.345	56.6655	3657784.0
2018-10-09 15:00:00	AAPL	Stock	56.6675	56.7325	56.57	56.645	3998500.0
2018-10-09 15:30:00	AAPL	Stock	56.65	56.8175	56.6225	56.7175	9756636.0
2018-10-09 16:00:00	AAPL	Stock	56.7275	56.7275	56.6325	56.7175	5623792.0
2018-10-09 16:30:00	AAPL	Stock	56.7075	56.7075	56.7	56.7075	17824.0
2018-10-09 17:00:00	AAPL	Stock	56.7075	56.7075	56.625	56.6875	12616.0
2018-10-09 17:30:00	AAPL	Stock	56.6875	56.695	56.663	56.685	5176.0
2018-10-09 18:00:00	AAPL	Stock	56.685	56.75	56.6325	56.75	11576.0
2018-10-09 18:30:00	AAPL	Stock	56.75	56.775	56.7125	56.725	11160.0
2018-10-09 19:00:00	AAPL	Stock	56.75	56.7625	56.75	56.75	19020.0
2018-10-09 19:30:00	AAPL	Stock	56.75	56.77	56.72	56.7525	21508.0
2018-10-09 05:00:00	MSFT	Stock	110.75	110.75	110.74	110.74	600.0
2018-10-09 05:30:00	MSFT	Stock	110.51	110.51	110.51	110.51	110.0
2018-10-09 06:00:00	MSFT	Stock	110.5	110.56	110.5	110.56	400.0
2018-10-09 06:30:00	MSFT	Stock	110.6	110.8	110.6	110.8	1141.0
2018-10-09 07:00:00	MSFT	Stock	110.67	110.67	110.2	110.35	11035.0
2018-10-09 07:30:00	MSFT	Stock	110.4	110.48	110.2	110.2	9587.0
2018-10-09 08:00:00	MSFT	Stock	110.65	110.75	110.2	110.75	32265.0
2018-10-09 08:30:00	MSFT	Stock	110.65	110.85	110.5	110.84	22256.0
2018-10-09 09:00:00	MSFT	Stock	110.84	111.19	110.68	111.08	26411.0
2018-10-09 09:30:00	MSFT	Stock	111.14	112.2	110.8	111.87	3344199.0
2018-10-09 10:00:00	MSFT	Stock	111.87	112.39	111.4	112.38	1984926.0
2018-10-09 10:30:00	MSFT	Stock	112.38	113.08	112.38	112.73	2370208.0
2018-10-09 11:00:00	MSFT	Stock	112.735	112.99	112.28	112.86	1535191.0
2018-10-09 11:30:00	MSFT	Stock	112.86	113.02	112.675	112.73	1145877.0
2018-10-09 12:00:00	MSFT	Stock	112.72	112.8	112.11	112.34	1263299.0
2018-10-09 12:30:00	MSFT	Stock	112.33	112.571	111.98	111.99	1109837.0
2018-10-09 13:00:00	MSFT	Stock	112.0	112.28	111.63	112.11	1044951.0
2018-10-09 13:30:00	MSFT	Stock	112.11	112.16	111.68	112.04	765087.0

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

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