PREVIEW / stock_30min / 2018-02-01

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-01.parquet
  size:    1.7 MB
  rows:    84,843
  symbols: 2,905

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-01 04:00:00	AAPL	Stock	42.0	42.0	41.855	41.855	53812.0
2018-02-01 04:30:00	AAPL	Stock	41.85	41.9075	41.85	41.885	12908.0
2018-02-01 05:00:00	AAPL	Stock	41.875	41.925	41.8	41.925	36240.0
2018-02-01 05:30:00	AAPL	Stock	41.92	41.92	41.8625	41.8625	12772.0
2018-02-01 06:00:00	AAPL	Stock	41.85	41.9375	41.825	41.9125	33004.0
2018-02-01 06:30:00	AAPL	Stock	41.925	41.9475	41.8675	41.9	30432.0
2018-02-01 07:00:00	AAPL	Stock	41.9	41.925	41.825	41.91	142840.0
2018-02-01 07:30:00	AAPL	Stock	41.905	41.9225	41.875	41.9125	59288.0
2018-02-01 08:00:00	AAPL	Stock	41.9125	41.92	41.7725	41.7775	229528.0
2018-02-01 08:30:00	AAPL	Stock	41.7975	41.8575	41.6775	41.7375	433376.0
2018-02-01 09:00:00	AAPL	Stock	41.745	41.82	41.6575	41.785	329200.0
2018-02-01 09:30:00	AAPL	Stock	41.7912	42.065	41.69	41.97	17507180.0
2018-02-01 10:00:00	AAPL	Stock	41.9575	42.05	41.775	41.8025	8864424.0
2018-02-01 10:30:00	AAPL	Stock	41.805	41.865	41.7425	41.785	10337952.0
2018-02-01 11:00:00	AAPL	Stock	41.7875	41.835	41.745	41.7975	6539784.0
2018-02-01 11:30:00	AAPL	Stock	41.8	42.0125	41.78	42.0125	7800280.0
2018-02-01 12:00:00	AAPL	Stock	42.0125	42.155	41.93	42.07	8069164.0
2018-02-01 12:30:00	AAPL	Stock	42.07	42.15	41.9475	41.9512	7895564.0
2018-02-01 13:00:00	AAPL	Stock	41.9512	42.0425	41.93	41.9782	4704504.0
2018-02-01 13:30:00	AAPL	Stock	41.9775	41.9938	41.83	41.865	6659532.0
2018-02-01 14:00:00	AAPL	Stock	41.8625	41.9	41.78	41.8825	5994036.0
2018-02-01 14:30:00	AAPL	Stock	41.8775	42.0325	41.835	42.025	7215776.0
2018-02-01 15:00:00	AAPL	Stock	42.025	42.0275	41.7778	41.7898	9285088.0
2018-02-01 15:30:00	AAPL	Stock	41.7875	42.025	41.7025	41.925	18095600.0
2018-02-01 16:00:00	AAPL	Stock	41.945	42.3	41.7825	42.025	14030312.0
2018-02-01 16:30:00	AAPL	Stock	42.025	42.5	40.6375	42.345	13213236.0
2018-02-01 17:00:00	AAPL	Stock	42.345	43.2	41.93	42.9825	10338384.0
2018-02-01 17:30:00	AAPL	Stock	43.0	43.5625	42.65	43.35	6354400.0
2018-02-01 18:00:00	AAPL	Stock	43.3725	43.45	43.225	43.42	1841244.0
2018-02-01 18:30:00	AAPL	Stock	43.42	43.425	43.2875	43.2875	613416.0
2018-02-01 19:00:00	AAPL	Stock	43.2875	43.3375	43.225	43.3	235224.0
2018-02-01 19:30:00	AAPL	Stock	43.2825	43.3725	43.2825	43.3725	347840.0
2018-02-01 04:00:00	MSFT	Stock	95.5	95.5	94.6	94.6	7127.0
2018-02-01 04:30:00	MSFT	Stock	94.75	94.75	94.71	94.71	2500.0
2018-02-01 05:00:00	MSFT	Stock	94.89	95.2	94.89	95.2	3309.0
2018-02-01 05:30:00	MSFT	Stock	95.17	95.17	95.12	95.12	621.0
2018-02-01 06:00:00	MSFT	Stock	95.1	95.14	95.05	95.14	10257.0
2018-02-01 06:30:00	MSFT	Stock	95.12	95.13	94.85	95.0	4440.0
2018-02-01 07:00:00	MSFT	Stock	95.0	95.0	93.71	94.29	74835.0
2018-02-01 07:30:00	MSFT	Stock	94.3	94.64	94.0	94.25	30118.0
2018-02-01 08:00:00	MSFT	Stock	95.01	95.01	93.28	94.11	135689.0
2018-02-01 08:30:00	MSFT	Stock	94.1	94.11	93.3	93.81	237351.0
2018-02-01 09:00:00	MSFT	Stock	93.75	95.2	93.62	94.94	297896.0
2018-02-01 09:30:00	MSFT	Stock	94.79	95.84	94.2	95.039	9058950.0
2018-02-01 10:00:00	MSFT	Stock	95.04	95.49	94.95	95.27	3270761.0
2018-02-01 10:30:00	MSFT	Stock	95.27	96.07	95.2	96.02	3666458.0
2018-02-01 11:00:00	MSFT	Stock	96.014	96.035	95.42	95.46	2415353.0
2018-02-01 11:30:00	MSFT	Stock	95.47	95.63	95.36	95.53	1469124.0
2018-02-01 12:00:00	MSFT	Stock	95.535	95.99	95.01	95.855	2047393.0
2018-02-01 12:30:00	MSFT	Stock	95.86	95.94	95.73	95.82	1354406.0

> showing 50 of 84,843 rows — these rows as CSV

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