PREVIEW / stock_30min / 2018-02-08

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-08.parquet
  size:    1.7 MB
  rows:    85,282
  symbols: 2,880

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-02-08 04:00:00	AAPL	Stock	39.95	39.9775	39.8875	39.9225	37640.0
2018-02-08 04:30:00	AAPL	Stock	39.8875	39.9475	39.8875	39.9225	14236.0
2018-02-08 05:00:00	AAPL	Stock	39.8725	39.875	39.83	39.83	10692.0
2018-02-08 05:30:00	AAPL	Stock	39.8625	39.8625	39.825	39.825	25716.0
2018-02-08 06:00:00	AAPL	Stock	39.815	39.875	39.775	39.835	48408.0
2018-02-08 06:30:00	AAPL	Stock	39.7925	39.7925	39.725	39.775	40152.0
2018-02-08 07:00:00	AAPL	Stock	39.775	39.885	39.7725	39.885	66828.0
2018-02-08 07:30:00	AAPL	Stock	39.885	40.115	39.885	40.025	195492.0
2018-02-08 08:00:00	AAPL	Stock	40.0375	40.1425	39.7775	40.1425	251160.0
2018-02-08 08:30:00	AAPL	Stock	40.1425	40.2	40.125	40.1825	317084.0
2018-02-08 09:00:00	AAPL	Stock	40.18	40.25	40.0625	40.0725	262316.0
2018-02-08 09:30:00	AAPL	Stock	40.075	40.1975	39.9075	40.04	18506212.0
2018-02-08 10:00:00	AAPL	Stock	40.04	40.2225	39.925	39.9525	12384496.0
2018-02-08 10:30:00	AAPL	Stock	39.9562	40.13	39.8925	40.0225	12850192.0
2018-02-08 11:00:00	AAPL	Stock	40.0225	40.125	39.87	39.9325	14003240.0
2018-02-08 11:30:00	AAPL	Stock	39.925	40.25	39.885	40.1025	13989912.0
2018-02-08 12:00:00	AAPL	Stock	40.1025	40.1375	39.7275	39.85	11788744.0
2018-02-08 12:30:00	AAPL	Stock	39.85	40.0	39.465	39.6975	14262404.0
2018-02-08 13:00:00	AAPL	Stock	39.6922	39.98	39.605	39.6775	12314784.0
2018-02-08 13:30:00	AAPL	Stock	39.68	40.0675	39.6425	39.9618	8987948.0
2018-02-08 14:00:00	AAPL	Stock	39.96	40.03	39.77	39.805	7567844.0
2018-02-08 14:30:00	AAPL	Stock	39.8	39.835	39.6175	39.7125	8131496.0
2018-02-08 15:00:00	AAPL	Stock	39.72	39.8458	39.6	39.695	10796764.0
2018-02-08 15:30:00	AAPL	Stock	39.6925	39.76	38.7575	38.79	28653548.0
2018-02-08 16:00:00	AAPL	Stock	38.7875	39.235	38.7875	39.1225	14351356.0
2018-02-08 16:30:00	AAPL	Stock	39.1225	39.1475	38.7875	39.0825	230500.0
2018-02-08 17:00:00	AAPL	Stock	39.0425	39.2225	38.7875	39.21	332436.0
2018-02-08 17:30:00	AAPL	Stock	39.2	39.2	39.075	39.1125	165072.0
2018-02-08 18:00:00	AAPL	Stock	39.1125	39.1625	38.885	38.95	138216.0
2018-02-08 18:30:00	AAPL	Stock	38.95	38.975	38.85	38.8875	178724.0
2018-02-08 19:00:00	AAPL	Stock	38.8875	39.1125	38.8775	39.0175	46056.0
2018-02-08 19:30:00	AAPL	Stock	39.0225	39.0625	38.9875	39.0625	113140.0
2018-02-08 04:00:00	MSFT	Stock	89.47	89.47	89.47	89.47	100.0
2018-02-08 05:00:00	MSFT	Stock	89.32	89.32	89.32	89.32	600.0
2018-02-08 06:00:00	MSFT	Stock	89.41	89.41	89.01	89.01	1638.0
2018-02-08 06:30:00	MSFT	Stock	89.1	89.1	89.1	89.1	100.0
2018-02-08 07:00:00	MSFT	Stock	89.43	89.47	89.1	89.3	7902.0
2018-02-08 07:30:00	MSFT	Stock	89.39	89.8	89.39	89.75	14916.0
2018-02-08 08:00:00	MSFT	Stock	89.3	90.45	89.3	90.45	35104.0
2018-02-08 08:30:00	MSFT	Stock	90.36	90.5	89.63	89.95	26371.0
2018-02-08 09:00:00	MSFT	Stock	90.1	90.2	89.72	89.72	34271.0
2018-02-08 09:30:00	MSFT	Stock	89.71	89.875	88.72	89.11	4046981.0
2018-02-08 10:00:00	MSFT	Stock	89.12	89.52	88.74	88.91	2332107.0
2018-02-08 10:30:00	MSFT	Stock	88.9	89.02	87.81	88.12	2361786.0
2018-02-08 11:00:00	MSFT	Stock	88.11	88.54	87.65	87.79	2529047.0
2018-02-08 11:30:00	MSFT	Stock	87.8	88.76	87.71	88.37	2527465.0
2018-02-08 12:00:00	MSFT	Stock	88.37	88.59	87.19	87.45	2646677.0
2018-02-08 12:30:00	MSFT	Stock	87.44	87.77	86.53	86.95	3670755.0
2018-02-08 13:00:00	MSFT	Stock	86.94	87.48	86.58	86.75	3683662.0
2018-02-08 13:30:00	MSFT	Stock	86.75	87.87	86.69	87.62	2658304.0

> showing 50 of 85,282 rows — these rows as CSV

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