PREVIEW / stock_30min / 2018-11-12

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-12.parquet
  size:    1.7 MB
  rows:    82,936
  symbols: 2,738

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-11-12 04:00:00	AAPL	Stock	50.975	51.085	50.975	51.085	2036.0
2018-11-12 04:30:00	AAPL	Stock	51.04	51.04	51.0	51.0	2800.0
2018-11-12 05:00:00	AAPL	Stock	50.995	50.995	50.9275	50.9275	1200.0
2018-11-12 05:30:00	AAPL	Stock	50.9875	51.0575	50.98	51.0575	17720.0
2018-11-12 06:00:00	AAPL	Stock	50.9625	50.9975	50.9625	50.9975	2372.0
2018-11-12 06:30:00	AAPL	Stock	50.93	50.93	50.8275	50.875	11576.0
2018-11-12 07:00:00	AAPL	Stock	50.89	50.89	50.7	50.705	190416.0
2018-11-12 07:30:00	AAPL	Stock	50.705	50.7925	50.6775	50.6775	65568.0
2018-11-12 08:00:00	AAPL	Stock	50.7005	50.8675	49.8675	49.875	1231260.0
2018-11-12 08:30:00	AAPL	Stock	49.8675	49.99	49.7	49.8575	1169380.0
2018-11-12 09:00:00	AAPL	Stock	49.8675	49.9825	49.7125	49.7525	928276.0
2018-11-12 09:30:00	AAPL	Stock	49.725	49.9625	49.03	49.1925	30467008.0
2018-11-12 10:00:00	AAPL	Stock	49.185	49.22	48.9075	48.96	16174704.0
2018-11-12 10:30:00	AAPL	Stock	48.9575	48.9775	48.58	48.6748	18223112.0
2018-11-12 11:00:00	AAPL	Stock	48.6775	48.8625	48.4475	48.595	15720084.0
2018-11-12 11:30:00	AAPL	Stock	48.5925	48.8975	48.485	48.8525	12917520.0
2018-11-12 12:00:00	AAPL	Stock	48.8562	49.1	48.8425	49.01	9375864.0
2018-11-12 12:30:00	AAPL	Stock	49.01	49.04	48.905	48.935	5258548.0
2018-11-12 13:00:00	AAPL	Stock	48.9375	49.0	48.8125	48.9125	6036632.0
2018-11-12 13:30:00	AAPL	Stock	48.915	49.058	48.7875	48.94	5062812.0
2018-11-12 14:00:00	AAPL	Stock	48.93	49.1075	48.823	48.955	5791040.0
2018-11-12 14:30:00	AAPL	Stock	48.95	49.1675	48.8675	48.9355	6722552.0
2018-11-12 15:00:00	AAPL	Stock	48.9375	48.94	48.67	48.8225	10517812.0
2018-11-12 15:30:00	AAPL	Stock	48.825	48.8275	48.4725	48.55	20191072.0
2018-11-12 16:00:00	AAPL	Stock	48.5425	48.5875	48.2775	48.345	9808584.0
2018-11-12 16:30:00	AAPL	Stock	48.31	48.412	48.25	48.375	291604.0
2018-11-12 17:00:00	AAPL	Stock	48.3875	48.5428	48.3625	48.435	132240.0
2018-11-12 17:30:00	AAPL	Stock	48.4	48.445	48.3775	48.3775	72592.0
2018-11-12 18:00:00	AAPL	Stock	48.3775	48.4	48.25	48.3125	153644.0
2018-11-12 18:30:00	AAPL	Stock	48.3025	48.3375	48.2875	48.3	49392.0
2018-11-12 19:00:00	AAPL	Stock	48.3025	48.325	48.25	48.25	58116.0
2018-11-12 19:30:00	AAPL	Stock	48.25	48.2625	48.175	48.2	121192.0
2018-11-12 05:00:00	MSFT	Stock	109.57	109.57	109.57	109.57	100.0
2018-11-12 06:00:00	MSFT	Stock	109.5	109.5	109.5	109.5	100.0
2018-11-12 07:00:00	MSFT	Stock	109.5	109.5	109.3	109.35	643.0
2018-11-12 07:30:00	MSFT	Stock	109.41	109.48	109.35	109.35	7553.0
2018-11-12 08:00:00	MSFT	Stock	109.2	109.4	108.71	108.86	7458.0
2018-11-12 08:30:00	MSFT	Stock	108.94	109.2	108.85	109.0	18727.0
2018-11-12 09:00:00	MSFT	Stock	109.17	109.42	109.03	109.42	15467.0
2018-11-12 09:30:00	MSFT	Stock	109.42	109.96	108.31	108.49	2489933.0
2018-11-12 10:00:00	MSFT	Stock	108.495	108.505	107.8	108.22	2054345.0
2018-11-12 10:30:00	MSFT	Stock	108.22	108.22	107.13	107.28	2247442.0
2018-11-12 11:00:00	MSFT	Stock	107.29	107.31	106.31	106.386	2333561.0
2018-11-12 11:30:00	MSFT	Stock	106.38	107.05	106.1	107.015	1942707.0
2018-11-12 12:00:00	MSFT	Stock	107.02	107.5	106.99	107.035	1368329.0
2018-11-12 12:30:00	MSFT	Stock	107.03	107.35	106.865	106.94	1458094.0
2018-11-12 13:00:00	MSFT	Stock	106.94	107.02	106.61	106.9	1146814.0
2018-11-12 13:30:00	MSFT	Stock	106.9	107.08	106.27	106.76	1743333.0
2018-11-12 14:00:00	MSFT	Stock	106.73	107.49	106.615	107.025	1643026.0
2018-11-12 14:30:00	MSFT	Stock	107.025	107.75	106.91	107.11	1886728.0

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

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