PREVIEW / stock_30min / 2019-01-03

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-03.parquet
  size:    1.7 MB
  rows:    83,186
  symbols: 2,680

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
2019-01-03 04:00:00	AAPL	Stock	36.5	36.6	36.25	36.425	91328.0
2019-01-03 04:30:00	AAPL	Stock	36.455	36.665	36.4	36.5125	189700.0
2019-01-03 05:00:00	AAPL	Stock	36.515	36.5875	36.4225	36.45	230220.0
2019-01-03 05:30:00	AAPL	Stock	36.45	36.625	36.21	36.285	189460.0
2019-01-03 06:00:00	AAPL	Stock	36.335	36.345	35.955	35.995	250392.0
2019-01-03 06:30:00	AAPL	Stock	35.9875	36.0	35.7825	35.84	381984.0
2019-01-03 07:00:00	AAPL	Stock	35.87	36.3125	35.83	36.22	1121424.0
2019-01-03 07:30:00	AAPL	Stock	36.19	36.325	36.175	36.23	1040684.0
2019-01-03 08:00:00	AAPL	Stock	35.975	36.5	35.8625	36.35	1566092.0
2019-01-03 08:30:00	AAPL	Stock	36.3375	36.4	35.9575	36.0475	2050048.0
2019-01-03 09:00:00	AAPL	Stock	36.0475	36.125	35.8	35.985	4477136.0
2019-01-03 09:30:00	AAPL	Stock	35.9875	36.245	35.7025	36.1025	68985052.0
2019-01-03 10:00:00	AAPL	Stock	36.1	36.1	35.7375	36.0	29863444.0
2019-01-03 10:30:00	AAPL	Stock	35.9925	35.995	35.52	35.7983	29041936.0
2019-01-03 11:00:00	AAPL	Stock	35.7988	36.2075	35.7875	36.092	21995192.0
2019-01-03 11:30:00	AAPL	Stock	36.09	36.375	36.0	36.1825	19619056.0
2019-01-03 12:00:00	AAPL	Stock	36.182	36.43	36.155	36.2525	15141776.0
2019-01-03 12:30:00	AAPL	Stock	36.2537	36.3425	36.105	36.26	10495416.0
2019-01-03 13:00:00	AAPL	Stock	36.2525	36.2928	36.0025	36.06	10969468.0
2019-01-03 13:30:00	AAPL	Stock	36.06	36.0875	35.725	35.74	13980116.0
2019-01-03 14:00:00	AAPL	Stock	35.7375	35.9125	35.7075	35.905	11199480.0
2019-01-03 14:30:00	AAPL	Stock	35.9038	35.9925	35.625	35.656	11748416.0
2019-01-03 15:00:00	AAPL	Stock	35.6575	35.7125	35.5	35.6575	17284920.0
2019-01-03 15:30:00	AAPL	Stock	35.66	35.835	35.5175	35.5212	28163656.0
2019-01-03 16:00:00	AAPL	Stock	35.5475	35.7	35.535	35.69	17437404.0
2019-01-03 16:30:00	AAPL	Stock	35.69	35.73	35.6125	35.625	387680.0
2019-01-03 17:00:00	AAPL	Stock	35.6275	35.65	35.625	35.6275	40488.0
2019-01-03 17:30:00	AAPL	Stock	35.625	35.67	35.5475	35.67	487152.0
2019-01-03 18:00:00	AAPL	Stock	35.64	35.6825	35.625	35.6525	47796.0
2019-01-03 18:30:00	AAPL	Stock	35.625	35.6725	35.6	35.645	70132.0
2019-01-03 19:00:00	AAPL	Stock	35.6375	35.6375	35.5525	35.5625	52612.0
2019-01-03 19:30:00	AAPL	Stock	35.575	35.595	35.52	35.52	80540.0
2019-01-03 04:00:00	MSFT	Stock	99.03	99.4	98.98	99.4	5370.0
2019-01-03 04:30:00	MSFT	Stock	99.48	99.5	99.23	99.3	1500.0
2019-01-03 05:00:00	MSFT	Stock	99.24	99.24	99.24	99.24	1000.0
2019-01-03 05:30:00	MSFT	Stock	99.08	99.47	99.01	99.45	9587.0
2019-01-03 06:30:00	MSFT	Stock	99.19	99.19	98.97	99.0	14995.0
2019-01-03 07:00:00	MSFT	Stock	99.0	99.3	99.0	99.25	24511.0
2019-01-03 07:30:00	MSFT	Stock	99.38	99.51	99.21	99.5	12684.0
2019-01-03 08:00:00	MSFT	Stock	99.25	99.85	99.0	99.7	50992.0
2019-01-03 08:30:00	MSFT	Stock	99.75	100.03	99.6	99.92	30682.0
2019-01-03 09:00:00	MSFT	Stock	99.8	100.4	99.74	100.14	40981.0
2019-01-03 09:30:00	MSFT	Stock	100.07	100.185	98.63	99.02	4054290.0
2019-01-03 10:00:00	MSFT	Stock	98.99	98.99	97.74	98.36	3787698.0
2019-01-03 10:30:00	MSFT	Stock	98.35	98.38	97.46	97.973	2958623.0
2019-01-03 11:00:00	MSFT	Stock	97.98	98.88	97.95	98.47	2527017.0
2019-01-03 11:30:00	MSFT	Stock	98.46	99.589	98.28	99.08	2269004.0
2019-01-03 12:00:00	MSFT	Stock	99.08	99.29	98.6	98.76	1291739.0
2019-01-03 12:30:00	MSFT	Stock	98.78	99.27	98.61	99.2	1178236.0
2019-01-03 13:00:00	MSFT	Stock	99.19	99.193	98.09	98.44	1679636.0

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

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