PREVIEW / stock_30min / 2018-07-13

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-13.parquet
  size:    1.6 MB
  rows:    81,656
  symbols: 2,796

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-07-13 04:30:00	AAPL	Stock	47.8	47.8	47.8	47.8	660.0
2018-07-13 05:00:00	AAPL	Stock	47.875	47.875	47.875	47.875	2240.0
2018-07-13 05:30:00	AAPL	Stock	47.7575	47.7575	47.7125	47.7125	1248.0
2018-07-13 06:30:00	AAPL	Stock	47.75	47.7875	47.75	47.7875	9144.0
2018-07-13 07:00:00	AAPL	Stock	47.8	47.87	47.75	47.75	66400.0
2018-07-13 07:30:00	AAPL	Stock	47.75	47.7825	47.7175	47.7825	31604.0
2018-07-13 08:00:00	AAPL	Stock	47.8525	47.8525	47.72	47.75	141084.0
2018-07-13 08:30:00	AAPL	Stock	47.735	47.75	47.7	47.7225	55872.0
2018-07-13 09:00:00	AAPL	Stock	47.7275	47.77	47.725	47.7575	45804.0
2018-07-13 09:30:00	AAPL	Stock	47.7575	47.96	47.725	47.8	7719064.0
2018-07-13 10:00:00	AAPL	Stock	47.7975	47.95	47.7825	47.885	3700336.0
2018-07-13 10:30:00	AAPL	Stock	47.8875	47.94	47.83	47.8525	3015716.0
2018-07-13 11:00:00	AAPL	Stock	47.85	47.9	47.8475	47.8713	1807852.0
2018-07-13 11:30:00	AAPL	Stock	47.8713	47.9475	47.84	47.925	3048588.0
2018-07-13 12:00:00	AAPL	Stock	47.93	47.9375	47.895	47.9175	1761688.0
2018-07-13 12:30:00	AAPL	Stock	47.9205	47.9225	47.8478	47.8675	1406136.0
2018-07-13 13:00:00	AAPL	Stock	47.8675	47.8775	47.7775	47.8125	2071704.0
2018-07-13 13:30:00	AAPL	Stock	47.815	47.825	47.7525	47.7625	2020568.0
2018-07-13 14:00:00	AAPL	Stock	47.76	47.88	47.7375	47.87	2858980.0
2018-07-13 14:30:00	AAPL	Stock	47.87	47.8975	47.855	47.8675	1252164.0
2018-07-13 15:00:00	AAPL	Stock	47.87	47.8775	47.8237	47.8575	2411684.0
2018-07-13 15:30:00	AAPL	Stock	47.8575	47.92	47.8275	47.8325	5398460.0
2018-07-13 16:00:00	AAPL	Stock	47.8325	47.8725	47.825	47.835	5811028.0
2018-07-13 16:30:00	AAPL	Stock	47.835	47.85	47.8325	47.85	28692.0
2018-07-13 17:00:00	AAPL	Stock	47.84	47.84	47.8325	47.8375	13520.0
2018-07-13 17:30:00	AAPL	Stock	47.8325	47.845	47.825	47.825	26180.0
2018-07-13 18:00:00	AAPL	Stock	47.8325	47.8325	47.8325	47.8325	400.0
2018-07-13 18:30:00	AAPL	Stock	47.8375	47.8375	47.835	47.835	6748.0
2018-07-13 19:00:00	AAPL	Stock	47.835	47.8375	47.83	47.83	5600.0
2018-07-13 19:30:00	AAPL	Stock	47.83	47.8425	47.83	47.8425	7452.0
2018-07-13 05:00:00	MSFT	Stock	104.45	104.45	104.45	104.45	1221.0
2018-07-13 05:30:00	MSFT	Stock	104.44	104.45	104.25	104.35	1488.0
2018-07-13 06:00:00	MSFT	Stock	104.39	104.39	104.34	104.35	500.0
2018-07-13 06:30:00	MSFT	Stock	104.2	104.44	104.2	104.44	613.0
2018-07-13 07:00:00	MSFT	Stock	104.35	104.42	104.35	104.42	900.0
2018-07-13 07:30:00	MSFT	Stock	104.4	104.43	104.27	104.27	878.0
2018-07-13 08:00:00	MSFT	Stock	104.363	104.5	104.25	104.31	8735.0
2018-07-13 08:30:00	MSFT	Stock	104.31	104.38	104.3	104.32	25988.0
2018-07-13 09:00:00	MSFT	Stock	104.34	104.486	104.22	104.33	19509.0
2018-07-13 09:30:00	MSFT	Stock	104.37	104.608	104.09	104.285	2540960.0
2018-07-13 10:00:00	MSFT	Stock	104.28	104.98	104.27	104.935	2279311.0
2018-07-13 10:30:00	MSFT	Stock	104.94	105.03	104.66	104.829	2001338.0
2018-07-13 11:00:00	MSFT	Stock	104.82	105.08	104.71	104.98	1243458.0
2018-07-13 11:30:00	MSFT	Stock	104.99	105.17	104.84	104.9	1132030.0
2018-07-13 12:00:00	MSFT	Stock	104.905	105.08	104.85	104.995	824231.0
2018-07-13 12:30:00	MSFT	Stock	104.99	105.02	104.87	104.98	666143.0
2018-07-13 13:00:00	MSFT	Stock	104.99	105.18	104.98	105.14	1108242.0
2018-07-13 13:30:00	MSFT	Stock	105.14	105.245	105.07	105.135	1096595.0
2018-07-13 14:00:00	MSFT	Stock	105.135	105.17	104.94	105.025	803901.0
2018-07-13 14:30:00	MSFT	Stock	105.01	105.235	104.96	105.16	646977.0

> showing 50 of 81,656 rows — these rows as CSV

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