PREVIEW / stock_30min / 2018-01-17

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-17.parquet
  size:    1.7 MB
  rows:    84,594
  symbols: 2,909

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-01-17 04:00:00	AAPL	Stock	43.5525	43.735	43.3	43.56	182728.0
2018-01-17 04:30:00	AAPL	Stock	43.5025	43.6	43.5	43.6	50900.0
2018-01-17 05:00:00	AAPL	Stock	43.6225	43.66	43.62	43.66	23852.0
2018-01-17 05:30:00	AAPL	Stock	43.625	43.6475	43.5875	43.6475	14240.0
2018-01-17 06:00:00	AAPL	Stock	43.6475	43.8775	43.6475	43.825	64892.0
2018-01-17 06:30:00	AAPL	Stock	43.815	44.005	43.815	43.875	98528.0
2018-01-17 07:00:00	AAPL	Stock	43.875	44.05	43.8375	43.9875	102476.0
2018-01-17 07:30:00	AAPL	Stock	43.975	44.0	43.8875	43.905	95360.0
2018-01-17 08:00:00	AAPL	Stock	43.8775	44.0475	43.83	43.85	196772.0
2018-01-17 08:30:00	AAPL	Stock	43.83	44.15	43.825	44.1	316880.0
2018-01-17 09:00:00	AAPL	Stock	44.1	44.175	44.0175	44.0375	284004.0
2018-01-17 09:30:00	AAPL	Stock	44.0375	44.0525	43.7675	43.9125	14354204.0
2018-01-17 10:00:00	AAPL	Stock	43.9162	44.0125	43.8	43.8402	6131064.0
2018-01-17 10:30:00	AAPL	Stock	43.84	43.9475	43.8225	43.92	5377944.0
2018-01-17 11:00:00	AAPL	Stock	43.92	43.9775	43.854	43.9375	4583200.0
2018-01-17 11:30:00	AAPL	Stock	43.94	43.975	43.855	43.8925	2924772.0
2018-01-17 12:00:00	AAPL	Stock	43.89	43.945	43.86	43.92	2811768.0
2018-01-17 12:30:00	AAPL	Stock	43.9175	43.9975	43.904	43.989	3207612.0
2018-01-17 13:00:00	AAPL	Stock	43.9875	44.325	43.905	44.271	14009032.0
2018-01-17 13:30:00	AAPL	Stock	44.2675	44.38	44.1632	44.1875	8651320.0
2018-01-17 14:00:00	AAPL	Stock	44.1775	44.3525	44.1528	44.3225	4973360.0
2018-01-17 14:30:00	AAPL	Stock	44.32	44.64	44.3175	44.62	12467616.0
2018-01-17 15:00:00	AAPL	Stock	44.615	44.7875	44.61	44.665	12137192.0
2018-01-17 15:30:00	AAPL	Stock	44.665	44.8125	44.655	44.775	16217800.0
2018-01-17 16:00:00	AAPL	Stock	44.775	44.785	44.0475	44.7675	13076260.0
2018-01-17 16:30:00	AAPL	Stock	44.7675	44.815	44.7675	44.8	255512.0
2018-01-17 17:00:00	AAPL	Stock	44.8	44.82	44.775	44.8125	1200048.0
2018-01-17 17:30:00	AAPL	Stock	44.805	44.8225	44.7875	44.82	64176.0
2018-01-17 18:00:00	AAPL	Stock	44.8175	44.8625	44.8175	44.86	210144.0
2018-01-17 18:30:00	AAPL	Stock	44.86	44.8625	44.85	44.8625	63624.0
2018-01-17 19:00:00	AAPL	Stock	44.8625	44.8625	44.85	44.86	54476.0
2018-01-17 19:30:00	AAPL	Stock	44.86	44.8625	44.8425	44.8625	82048.0
2018-01-17 06:00:00	MSFT	Stock	88.8	88.8	88.8	88.8	500.0
2018-01-17 07:00:00	MSFT	Stock	88.72	88.85	88.5	88.85	5341.0
2018-01-17 07:30:00	MSFT	Stock	88.9	88.9	88.75	88.77	1914.0
2018-01-17 08:00:00	MSFT	Stock	88.82	88.9	88.55	88.8	7722.0
2018-01-17 08:30:00	MSFT	Stock	88.8	88.9	88.7	88.84	13840.0
2018-01-17 09:00:00	MSFT	Stock	88.8	89.5	88.65	89.13	41391.0
2018-01-17 09:30:00	MSFT	Stock	89.13	89.39	88.75	88.97	3390670.0
2018-01-17 10:00:00	MSFT	Stock	88.97	89.59	88.96	89.43	1660858.0
2018-01-17 10:30:00	MSFT	Stock	89.43	89.98	89.418	89.93	1429614.0
2018-01-17 11:00:00	MSFT	Stock	89.93	90.05	89.71	89.91	1353023.0
2018-01-17 11:30:00	MSFT	Stock	89.92	89.94	89.745	89.865	713161.0
2018-01-17 12:00:00	MSFT	Stock	89.864	90.03	89.82	90.0	776638.0
2018-01-17 12:30:00	MSFT	Stock	90.0	90.17	89.99	90.105	804088.0
2018-01-17 13:00:00	MSFT	Stock	90.11	90.28	90.07	90.19	1163474.0
2018-01-17 13:30:00	MSFT	Stock	90.185	90.2	89.96	89.995	948406.0
2018-01-17 14:00:00	MSFT	Stock	89.995	90.22	89.99	90.09	1084370.0
2018-01-17 14:30:00	MSFT	Stock	90.084	90.21	90.03	90.15	887487.0
2018-01-17 15:00:00	MSFT	Stock	90.145	90.21	89.98	90.01	1694071.0

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

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