PREVIEW / stock_30min / 2017-07-03

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-03.parquet
  size:    1.0 MB
  rows:    49,835
  symbols: 2,927

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-07-03 04:00:00	AAPL	Stock	36.18	36.1825	36.18	36.1825	2644.0
2017-07-03 04:30:00	AAPL	Stock	36.1825	36.1825	36.15	36.15	2000.0
2017-07-03 05:00:00	AAPL	Stock	36.165	36.165	36.165	36.165	1200.0
2017-07-03 05:30:00	AAPL	Stock	36.16	36.16	36.16	36.16	1600.0
2017-07-03 06:00:00	AAPL	Stock	36.16	36.16	36.1125	36.1125	1600.0
2017-07-03 06:30:00	AAPL	Stock	36.125	36.125	36.125	36.125	680.0
2017-07-03 07:00:00	AAPL	Stock	36.14	36.1625	36.1325	36.15	16536.0
2017-07-03 07:30:00	AAPL	Stock	36.15	36.1775	36.15	36.15	3500.0
2017-07-03 08:00:00	AAPL	Stock	36.075	36.1775	36.075	36.1375	35324.0
2017-07-03 08:30:00	AAPL	Stock	36.1375	36.1925	36.005	36.1925	66980.0
2017-07-03 09:00:00	AAPL	Stock	36.2025	36.26	36.1625	36.2425	166916.0
2017-07-03 09:30:00	AAPL	Stock	36.2375	36.325	36.1925	36.193	9309588.0
2017-07-03 10:00:00	AAPL	Stock	36.2	36.225	35.975	36.035	6066016.0
2017-07-03 10:30:00	AAPL	Stock	36.03	36.0525	35.9375	35.94	4747440.0
2017-07-03 11:00:00	AAPL	Stock	35.9402	35.99	35.775	35.9875	6633908.0
2017-07-03 11:30:00	AAPL	Stock	35.99	36.0175	35.9	36.0175	3454588.0
2017-07-03 12:00:00	AAPL	Stock	36.015	36.0162	35.845	35.9238	4592948.0
2017-07-03 12:30:00	AAPL	Stock	35.9225	35.945	35.79	35.875	9575328.0
2017-07-03 13:00:00	AAPL	Stock	35.8775	36.0155	35.8525	35.88	5205868.0
2017-07-03 13:30:00	AAPL	Stock	35.8847	35.8925	35.865	35.875	345172.0
2017-07-03 14:00:00	AAPL	Stock	35.885	35.885	35.8725	35.8775	32096.0
2017-07-03 14:30:00	AAPL	Stock	35.875	35.8775	35.8725	35.8775	44248.0
2017-07-03 15:00:00	AAPL	Stock	35.8725	35.8725	35.8725	35.8725	800.0
2017-07-03 15:30:00	AAPL	Stock	35.8725	35.9	35.8725	35.8912	9948.0
2017-07-03 16:00:00	AAPL	Stock	35.8825	35.8825	35.8825	35.8825	1600.0
2017-07-03 16:30:00	AAPL	Stock	35.8775	35.8775	35.8775	35.8775	1800.0
2017-07-03 05:30:00	MSFT	Stock	69.24	69.24	69.24	69.24	141.0
2017-07-03 07:00:00	MSFT	Stock	69.03	69.03	69.03	69.03	200.0
2017-07-03 07:30:00	MSFT	Stock	69.15	69.15	69.15	69.15	1352.0
2017-07-03 08:00:00	MSFT	Stock	69.15	69.25	69.15	69.25	5083.0
2017-07-03 08:30:00	MSFT	Stock	69.25	69.45	68.93	69.45	12453.0
2017-07-03 09:00:00	MSFT	Stock	69.43	69.44	69.23	69.36	21904.0
2017-07-03 09:30:00	MSFT	Stock	69.33	69.6	69.01	69.06	2484891.0
2017-07-03 10:00:00	MSFT	Stock	69.055	69.113	68.755	68.86	1317058.0
2017-07-03 10:30:00	MSFT	Stock	68.85	68.92	68.65	68.67	1408747.0
2017-07-03 11:00:00	MSFT	Stock	68.66	68.705	68.402	68.53	1440188.0
2017-07-03 11:30:00	MSFT	Stock	68.53	68.73	68.53	68.715	1299335.0
2017-07-03 12:00:00	MSFT	Stock	68.71	68.74	68.31	68.375	1459936.0
2017-07-03 12:30:00	MSFT	Stock	68.38	68.405	68.02	68.16	3358913.0
2017-07-03 13:00:00	MSFT	Stock	68.16	68.684	68.08	68.193	1812825.0
2017-07-03 13:30:00	MSFT	Stock	68.18	68.2	68.15	68.194	69953.0
2017-07-03 14:00:00	MSFT	Stock	68.17	68.197	68.17	68.197	22292.0
2017-07-03 14:30:00	MSFT	Stock	68.17	68.17	68.17	68.17	16668.0
2017-07-03 15:00:00	MSFT	Stock	68.18	68.18	68.18	68.18	378.0
2017-07-03 15:30:00	MSFT	Stock	68.16	68.18	68.16	68.18	2494.0
2017-07-03 16:00:00	MSFT	Stock	68.18	68.2	68.18	68.2	487.0
2017-07-03 16:30:00	MSFT	Stock	68.2	68.2	68.2	68.2	600.0
2017-07-03 04:00:00	NVDA	Stock	3.6425	3.6595	3.6425	3.6425	40080.0
2017-07-03 04:30:00	NVDA	Stock	3.66	3.6625	3.6483	3.6483	165000.0
2017-07-03 05:00:00	NVDA	Stock	3.6622	3.6622	3.6438	3.6445	99600.0

> showing 50 of 49,835 rows — these rows as CSV

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