PREVIEW / stock_30min / 2017-10-12

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-12.parquet
  size:    1.6 MB
  rows:    82,213
  symbols: 2,954

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-10-12 05:30:00	AAPL	Stock	39.1	39.1	39.1	39.1	1040.0
2017-10-12 07:00:00	AAPL	Stock	39.0625	39.1	39.0625	39.0875	6572.0
2017-10-12 07:30:00	AAPL	Stock	39.1	39.1	39.05	39.075	17808.0
2017-10-12 08:00:00	AAPL	Stock	39.1	39.225	39.05	39.0925	67528.0
2017-10-12 08:30:00	AAPL	Stock	39.1	39.1125	39.0425	39.05	50292.0
2017-10-12 09:00:00	AAPL	Stock	39.0425	39.125	39.0425	39.0975	99204.0
2017-10-12 09:30:00	AAPL	Stock	39.105	39.3425	39.0675	39.22	11277892.0
2017-10-12 10:00:00	AAPL	Stock	39.2212	39.275	39.1225	39.185	6687388.0
2017-10-12 10:30:00	AAPL	Stock	39.185	39.215	39.1425	39.205	4041508.0
2017-10-12 11:00:00	AAPL	Stock	39.2025	39.2375	39.1875	39.2225	2980496.0
2017-10-12 11:30:00	AAPL	Stock	39.2225	39.2375	39.2	39.2225	1961700.0
2017-10-12 12:00:00	AAPL	Stock	39.225	39.2862	39.2238	39.2625	3091768.0
2017-10-12 12:30:00	AAPL	Stock	39.26	39.26	39.19	39.1925	2077344.0
2017-10-12 13:00:00	AAPL	Stock	39.19	39.2425	39.1775	39.235	1537360.0
2017-10-12 13:30:00	AAPL	Stock	39.2348	39.245	39.18	39.195	1754240.0
2017-10-12 14:00:00	AAPL	Stock	39.195	39.1975	39.1375	39.14	2009796.0
2017-10-12 14:30:00	AAPL	Stock	39.14	39.16	39.063	39.0712	3757180.0
2017-10-12 15:00:00	AAPL	Stock	39.0725	39.105	39.0575	39.0638	3212296.0
2017-10-12 15:30:00	AAPL	Stock	39.0625	39.0625	38.9325	39.0025	10065288.0
2017-10-12 16:00:00	AAPL	Stock	39.0	39.0	38.95	38.9625	3815452.0
2017-10-12 16:30:00	AAPL	Stock	39.0	39.1375	38.965	38.965	1123348.0
2017-10-12 17:00:00	AAPL	Stock	38.9625	38.99	38.9625	38.98	6800.0
2017-10-12 17:30:00	AAPL	Stock	38.9525	38.9675	38.9525	38.9675	2200.0
2017-10-12 18:00:00	AAPL	Stock	38.965	38.965	38.95	38.96	7956.0
2017-10-12 18:30:00	AAPL	Stock	38.96	38.9725	38.95	38.95	11564.0
2017-10-12 19:00:00	AAPL	Stock	38.975	38.975	38.975	38.975	1600.0
2017-10-12 19:30:00	AAPL	Stock	38.9725	38.9875	38.95	38.95	14036.0
2017-10-12 08:30:00	MSFT	Stock	76.21	76.21	76.21	76.21	100.0
2017-10-12 09:00:00	MSFT	Stock	76.22	76.4	76.22	76.4	3126.0
2017-10-12 09:30:00	MSFT	Stock	76.49	76.89	76.37	76.82	1607677.0
2017-10-12 10:00:00	MSFT	Stock	76.82	76.979	76.76	76.965	1037312.0
2017-10-12 10:30:00	MSFT	Stock	76.96	77.115	76.885	77.1	1355494.0
2017-10-12 11:00:00	MSFT	Stock	77.1	77.168	76.985	77.16	950414.0
2017-10-12 11:30:00	MSFT	Stock	77.165	77.29	77.11	77.189	998487.0
2017-10-12 12:00:00	MSFT	Stock	77.185	77.26	77.044	77.12	754401.0
2017-10-12 12:30:00	MSFT	Stock	77.12	77.18	77.04	77.137	513757.0
2017-10-12 13:00:00	MSFT	Stock	77.14	77.19	77.08	77.13	648108.0
2017-10-12 13:30:00	MSFT	Stock	77.125	77.18	77.06	77.12	538608.0
2017-10-12 14:00:00	MSFT	Stock	77.11	77.14	77.065	77.075	420928.0
2017-10-12 14:30:00	MSFT	Stock	77.08	77.14	76.96	77.06	922780.0
2017-10-12 15:00:00	MSFT	Stock	77.06	77.1	76.98	77.045	656852.0
2017-10-12 15:30:00	MSFT	Stock	77.04	77.18	76.95	77.13	2908813.0
2017-10-12 16:00:00	MSFT	Stock	77.12	77.22	77.025	77.22	2283199.0
2017-10-12 16:30:00	MSFT	Stock	77.12	77.15	76.42	76.42	407837.0
2017-10-12 17:30:00	MSFT	Stock	77.07	77.19	77.04	77.17	1081.0
2017-10-12 18:00:00	MSFT	Stock	77.04	77.05	77.01	77.05	993.0
2017-10-12 18:30:00	MSFT	Stock	77.18	77.18	77.18	77.18	901.0
2017-10-12 19:00:00	MSFT	Stock	77.18	77.18	77.18	77.18	142.0
2017-10-12 04:00:00	NVDA	Stock	4.7895	4.8	4.7895	4.8	25400.0
2017-10-12 05:00:00	NVDA	Stock	4.7965	4.7965	4.7965	4.7965	7280.0

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

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