PREVIEW / stock_30min / 2018-03-16

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-16.parquet
  size:    1.7 MB
  rows:    83,002
  symbols: 2,877

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-03-16 04:00:00	AAPL	Stock	44.6625	44.6925	44.555	44.555	3720.0
2018-03-16 04:30:00	AAPL	Stock	44.685	44.685	44.685	44.685	400.0
2018-03-16 05:00:00	AAPL	Stock	44.7	44.7	44.7	44.7	400.0
2018-03-16 05:30:00	AAPL	Stock	44.655	44.655	44.655	44.655	436.0
2018-03-16 06:30:00	AAPL	Stock	44.645	44.645	44.6	44.63	3692.0
2018-03-16 07:00:00	AAPL	Stock	44.655	44.6975	44.655	44.68	55752.0
2018-03-16 07:30:00	AAPL	Stock	44.68	44.6875	44.61	44.61	56880.0
2018-03-16 08:00:00	AAPL	Stock	44.687	44.7	44.575	44.615	168616.0
2018-03-16 08:30:00	AAPL	Stock	44.64	44.75	44.6325	44.7	132876.0
2018-03-16 09:00:00	AAPL	Stock	44.69	44.7325	44.615	44.6625	395260.0
2018-03-16 09:30:00	AAPL	Stock	44.6525	44.78	44.5375	44.6675	29949840.0
2018-03-16 10:00:00	AAPL	Stock	44.6688	44.71	44.58	44.6512	6348400.0
2018-03-16 10:30:00	AAPL	Stock	44.6525	44.67	44.5775	44.6518	4210976.0
2018-03-16 11:00:00	AAPL	Stock	44.6512	44.6875	44.5575	44.6175	4126968.0
2018-03-16 11:30:00	AAPL	Stock	44.62	44.655	44.405	44.435	5971656.0
2018-03-16 12:00:00	AAPL	Stock	44.44	44.5675	44.4225	44.547	3560064.0
2018-03-16 12:30:00	AAPL	Stock	44.545	44.65	44.5125	44.645	3904160.0
2018-03-16 13:00:00	AAPL	Stock	44.645	44.68	44.565	44.5775	3115800.0
2018-03-16 13:30:00	AAPL	Stock	44.5785	44.6375	44.565	44.6325	2674816.0
2018-03-16 14:00:00	AAPL	Stock	44.635	44.665	44.5475	44.6075	3666712.0
2018-03-16 14:30:00	AAPL	Stock	44.605	44.675	44.58	44.6625	2684864.0
2018-03-16 15:00:00	AAPL	Stock	44.66	44.685	44.615	44.6425	4023280.0
2018-03-16 15:30:00	AAPL	Stock	44.6425	44.65	44.4625	44.4725	14069412.0
2018-03-16 16:00:00	AAPL	Stock	44.505	44.625	44.4825	44.5	41542708.0
2018-03-16 16:30:00	AAPL	Stock	44.485	44.505	44.4625	44.4875	52680.0
2018-03-16 17:00:00	AAPL	Stock	44.4925	44.5025	44.4675	44.4925	25956.0
2018-03-16 17:30:00	AAPL	Stock	44.4925	44.505	44.4925	44.5025	4132972.0
2018-03-16 18:00:00	AAPL	Stock	44.5025	44.51	44.485	44.4975	22436.0
2018-03-16 18:30:00	AAPL	Stock	44.4925	44.495	44.4675	44.495	10852.0
2018-03-16 19:00:00	AAPL	Stock	44.47	44.53	44.47	44.5075	10416.0
2018-03-16 19:30:00	AAPL	Stock	44.5375	44.56	44.5025	44.5375	33480.0
2018-03-16 07:00:00	MSFT	Stock	94.6	94.6	94.47	94.47	970.0
2018-03-16 07:30:00	MSFT	Stock	94.38	94.5	94.36	94.5	4586.0
2018-03-16 08:00:00	MSFT	Stock	94.37	94.45	94.37	94.45	1485.0
2018-03-16 08:30:00	MSFT	Stock	94.43	94.43	94.43	94.43	360.0
2018-03-16 09:00:00	MSFT	Stock	94.41	94.74	94.22	94.69	164285.0
2018-03-16 09:30:00	MSFT	Stock	94.69	94.9	94.46	94.9	9524417.0
2018-03-16 10:00:00	MSFT	Stock	94.894	95.309	94.77	95.165	1920791.0
2018-03-16 10:30:00	MSFT	Stock	95.16	95.38	94.73	94.8	1768429.0
2018-03-16 11:00:00	MSFT	Stock	94.78	94.96	94.48	94.62	921939.0
2018-03-16 11:30:00	MSFT	Stock	94.62	94.7	93.92	93.97	1362803.0
2018-03-16 12:00:00	MSFT	Stock	93.97	94.335	93.965	94.155	1086009.0
2018-03-16 12:30:00	MSFT	Stock	94.15	94.29	94.04	94.176	880318.0
2018-03-16 13:00:00	MSFT	Stock	94.175	94.24	94.025	94.09	810888.0
2018-03-16 13:30:00	MSFT	Stock	94.09	94.25	94.03	94.065	889486.0
2018-03-16 14:00:00	MSFT	Stock	94.08	94.19	93.96	94.14	1134328.0
2018-03-16 14:30:00	MSFT	Stock	94.144	94.311	94.075	94.2	1509327.0
2018-03-16 15:00:00	MSFT	Stock	94.2	94.26	94.08	94.2	1384940.0
2018-03-16 15:30:00	MSFT	Stock	94.2	94.68	94.025	94.49	7373826.0
2018-03-16 16:00:00	MSFT	Stock	94.51	94.73	94.4	94.65	14474893.0

> showing 50 of 83,002 rows — these rows as CSV

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