PREVIEW / stock_30min / 2018-06-29

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-29.parquet
  size:    1.7 MB
  rows:    84,176
  symbols: 2,837

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-06-29 04:00:00	AAPL	Stock	46.615	46.7675	46.615	46.7675	20612.0
2018-06-29 04:30:00	AAPL	Stock	46.825	46.825	46.8	46.8	13724.0
2018-06-29 05:00:00	AAPL	Stock	46.8225	46.8225	46.8225	46.8225	800.0
2018-06-29 05:30:00	AAPL	Stock	46.81	46.8125	46.75	46.75	3908.0
2018-06-29 06:00:00	AAPL	Stock	46.7425	46.7475	46.5975	46.5975	59760.0
2018-06-29 06:30:00	AAPL	Stock	46.595	46.675	46.595	46.6375	40208.0
2018-06-29 07:00:00	AAPL	Stock	46.6425	46.675	46.58	46.675	51616.0
2018-06-29 07:30:00	AAPL	Stock	46.6675	46.7	46.66	46.6625	62268.0
2018-06-29 08:00:00	AAPL	Stock	46.625	46.7225	46.585	46.625	123020.0
2018-06-29 08:30:00	AAPL	Stock	46.64	46.6875	46.5875	46.6025	66860.0
2018-06-29 09:00:00	AAPL	Stock	46.5975	46.625	46.5625	46.565	51800.0
2018-06-29 09:30:00	AAPL	Stock	46.5725	46.7975	46.5625	46.6262	9002644.0
2018-06-29 10:00:00	AAPL	Stock	46.6225	46.6925	46.5025	46.5575	4789704.0
2018-06-29 10:30:00	AAPL	Stock	46.555	46.62	46.53	46.553	2998380.0
2018-06-29 11:00:00	AAPL	Stock	46.555	46.6275	46.5518	46.5742	2668068.0
2018-06-29 11:30:00	AAPL	Stock	46.57	46.625	46.485	46.5325	2977464.0
2018-06-29 12:00:00	AAPL	Stock	46.5325	46.6525	46.51	46.61	3327380.0
2018-06-29 12:30:00	AAPL	Stock	46.6125	46.6175	46.4875	46.5345	2282020.0
2018-06-29 13:00:00	AAPL	Stock	46.535	46.5825	46.5	46.545	1807920.0
2018-06-29 13:30:00	AAPL	Stock	46.5425	46.5975	46.51	46.5788	1987432.0
2018-06-29 14:00:00	AAPL	Stock	46.5775	46.605	46.525	46.5945	2185324.0
2018-06-29 14:30:00	AAPL	Stock	46.59	46.6125	46.5325	46.6	2695700.0
2018-06-29 15:00:00	AAPL	Stock	46.6025	46.6175	46.5452	46.55	3686572.0
2018-06-29 15:30:00	AAPL	Stock	46.55	46.575	45.7275	45.7275	17818160.0
2018-06-29 16:00:00	AAPL	Stock	45.7275	46.569	45.7275	46.295	15485732.0
2018-06-29 16:30:00	AAPL	Stock	46.2975	46.3075	46.2775	46.2775	3412388.0
2018-06-29 17:00:00	AAPL	Stock	46.2775	46.2975	46.2	46.25	1800460.0
2018-06-29 17:30:00	AAPL	Stock	46.25	46.275	46.225	46.275	31400.0
2018-06-29 18:00:00	AAPL	Stock	46.25	46.25	46.25	46.25	800.0
2018-06-29 18:30:00	AAPL	Stock	46.25	46.275	46.25	46.275	11284.0
2018-06-29 19:00:00	AAPL	Stock	46.275	46.275	46.2525	46.2525	3080.0
2018-06-29 19:30:00	AAPL	Stock	46.275	46.295	46.2725	46.275	16380.0
2018-06-29 04:00:00	MSFT	Stock	99.65	99.65	99.65	99.65	100.0
2018-06-29 05:00:00	MSFT	Stock	99.73	99.88	99.73	99.88	1188.0
2018-06-29 06:00:00	MSFT	Stock	99.39	99.39	99.15	99.15	2100.0
2018-06-29 06:30:00	MSFT	Stock	99.4	99.45	99.23	99.23	6018.0
2018-06-29 07:00:00	MSFT	Stock	99.35	99.35	99.13	99.22	3036.0
2018-06-29 07:30:00	MSFT	Stock	99.28	99.33	99.28	99.3	1957.0
2018-06-29 08:00:00	MSFT	Stock	99.35	99.38	99.13	99.13	13814.0
2018-06-29 08:30:00	MSFT	Stock	99.19	99.33	99.15	99.33	13825.0
2018-06-29 09:00:00	MSFT	Stock	99.19	99.3	98.85	98.86	21086.0
2018-06-29 09:30:00	MSFT	Stock	98.86	99.5	98.86	99.48	2346402.0
2018-06-29 10:00:00	MSFT	Stock	99.48	99.85	99.39	99.52	1532275.0
2018-06-29 10:30:00	MSFT	Stock	99.52	99.91	99.45	99.74	1243615.0
2018-06-29 11:00:00	MSFT	Stock	99.74	99.78	99.36	99.365	983453.0
2018-06-29 11:30:00	MSFT	Stock	99.36	99.49	99.155	99.29	678262.0
2018-06-29 12:00:00	MSFT	Stock	99.28	99.52	99.175	99.42	758821.0
2018-06-29 12:30:00	MSFT	Stock	99.43	99.46	99.2	99.32	829707.0
2018-06-29 13:00:00	MSFT	Stock	99.33	99.41	99.215	99.29	614096.0
2018-06-29 13:30:00	MSFT	Stock	99.29	99.47	99.22	99.45	583509.0

> showing 50 of 84,176 rows — these rows as CSV

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