PREVIEW / stock_30min / 2017-02-22

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-22.parquet
  size:    1.6 MB
  rows:    82,660
  symbols: 3,113

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-02-22 04:00:00	AAPL	Stock	34.1625	34.1625	34.1625	34.1625	1600.0
2017-02-22 04:30:00	AAPL	Stock	34.1375	34.1375	34.1375	34.1375	3384.0
2017-02-22 05:00:00	AAPL	Stock	34.1275	34.1475	34.1275	34.1275	2400.0
2017-02-22 05:30:00	AAPL	Stock	34.12	34.12	34.1075	34.1075	2152.0
2017-02-22 06:00:00	AAPL	Stock	34.135	34.145	34.095	34.095	2792.0
2017-02-22 06:30:00	AAPL	Stock	34.0875	34.0975	34.0825	34.0825	17016.0
2017-02-22 07:00:00	AAPL	Stock	34.0925	34.1	34.075	34.1	39052.0
2017-02-22 07:30:00	AAPL	Stock	34.1	34.1125	34.085	34.0975	19960.0
2017-02-22 08:00:00	AAPL	Stock	34.1075	34.135	34.075	34.11	65452.0
2017-02-22 08:30:00	AAPL	Stock	34.1125	34.1275	34.1025	34.11	62420.0
2017-02-22 09:00:00	AAPL	Stock	34.11	34.135	34.0925	34.1025	147592.0
2017-02-22 09:30:00	AAPL	Stock	34.115	34.15	34.0275	34.087	11665776.0
2017-02-22 10:00:00	AAPL	Stock	34.0875	34.14	34.0825	34.1162	5345820.0
2017-02-22 10:30:00	AAPL	Stock	34.115	34.145	34.1	34.1125	3560540.0
2017-02-22 11:00:00	AAPL	Stock	34.115	34.1375	34.0895	34.1365	4246332.0
2017-02-22 11:30:00	AAPL	Stock	34.135	34.1675	34.12	34.12	3050896.0
2017-02-22 12:00:00	AAPL	Stock	34.1175	34.16	34.11	34.1565	1897336.0
2017-02-22 12:30:00	AAPL	Stock	34.1552	34.1725	34.14	34.1712	2005584.0
2017-02-22 13:00:00	AAPL	Stock	34.17	34.22	34.1675	34.22	3107496.0
2017-02-22 13:30:00	AAPL	Stock	34.2175	34.28	34.2125	34.2425	4973712.0
2017-02-22 14:00:00	AAPL	Stock	34.2425	34.265	34.18	34.215	3899272.0
2017-02-22 14:30:00	AAPL	Stock	34.2125	34.225	34.1625	34.1625	2374580.0
2017-02-22 15:00:00	AAPL	Stock	34.1625	34.2175	34.14	34.2112	3250932.0
2017-02-22 15:30:00	AAPL	Stock	34.21	34.2775	34.2075	34.275	9374024.0
2017-02-22 16:00:00	AAPL	Stock	34.265	34.3	34.2625	34.275	12118044.0
2017-02-22 16:30:00	AAPL	Stock	34.2775	34.2775	34.2675	34.275	20048.0
2017-02-22 17:00:00	AAPL	Stock	34.275	34.275	34.255	34.2575	47580.0
2017-02-22 17:30:00	AAPL	Stock	34.2625	34.3525	34.2625	34.3125	119424.0
2017-02-22 18:00:00	AAPL	Stock	34.2875	34.305	34.2775	34.295	32296.0
2017-02-22 18:30:00	AAPL	Stock	34.2925	34.2925	34.2925	34.2925	4000.0
2017-02-22 19:00:00	AAPL	Stock	34.2875	34.3	34.2775	34.2775	12152.0
2017-02-22 19:30:00	AAPL	Stock	34.29	34.335	34.275	34.2975	65136.0
2017-02-22 06:30:00	MSFT	Stock	64.5	64.5	64.5	64.5	1905.0
2017-02-22 07:00:00	MSFT	Stock	64.3	64.3	64.3	64.3	185.0
2017-02-22 08:00:00	MSFT	Stock	64.43	64.5	64.43	64.43	11500.0
2017-02-22 08:30:00	MSFT	Stock	64.4	64.4	64.36	64.36	596.0
2017-02-22 09:00:00	MSFT	Stock	64.4	64.43	64.31	64.33	6767.0
2017-02-22 09:30:00	MSFT	Stock	64.35	64.39	64.1	64.22	2050424.0
2017-02-22 10:00:00	MSFT	Stock	64.215	64.35	64.2	64.285	1158630.0
2017-02-22 10:30:00	MSFT	Stock	64.28	64.3	64.17	64.185	1024522.0
2017-02-22 11:00:00	MSFT	Stock	64.19	64.2	64.05	64.08	1292039.0
2017-02-22 11:30:00	MSFT	Stock	64.08	64.22	64.07	64.17	1172281.0
2017-02-22 12:00:00	MSFT	Stock	64.17	64.28	64.16	64.265	720268.0
2017-02-22 12:30:00	MSFT	Stock	64.265	64.31	64.222	64.28	672303.0
2017-02-22 13:00:00	MSFT	Stock	64.275	64.32	64.24	64.25	506066.0
2017-02-22 13:30:00	MSFT	Stock	64.26	64.28	64.2	64.21	468344.0
2017-02-22 14:00:00	MSFT	Stock	64.22	64.245	64.13	64.2	995141.0
2017-02-22 14:30:00	MSFT	Stock	64.2	64.21	64.11	64.174	741016.0
2017-02-22 15:00:00	MSFT	Stock	64.17	64.23	64.14	64.225	1005058.0
2017-02-22 15:30:00	MSFT	Stock	64.22	64.37	64.21	64.36	3407935.0

> showing 50 of 82,660 rows — these rows as CSV

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