PREVIEW / stock_30min / 2018-04-11

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-11.parquet
  size:    1.6 MB
  rows:    82,616
  symbols: 2,862

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-04-11 04:00:00	AAPL	Stock	43.125	43.125	43.125	43.125	4000.0
2018-04-11 05:30:00	AAPL	Stock	43.125	43.145	43.125	43.125	4388.0
2018-04-11 06:00:00	AAPL	Stock	43.1125	43.1125	42.915	42.945	37396.0
2018-04-11 06:30:00	AAPL	Stock	42.9875	43.0	42.9475	42.9525	12400.0
2018-04-11 07:00:00	AAPL	Stock	42.9675	42.995	42.8775	42.9225	142692.0
2018-04-11 07:30:00	AAPL	Stock	42.9325	43.025	42.9325	42.99	61928.0
2018-04-11 08:00:00	AAPL	Stock	43.0	43.075	42.9	43.0025	212992.0
2018-04-11 08:30:00	AAPL	Stock	43.0075	43.05	42.975	43.005	108704.0
2018-04-11 09:00:00	AAPL	Stock	43.01	43.145	42.9725	42.9975	247708.0
2018-04-11 09:30:00	AAPL	Stock	43.0575	43.1825	42.925	43.17	12851996.0
2018-04-11 10:00:00	AAPL	Stock	43.165	43.25	43.025	43.2425	6852372.0
2018-04-11 10:30:00	AAPL	Stock	43.24	43.3115	43.1825	43.1908	5338840.0
2018-04-11 11:00:00	AAPL	Stock	43.1875	43.21	43.065	43.1725	4665588.0
2018-04-11 11:30:00	AAPL	Stock	43.175	43.3725	43.1325	43.3112	4491204.0
2018-04-11 12:00:00	AAPL	Stock	43.31	43.4808	43.27	43.3275	4945224.0
2018-04-11 12:30:00	AAPL	Stock	43.3325	43.353	43.1725	43.25	3497592.0
2018-04-11 13:00:00	AAPL	Stock	43.25	43.35	43.2125	43.282	3283384.0
2018-04-11 13:30:00	AAPL	Stock	43.2825	43.3325	43.1525	43.3177	3534548.0
2018-04-11 14:00:00	AAPL	Stock	43.32	43.3825	43.2148	43.31	4884248.0
2018-04-11 14:30:00	AAPL	Stock	43.3075	43.41	43.2275	43.2975	4416532.0
2018-04-11 15:00:00	AAPL	Stock	43.2975	43.3225	43.0425	43.0938	5111584.0
2018-04-11 15:30:00	AAPL	Stock	43.094	43.175	43.0125	43.11	8561096.0
2018-04-11 16:00:00	AAPL	Stock	43.1125	43.125	43.065	43.065	5112152.0
2018-04-11 16:30:00	AAPL	Stock	43.075	43.11	43.0625	43.0875	79440.0
2018-04-11 17:00:00	AAPL	Stock	43.1025	43.1025	43.09	43.09	960.0
2018-04-11 17:30:00	AAPL	Stock	43.1025	43.1125	43.1025	43.1125	3800.0
2018-04-11 18:00:00	AAPL	Stock	43.1125	43.15	43.1025	43.115	27076.0
2018-04-11 18:30:00	AAPL	Stock	43.115	43.2	43.115	43.2	17400.0
2018-04-11 19:00:00	AAPL	Stock	43.1875	43.2	43.15	43.2	13332.0
2018-04-11 19:30:00	AAPL	Stock	43.2	43.2075	43.1375	43.18	35504.0
2018-04-11 04:00:00	MSFT	Stock	92.27	92.27	92.27	92.27	100.0
2018-04-11 05:30:00	MSFT	Stock	92.5	92.5	92.49	92.5	2119.0
2018-04-11 06:00:00	MSFT	Stock	92.19	92.2	92.06	92.07	5572.0
2018-04-11 06:30:00	MSFT	Stock	92.29	92.29	92.29	92.29	400.0
2018-04-11 07:00:00	MSFT	Stock	92.28	92.3	91.73	91.9	11779.0
2018-04-11 07:30:00	MSFT	Stock	91.75	92.18	91.65	92.16	6108.0
2018-04-11 08:00:00	MSFT	Stock	92.14	93.08	91.67	92.1	12523.0
2018-04-11 08:30:00	MSFT	Stock	92.05	92.25	92.03	92.09	14008.0
2018-04-11 09:00:00	MSFT	Stock	92.09	92.55	92.01	92.03	64319.0
2018-04-11 09:30:00	MSFT	Stock	92.03	92.315	91.76	92.21	3369857.0
2018-04-11 10:00:00	MSFT	Stock	92.2	92.76	92.08	92.7	1710796.0
2018-04-11 10:30:00	MSFT	Stock	92.7	92.99	92.451	92.465	1402609.0
2018-04-11 11:00:00	MSFT	Stock	92.47	92.79	92.22	92.76	1063753.0
2018-04-11 11:30:00	MSFT	Stock	92.755	93.12	92.62	92.89	1176390.0
2018-04-11 12:00:00	MSFT	Stock	92.89	93.29	92.85	92.87	1080071.0
2018-04-11 12:30:00	MSFT	Stock	92.87	92.94	92.38	92.45	1050353.0
2018-04-11 13:00:00	MSFT	Stock	92.46	92.7	92.34	92.399	1088753.0
2018-04-11 13:30:00	MSFT	Stock	92.395	92.425	91.95	92.36	1283986.0
2018-04-11 14:00:00	MSFT	Stock	92.36	92.63	91.965	92.09	1135947.0
2018-04-11 14:30:00	MSFT	Stock	92.1	92.38	91.86	92.05	1234018.0

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

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