PREVIEW / stock_30min / 2017-11-06

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-06.parquet
  size:    1.6 MB
  rows:    82,379
  symbols: 2,956

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-11-06 04:00:00	AAPL	Stock	43.25	43.275	43.225	43.25	56504.0
2017-11-06 04:30:00	AAPL	Stock	43.245	43.245	43.225	43.235	18804.0
2017-11-06 05:00:00	AAPL	Stock	43.2325	43.2325	43.2225	43.2225	4212.0
2017-11-06 05:30:00	AAPL	Stock	43.2	43.2325	43.175	43.175	29616.0
2017-11-06 06:00:00	AAPL	Stock	43.175	43.2375	43.1725	43.225	79752.0
2017-11-06 06:30:00	AAPL	Stock	43.225	43.25	43.1975	43.1975	19756.0
2017-11-06 07:00:00	AAPL	Stock	43.1975	43.225	43.175	43.2	65936.0
2017-11-06 07:30:00	AAPL	Stock	43.2125	43.2375	43.1875	43.2075	79316.0
2017-11-06 08:00:00	AAPL	Stock	43.2	43.245	43.125	43.1675	334148.0
2017-11-06 08:30:00	AAPL	Stock	43.17	43.2725	43.1575	43.2025	263600.0
2017-11-06 09:00:00	AAPL	Stock	43.225	43.2375	43.0375	43.0625	295340.0
2017-11-06 09:30:00	AAPL	Stock	43.0875	43.1625	42.93	43.07	19394012.0
2017-11-06 10:00:00	AAPL	Stock	43.075	43.425	43.0525	43.415	12832392.0
2017-11-06 10:30:00	AAPL	Stock	43.4125	43.6925	43.41	43.68	14606456.0
2017-11-06 11:00:00	AAPL	Stock	43.6763	43.7275	43.5675	43.5912	11263784.0
2017-11-06 11:30:00	AAPL	Stock	43.59	43.66	43.5275	43.6428	6984556.0
2017-11-06 12:00:00	AAPL	Stock	43.6425	43.7125	43.625	43.6775	6379504.0
2017-11-06 12:30:00	AAPL	Stock	43.6775	43.6825	43.6	43.6425	4255604.0
2017-11-06 13:00:00	AAPL	Stock	43.6438	43.7	43.605	43.6712	4833236.0
2017-11-06 13:30:00	AAPL	Stock	43.67	43.725	43.63	43.7225	4295916.0
2017-11-06 14:00:00	AAPL	Stock	43.7175	43.745	43.6475	43.665	5475756.0
2017-11-06 14:30:00	AAPL	Stock	43.6675	43.71	43.6175	43.7062	3941904.0
2017-11-06 15:00:00	AAPL	Stock	43.7075	43.7475	43.625	43.6325	4755808.0
2017-11-06 15:30:00	AAPL	Stock	43.6325	43.7325	43.5675	43.58	12052884.0
2017-11-06 16:00:00	AAPL	Stock	43.5625	43.57	43.525	43.53	12620364.0
2017-11-06 16:30:00	AAPL	Stock	43.535	43.5625	43.52	43.5425	1688068.0
2017-11-06 17:00:00	AAPL	Stock	43.5325	43.545	43.525	43.545	29108.0
2017-11-06 17:30:00	AAPL	Stock	43.525	43.5625	43.525	43.5425	889148.0
2017-11-06 18:00:00	AAPL	Stock	43.55	43.55	43.5325	43.545	11372.0
2017-11-06 18:30:00	AAPL	Stock	43.545	43.55	43.5275	43.5275	58716.0
2017-11-06 19:00:00	AAPL	Stock	43.5375	43.55	43.5375	43.55	15640.0
2017-11-06 19:30:00	AAPL	Stock	43.55	43.55	43.54	43.55	31172.0
2017-11-06 04:00:00	MSFT	Stock	84.06	84.06	84.06	84.06	800.0
2017-11-06 07:00:00	MSFT	Stock	84.1	84.12	84.1	84.12	597.0
2017-11-06 07:30:00	MSFT	Stock	84.13	84.13	84.13	84.13	247.0
2017-11-06 08:00:00	MSFT	Stock	84.13	84.13	84.07	84.07	406.0
2017-11-06 08:30:00	MSFT	Stock	84.02	84.07	84.0	84.0	3430.0
2017-11-06 09:00:00	MSFT	Stock	84.0	84.2	84.0	84.2	7146.0
2017-11-06 09:30:00	MSFT	Stock	84.2	84.54	84.16	84.51	2166062.0
2017-11-06 10:00:00	MSFT	Stock	84.51	84.7	84.32	84.635	1427171.0
2017-11-06 10:30:00	MSFT	Stock	84.635	84.65	84.319	84.366	992377.0
2017-11-06 11:00:00	MSFT	Stock	84.36	84.44	84.24	84.255	835555.0
2017-11-06 11:30:00	MSFT	Stock	84.26	84.31	84.082	84.214	1107650.0
2017-11-06 12:00:00	MSFT	Stock	84.22	84.39	84.2	84.32	586230.0
2017-11-06 12:30:00	MSFT	Stock	84.32	84.52	84.31	84.5	638927.0
2017-11-06 13:00:00	MSFT	Stock	84.51	84.59	84.45	84.475	697445.0
2017-11-06 13:30:00	MSFT	Stock	84.47	84.505	84.31	84.36	762520.0
2017-11-06 14:00:00	MSFT	Stock	84.366	84.39	84.25	84.27	785247.0
2017-11-06 14:30:00	MSFT	Stock	84.28	84.305	84.21	84.255	622243.0
2017-11-06 15:00:00	MSFT	Stock	84.26	84.43	84.25	84.4	1026026.0

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

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