PREVIEW / stock_30min / 2018-12-14

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-14.parquet
  size:    1.7 MB
  rows:    83,657
  symbols: 2,719

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-12-14 04:00:00	AAPL	Stock	42.1875	42.1875	42.0575	42.1125	10596.0
2018-12-14 04:30:00	AAPL	Stock	42.1	42.1825	42.075	42.1125	22092.0
2018-12-14 05:00:00	AAPL	Stock	42.125	42.1975	42.125	42.1975	6800.0
2018-12-14 05:30:00	AAPL	Stock	42.125	42.2225	42.125	42.125	19792.0
2018-12-14 06:00:00	AAPL	Stock	42.15	42.15	42.15	42.15	500.0
2018-12-14 06:30:00	AAPL	Stock	42.2	42.25	42.125	42.25	11600.0
2018-12-14 07:00:00	AAPL	Stock	42.275	42.375	42.25	42.3725	179920.0
2018-12-14 07:30:00	AAPL	Stock	42.375	42.425	42.2125	42.2475	160440.0
2018-12-14 08:00:00	AAPL	Stock	42.315	42.375	42.1675	42.19	328644.0
2018-12-14 08:30:00	AAPL	Stock	42.1875	42.36	42.1825	42.2825	267164.0
2018-12-14 09:00:00	AAPL	Stock	42.275	42.3	42.155	42.27	322204.0
2018-12-14 09:30:00	AAPL	Stock	42.25	42.27	41.715	41.805	20444428.0
2018-12-14 10:00:00	AAPL	Stock	41.805	41.93	41.5275	41.6025	13078444.0
2018-12-14 10:30:00	AAPL	Stock	41.605	41.92	41.5052	41.7375	11741944.0
2018-12-14 11:00:00	AAPL	Stock	41.7375	41.92	41.6722	41.7675	8665808.0
2018-12-14 11:30:00	AAPL	Stock	41.7688	41.925	41.625	41.7025	7747464.0
2018-12-14 12:00:00	AAPL	Stock	41.7	41.7475	41.5875	41.697	7262920.0
2018-12-14 12:30:00	AAPL	Stock	41.6925	41.7725	41.68	41.6838	5526324.0
2018-12-14 13:00:00	AAPL	Stock	41.685	41.87	41.625	41.7575	5931732.0
2018-12-14 13:30:00	AAPL	Stock	41.755	41.7975	41.6425	41.6987	5922300.0
2018-12-14 14:00:00	AAPL	Stock	41.6987	41.76	41.6225	41.6912	5686660.0
2018-12-14 14:30:00	AAPL	Stock	41.695	41.7	41.5175	41.6375	8956184.0
2018-12-14 15:00:00	AAPL	Stock	41.64	41.7075	41.5	41.53	8669648.0
2018-12-14 15:30:00	AAPL	Stock	41.5275	41.5525	41.32	41.35	21573556.0
2018-12-14 16:00:00	AAPL	Stock	41.37	41.375	41.325	41.3725	14572776.0
2018-12-14 16:30:00	AAPL	Stock	41.3725	41.3725	41.325	41.35	351848.0
2018-12-14 17:00:00	AAPL	Stock	41.325	41.3625	41.3125	41.3375	83304.0
2018-12-14 17:30:00	AAPL	Stock	41.335	41.35	41.325	41.3425	29252.0
2018-12-14 18:00:00	AAPL	Stock	41.3375	41.3575	41.33	41.3425	27260.0
2018-12-14 18:30:00	AAPL	Stock	41.355	41.355	41.3025	41.3325	37040.0
2018-12-14 19:00:00	AAPL	Stock	41.3125	41.325	41.3025	41.3175	14176.0
2018-12-14 19:30:00	AAPL	Stock	41.3125	41.325	41.275	41.275	77816.0
2018-12-14 04:00:00	MSFT	Stock	108.0	108.0	108.0	108.0	205.0
2018-12-14 05:00:00	MSFT	Stock	107.9	107.9	107.9	107.9	1000.0
2018-12-14 06:30:00	MSFT	Stock	108.09	108.25	108.08	108.23	3080.0
2018-12-14 07:00:00	MSFT	Stock	108.1	108.55	108.1	108.53	5916.0
2018-12-14 07:30:00	MSFT	Stock	108.6	108.6	108.37	108.44	2142.0
2018-12-14 08:00:00	MSFT	Stock	108.48	108.5	108.23	108.34	17516.0
2018-12-14 08:30:00	MSFT	Stock	108.26	108.55	108.21	108.41	13275.0
2018-12-14 09:00:00	MSFT	Stock	108.45	108.58	108.25	108.29	28452.0
2018-12-14 09:30:00	MSFT	Stock	108.25	108.67	107.68	108.48	3608741.0
2018-12-14 10:00:00	MSFT	Stock	108.47	109.26	108.372	108.49	2671075.0
2018-12-14 10:30:00	MSFT	Stock	108.48	109.03	108.32	108.85	2318841.0
2018-12-14 11:00:00	MSFT	Stock	108.86	109.13	108.125	108.17	1852805.0
2018-12-14 11:30:00	MSFT	Stock	108.17	108.38	107.31	107.415	3487360.0
2018-12-14 12:00:00	MSFT	Stock	107.42	108.0	107.41	107.68	2886392.0
2018-12-14 12:30:00	MSFT	Stock	107.67	107.94	107.34	107.48	1820440.0
2018-12-14 13:00:00	MSFT	Stock	107.48	107.65	106.95	106.97	1896100.0
2018-12-14 13:30:00	MSFT	Stock	106.96	106.96	106.23	106.436	2566419.0
2018-12-14 14:00:00	MSFT	Stock	106.43	106.59	106.21	106.48	1568236.0

> showing 50 of 83,657 rows — these rows as CSV

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