PREVIEW / stock_30min / 2018-08-06

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-06.parquet
  size:    1.7 MB
  rows:    82,220
  symbols: 2,804

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-08-06 04:00:00	AAPL	Stock	52.0175	52.06	52.0175	52.0475	3496.0
2018-08-06 04:30:00	AAPL	Stock	52.0	52.0	51.925	51.925	4536.0
2018-08-06 05:00:00	AAPL	Stock	51.92	51.95	51.8875	51.9375	12092.0
2018-08-06 05:30:00	AAPL	Stock	51.99	52.0	51.99	52.0	4772.0
2018-08-06 06:00:00	AAPL	Stock	52.0	52.0	52.0	52.0	400.0
2018-08-06 06:30:00	AAPL	Stock	52.025	52.05	52.0	52.0	20308.0
2018-08-06 07:00:00	AAPL	Stock	52.03	52.0775	52.0225	52.05	98628.0
2018-08-06 07:30:00	AAPL	Stock	52.05	52.0775	52.02	52.0425	60512.0
2018-08-06 08:00:00	AAPL	Stock	52.075	52.0775	51.9975	52.0125	250220.0
2018-08-06 08:30:00	AAPL	Stock	52.0125	52.0275	51.9575	51.98	169772.0
2018-08-06 09:00:00	AAPL	Stock	51.975	52.0175	51.95	51.975	106276.0
2018-08-06 09:30:00	AAPL	Stock	51.9825	52.26	51.8775	52.05	17587568.0
2018-08-06 10:00:00	AAPL	Stock	52.05	52.0725	51.8525	51.9412	8022072.0
2018-08-06 10:30:00	AAPL	Stock	51.94	51.9975	51.83	51.91	5777412.0
2018-08-06 11:00:00	AAPL	Stock	51.91	51.9575	51.7675	51.9325	4924824.0
2018-08-06 11:30:00	AAPL	Stock	51.935	52.075	51.9275	52.045	3832284.0
2018-08-06 12:00:00	AAPL	Stock	52.0475	52.2525	52.02	52.1925	5599688.0
2018-08-06 12:30:00	AAPL	Stock	52.1908	52.233	52.13	52.175	3288076.0
2018-08-06 13:00:00	AAPL	Stock	52.175	52.2925	52.17	52.2558	5712268.0
2018-08-06 13:30:00	AAPL	Stock	52.255	52.265	52.13	52.1755	4601976.0
2018-08-06 14:00:00	AAPL	Stock	52.176	52.265	52.145	52.2475	3891116.0
2018-08-06 14:30:00	AAPL	Stock	52.2475	52.3025	52.2425	52.2725	3999068.0
2018-08-06 15:00:00	AAPL	Stock	52.2732	52.305	52.1925	52.29	5765140.0
2018-08-06 15:30:00	AAPL	Stock	52.2925	52.3125	52.2472	52.265	7868556.0
2018-08-06 16:00:00	AAPL	Stock	52.2675	52.2675	52.1498	52.25	8129292.0
2018-08-06 16:30:00	AAPL	Stock	52.26	52.2725	52.24	52.2725	27548.0
2018-08-06 17:00:00	AAPL	Stock	52.25	52.26	52.245	52.26	21800.0
2018-08-06 17:30:00	AAPL	Stock	52.2375	52.2625	52.2375	52.2625	3368.0
2018-08-06 18:00:00	AAPL	Stock	52.26	52.26	52.2375	52.2375	5784.0
2018-08-06 18:30:00	AAPL	Stock	52.2375	52.24	52.23	52.23	9764.0
2018-08-06 19:00:00	AAPL	Stock	52.2375	52.255	52.2275	52.255	11440.0
2018-08-06 19:30:00	AAPL	Stock	52.2375	52.2825	52.235	52.265	33712.0
2018-08-06 04:00:00	MSFT	Stock	108.1	108.1	108.1	108.1	200.0
2018-08-06 04:30:00	MSFT	Stock	108.0	108.0	108.0	108.0	150.0
2018-08-06 05:00:00	MSFT	Stock	108.15	108.15	108.05	108.15	2408.0
2018-08-06 06:30:00	MSFT	Stock	108.3	108.3	108.3	108.3	1600.0
2018-08-06 07:00:00	MSFT	Stock	108.23	108.39	108.23	108.26	1431.0
2018-08-06 07:30:00	MSFT	Stock	108.3	108.35	108.3	108.35	3430.0
2018-08-06 08:00:00	MSFT	Stock	108.38	108.38	108.23	108.23	18680.0
2018-08-06 08:30:00	MSFT	Stock	108.23	108.26	108.14	108.17	6000.0
2018-08-06 09:00:00	MSFT	Stock	108.14	108.3	107.91	107.93	23867.0
2018-08-06 09:30:00	MSFT	Stock	107.91	108.23	107.6	108.15	2059743.0
2018-08-06 10:00:00	MSFT	Stock	108.16	108.42	107.82	107.93	1344563.0
2018-08-06 10:30:00	MSFT	Stock	107.93	108.035	107.83	107.885	678468.0
2018-08-06 11:00:00	MSFT	Stock	107.885	107.95	107.559	107.73	727001.0
2018-08-06 11:30:00	MSFT	Stock	107.73	107.94	107.715	107.89	417002.0
2018-08-06 12:00:00	MSFT	Stock	107.89	108.13	107.88	107.985	728122.0
2018-08-06 12:30:00	MSFT	Stock	107.99	108.09	107.95	108.075	533842.0
2018-08-06 13:00:00	MSFT	Stock	108.075	108.25	108.07	108.15	675921.0
2018-08-06 13:30:00	MSFT	Stock	108.144	108.16	107.83	107.87	514985.0

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

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