PREVIEW / stock_30min / 2018-02-16

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-16.parquet
  size:    1.7 MB
  rows:    82,837
  symbols: 2,890

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-02-16 04:00:00	AAPL	Stock	43.3375	43.565	43.3375	43.475	38448.0
2018-02-16 04:30:00	AAPL	Stock	43.4975	43.55	43.3775	43.5	29696.0
2018-02-16 05:00:00	AAPL	Stock	43.5	43.525	43.46	43.46	9400.0
2018-02-16 05:30:00	AAPL	Stock	43.46	43.46	43.3	43.3	64332.0
2018-02-16 06:00:00	AAPL	Stock	43.305	43.4125	43.3	43.3	28168.0
2018-02-16 06:30:00	AAPL	Stock	43.28	43.3225	43.14	43.2375	88512.0
2018-02-16 07:00:00	AAPL	Stock	43.2375	43.31	43.2125	43.2975	170148.0
2018-02-16 07:30:00	AAPL	Stock	43.265	43.2975	43.1875	43.2	179392.0
2018-02-16 08:00:00	AAPL	Stock	43.225	43.305	43.0875	43.1025	451672.0
2018-02-16 08:30:00	AAPL	Stock	43.11	43.1725	43.0875	43.1	317312.0
2018-02-16 09:00:00	AAPL	Stock	43.1	43.12	43.0025	43.1125	344700.0
2018-02-16 09:30:00	AAPL	Stock	43.09	43.475	42.9425	43.3175	23884572.0
2018-02-16 10:00:00	AAPL	Stock	43.3188	43.5075	43.155	43.5	14515620.0
2018-02-16 10:30:00	AAPL	Stock	43.5	43.6455	43.4728	43.505	12762496.0
2018-02-16 11:00:00	AAPL	Stock	43.5125	43.64	43.455	43.56	7440352.0
2018-02-16 11:30:00	AAPL	Stock	43.5575	43.625	43.445	43.575	7337100.0
2018-02-16 12:00:00	AAPL	Stock	43.58	43.6175	43.5375	43.6	5060636.0
2018-02-16 12:30:00	AAPL	Stock	43.6025	43.705	43.459	43.575	9529228.0
2018-02-16 13:00:00	AAPL	Stock	43.585	43.625	43.2525	43.3125	9268568.0
2018-02-16 13:30:00	AAPL	Stock	43.32	43.4568	43.17	43.2765	9206820.0
2018-02-16 14:00:00	AAPL	Stock	43.2775	43.3625	43.1275	43.3175	8693304.0
2018-02-16 14:30:00	AAPL	Stock	43.32	43.44	43.23	43.3498	6874092.0
2018-02-16 15:00:00	AAPL	Stock	43.345	43.4525	43.2925	43.398	7399288.0
2018-02-16 15:30:00	AAPL	Stock	43.395	43.4175	43.1075	43.1125	13345244.0
2018-02-16 16:00:00	AAPL	Stock	43.1075	43.5097	43.1025	43.1075	7763476.0
2018-02-16 16:30:00	AAPL	Stock	43.12	43.1375	43.1	43.1375	279268.0
2018-02-16 17:00:00	AAPL	Stock	43.1	43.1225	43.0925	43.0925	42740.0
2018-02-16 17:30:00	AAPL	Stock	43.0975	43.1	43.0575	43.0625	28700.0
2018-02-16 18:00:00	AAPL	Stock	43.0625	43.0625	42.98	42.98	94892.0
2018-02-16 18:30:00	AAPL	Stock	42.99	43.025	42.985	42.9875	19428.0
2018-02-16 19:00:00	AAPL	Stock	43.0125	43.0375	42.99	43.0	17384.0
2018-02-16 19:30:00	AAPL	Stock	43.005	43.025	42.9875	42.9875	50896.0
2018-02-16 04:00:00	MSFT	Stock	93.19	93.19	93.19	93.19	463.0
2018-02-16 04:30:00	MSFT	Stock	93.31	93.51	93.31	93.51	5185.0
2018-02-16 05:30:00	MSFT	Stock	93.15	93.21	93.1	93.16	6977.0
2018-02-16 06:00:00	MSFT	Stock	93.11	93.11	93.11	93.11	500.0
2018-02-16 06:30:00	MSFT	Stock	93.15	93.15	92.86	93.09	7585.0
2018-02-16 07:00:00	MSFT	Stock	93.0	93.12	92.89	92.9	19249.0
2018-02-16 07:30:00	MSFT	Stock	92.96	93.11	92.96	93.0	3287.0
2018-02-16 08:00:00	MSFT	Stock	93.0	93.1	92.5	92.5	38479.0
2018-02-16 08:30:00	MSFT	Stock	92.66	92.76	92.51	92.65	14160.0
2018-02-16 09:00:00	MSFT	Stock	92.53	92.7	92.36	92.52	23852.0
2018-02-16 09:30:00	MSFT	Stock	92.54	92.9	92.38	92.58	4063083.0
2018-02-16 10:00:00	MSFT	Stock	92.59	92.96	92.45	92.94	1584814.0
2018-02-16 10:30:00	MSFT	Stock	92.94	93.275	92.86	92.935	1710057.0
2018-02-16 11:00:00	MSFT	Stock	92.93	93.18	92.79	92.94	1263853.0
2018-02-16 11:30:00	MSFT	Stock	92.94	93.245	92.88	93.185	846017.0
2018-02-16 12:00:00	MSFT	Stock	93.185	93.41	93.12	93.32	1097348.0
2018-02-16 12:30:00	MSFT	Stock	93.33	93.5	92.88	93.0	1457516.0
2018-02-16 13:00:00	MSFT	Stock	93.015	93.15	92.3	92.36	2570286.0

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

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