PREVIEW / stock_30min / 2017-04-18

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-18.parquet
  size:    1.6 MB
  rows:    81,360
  symbols: 3,050

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
2017-04-18 04:30:00	AAPL	Stock	35.4075	35.42	35.4075	35.4075	2960.0
2017-04-18 05:00:00	AAPL	Stock	35.3925	35.3925	35.38	35.38	3200.0
2017-04-18 05:30:00	AAPL	Stock	35.3675	35.3675	35.35	35.35	8892.0
2017-04-18 06:00:00	AAPL	Stock	35.385	35.3975	35.325	35.33	20444.0
2017-04-18 06:30:00	AAPL	Stock	35.365	35.37	35.35	35.35	6120.0
2017-04-18 07:00:00	AAPL	Stock	35.375	35.4	35.36	35.4	44424.0
2017-04-18 07:30:00	AAPL	Stock	35.4	35.4	35.375	35.4	20836.0
2017-04-18 08:00:00	AAPL	Stock	35.375	35.4	35.375	35.3875	50092.0
2017-04-18 08:30:00	AAPL	Stock	35.3875	35.39	35.375	35.39	57520.0
2017-04-18 09:00:00	AAPL	Stock	35.3925	35.3925	35.3175	35.3575	74304.0
2017-04-18 09:30:00	AAPL	Stock	35.36	35.4925	35.3025	35.485	8896088.0
2017-04-18 10:00:00	AAPL	Stock	35.485	35.49	35.405	35.4375	4264584.0
2017-04-18 10:30:00	AAPL	Stock	35.4375	35.51	35.3825	35.4175	4592332.0
2017-04-18 11:00:00	AAPL	Stock	35.42	35.4638	35.375	35.4175	3442512.0
2017-04-18 11:30:00	AAPL	Stock	35.415	35.425	35.3275	35.335	3401904.0
2017-04-18 12:00:00	AAPL	Stock	35.3325	35.3475	35.2775	35.3325	3604916.0
2017-04-18 12:30:00	AAPL	Stock	35.335	35.365	35.3138	35.3375	2216164.0
2017-04-18 13:00:00	AAPL	Stock	35.34	35.3625	35.3125	35.3575	1955604.0
2017-04-18 13:30:00	AAPL	Stock	35.3575	35.3875	35.335	35.3462	2064788.0
2017-04-18 14:00:00	AAPL	Stock	35.345	35.375	35.335	35.3715	2570780.0
2017-04-18 14:30:00	AAPL	Stock	35.37	35.3902	35.3125	35.3362	2640480.0
2017-04-18 15:00:00	AAPL	Stock	35.3375	35.3525	35.2812	35.3298	2960096.0
2017-04-18 15:30:00	AAPL	Stock	35.33	35.3625	35.2825	35.305	5922908.0
2017-04-18 16:00:00	AAPL	Stock	35.295	35.3125	35.2775	35.3075	4733556.0
2017-04-18 16:30:00	AAPL	Stock	35.3	35.3075	35.3	35.3075	50000.0
2017-04-18 17:00:00	AAPL	Stock	35.31	35.3275	35.31	35.3175	9672.0
2017-04-18 17:30:00	AAPL	Stock	35.315	35.325	35.3125	35.325	10228.0
2017-04-18 18:00:00	AAPL	Stock	35.3175	35.325	35.3175	35.325	2584.0
2017-04-18 18:30:00	AAPL	Stock	35.325	35.3325	35.325	35.33	9580.0
2017-04-18 19:00:00	AAPL	Stock	35.3125	35.33	35.3125	35.32	4548.0
2017-04-18 19:30:00	AAPL	Stock	35.325	35.3325	35.32	35.3325	33260.0
2017-04-18 04:30:00	MSFT	Stock	65.2	65.2	65.2	65.2	100.0
2017-04-18 06:30:00	MSFT	Stock	65.25	65.25	65.25	65.25	100.0
2017-04-18 08:00:00	MSFT	Stock	65.34	65.44	65.31	65.4	5360.0
2017-04-18 08:30:00	MSFT	Stock	65.3	65.3	65.3	65.3	115.0
2017-04-18 09:00:00	MSFT	Stock	65.44	65.44	65.26	65.3	7390.0
2017-04-18 09:30:00	MSFT	Stock	65.33	65.66	65.16	65.63	1874143.0
2017-04-18 10:00:00	MSFT	Stock	65.625	65.71	65.47	65.51	1346671.0
2017-04-18 10:30:00	MSFT	Stock	65.51	65.55	65.38	65.465	1034594.0
2017-04-18 11:00:00	MSFT	Stock	65.461	65.545	65.42	65.43	1079114.0
2017-04-18 11:30:00	MSFT	Stock	65.425	65.45	65.25	65.285	1371401.0
2017-04-18 12:00:00	MSFT	Stock	65.28	65.36	65.24	65.295	1121482.0
2017-04-18 12:30:00	MSFT	Stock	65.29	65.4	65.28	65.33	636328.0
2017-04-18 13:00:00	MSFT	Stock	65.33	65.41	65.28	65.41	581393.0
2017-04-18 13:30:00	MSFT	Stock	65.41	65.46	65.365	65.4	478788.0
2017-04-18 14:00:00	MSFT	Stock	65.399	65.43	65.33	65.395	481766.0
2017-04-18 14:30:00	MSFT	Stock	65.39	65.416	65.28	65.377	715102.0
2017-04-18 15:00:00	MSFT	Stock	65.38	65.42	65.33	65.39	635164.0
2017-04-18 15:30:00	MSFT	Stock	65.395	65.49	65.375	65.39	1543929.0
2017-04-18 16:00:00	MSFT	Stock	65.38	65.39	65.28	65.28	1095031.0

> showing 50 of 81,360 rows — these rows as CSV

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