PREVIEW / stock_30min / 2017-08-24

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-24.parquet
  size:    1.6 MB
  rows:    79,206
  symbols: 2,962

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
2017-08-24 04:00:00	AAPL	Stock	39.95	39.95	39.95	39.95	1600.0
2017-08-24 04:30:00	AAPL	Stock	40.005	40.005	40.005	40.005	400.0
2017-08-24 06:00:00	AAPL	Stock	40.0475	40.0475	40.0475	40.0475	400.0
2017-08-24 07:00:00	AAPL	Stock	40.05	40.1625	40.0375	40.1625	37304.0
2017-08-24 07:30:00	AAPL	Stock	40.125	40.1625	40.125	40.145	23892.0
2017-08-24 08:00:00	AAPL	Stock	40.145	40.1725	40.0375	40.1475	134340.0
2017-08-24 08:30:00	AAPL	Stock	40.17	40.17	40.14	40.155	69128.0
2017-08-24 09:00:00	AAPL	Stock	40.15	40.185	40.1125	40.1125	185736.0
2017-08-24 09:30:00	AAPL	Stock	40.1075	40.185	39.7925	39.85	11031140.0
2017-08-24 10:00:00	AAPL	Stock	39.8475	39.985	39.805	39.9325	6781900.0
2017-08-24 10:30:00	AAPL	Stock	39.9345	40.03	39.9225	39.935	4753456.0
2017-08-24 11:00:00	AAPL	Stock	39.9375	39.96	39.6775	39.73	7303656.0
2017-08-24 11:30:00	AAPL	Stock	39.73	39.8032	39.6375	39.765	6268036.0
2017-08-24 12:00:00	AAPL	Stock	39.7625	39.81	39.705	39.76	3237648.0
2017-08-24 12:30:00	AAPL	Stock	39.7612	39.835	39.7075	39.7885	3149020.0
2017-08-24 13:00:00	AAPL	Stock	39.785	39.9025	39.7625	39.8885	3203932.0
2017-08-24 13:30:00	AAPL	Stock	39.89	39.8975	39.8225	39.8575	2931944.0
2017-08-24 14:00:00	AAPL	Stock	39.8575	39.8825	39.7325	39.805	3236556.0
2017-08-24 14:30:00	AAPL	Stock	39.805	39.88	39.795	39.8725	2353808.0
2017-08-24 15:00:00	AAPL	Stock	39.87	39.91	39.78	39.87	3830296.0
2017-08-24 15:30:00	AAPL	Stock	39.8675	39.885	39.775	39.8275	6267020.0
2017-08-24 16:00:00	AAPL	Stock	39.82	39.84	39.8025	39.8075	4052284.0
2017-08-24 16:30:00	AAPL	Stock	39.8	39.85	39.78	39.8375	1935048.0
2017-08-24 17:00:00	AAPL	Stock	39.8375	39.85	39.835	39.85	34208.0
2017-08-24 17:30:00	AAPL	Stock	39.8175	39.8725	39.8175	39.85	84112.0
2017-08-24 18:00:00	AAPL	Stock	39.85	39.85	39.84	39.85	3216.0
2017-08-24 18:30:00	AAPL	Stock	39.85	39.85	39.85	39.85	7000.0
2017-08-24 19:00:00	AAPL	Stock	39.85	39.85	39.835	39.835	4000.0
2017-08-24 19:30:00	AAPL	Stock	39.835	39.835	39.83	39.83	4260.0
2017-08-24 04:00:00	MSFT	Stock	72.72	72.72	72.72	72.72	100.0
2017-08-24 07:30:00	MSFT	Stock	73.05	73.05	73.05	73.05	100.0
2017-08-24 08:00:00	MSFT	Stock	72.91	72.91	72.91	72.91	1336.0
2017-08-24 08:30:00	MSFT	Stock	72.92	72.98	72.92	72.98	1367.0
2017-08-24 09:00:00	MSFT	Stock	72.97	72.97	72.73	72.74	21016.0
2017-08-24 09:30:00	MSFT	Stock	72.74	72.86	72.57	72.625	1771288.0
2017-08-24 10:00:00	MSFT	Stock	72.63	72.68	72.47	72.65	1104743.0
2017-08-24 10:30:00	MSFT	Stock	72.65	72.77	72.63	72.68	606457.0
2017-08-24 11:00:00	MSFT	Stock	72.69	72.725	72.18	72.25	1158844.0
2017-08-24 11:30:00	MSFT	Stock	72.245	72.3	72.07	72.3	764102.0
2017-08-24 12:00:00	MSFT	Stock	72.295	72.32	72.145	72.24	448191.0
2017-08-24 12:30:00	MSFT	Stock	72.24	72.395	72.2	72.375	588214.0
2017-08-24 13:00:00	MSFT	Stock	72.37	72.62	72.34	72.59	613634.0
2017-08-24 13:30:00	MSFT	Stock	72.595	72.6	72.46	72.57	312795.0
2017-08-24 14:00:00	MSFT	Stock	72.56	72.66	72.48	72.55	601608.0
2017-08-24 14:30:00	MSFT	Stock	72.558	72.7	72.535	72.66	562725.0
2017-08-24 15:00:00	MSFT	Stock	72.665	72.76	72.55	72.735	698472.0
2017-08-24 15:30:00	MSFT	Stock	72.73	72.78	72.57	72.7	1749533.0
2017-08-24 16:00:00	MSFT	Stock	72.69	72.76	72.65	72.69	3298521.0
2017-08-24 16:30:00	MSFT	Stock	72.76	72.8	72.69	72.69	698871.0
2017-08-24 17:00:00	MSFT	Stock	72.75	72.75	72.75	72.75	300.0

> showing 50 of 79,206 rows — these rows as CSV

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