PREVIEW / stock_30min / 2018-03-15

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-15.parquet
  size:    1.7 MB
  rows:    82,919
  symbols: 2,867

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-03-15 04:30:00	AAPL	Stock	44.6075	44.7175	44.6075	44.7175	11032.0
2018-03-15 05:00:00	AAPL	Stock	44.7175	44.7175	44.7175	44.7175	1360.0
2018-03-15 05:30:00	AAPL	Stock	44.7125	44.7125	44.7	44.7	3956.0
2018-03-15 06:00:00	AAPL	Stock	44.65	44.65	44.61	44.645	1600.0
2018-03-15 06:30:00	AAPL	Stock	44.5875	44.5875	44.55	44.55	4400.0
2018-03-15 07:00:00	AAPL	Stock	44.595	44.5975	44.535	44.57	84920.0
2018-03-15 07:30:00	AAPL	Stock	44.575	44.61	44.5575	44.58	22064.0
2018-03-15 08:00:00	AAPL	Stock	44.59	44.59	44.5375	44.55	129664.0
2018-03-15 08:30:00	AAPL	Stock	44.545	44.6575	44.535	44.6275	207696.0
2018-03-15 09:00:00	AAPL	Stock	44.625	44.71	44.6125	44.625	206672.0
2018-03-15 09:30:00	AAPL	Stock	44.625	44.7075	44.5675	44.6622	10815980.0
2018-03-15 10:00:00	AAPL	Stock	44.66	44.89	44.66	44.8635	7988768.0
2018-03-15 10:30:00	AAPL	Stock	44.865	44.935	44.7825	44.8725	6187688.0
2018-03-15 11:00:00	AAPL	Stock	44.8725	45.06	44.8725	44.99	6551152.0
2018-03-15 11:30:00	AAPL	Stock	44.9925	44.9975	44.8625	44.9475	5067988.0
2018-03-15 12:00:00	AAPL	Stock	44.9475	44.9675	44.84	44.8625	3255504.0
2018-03-15 12:30:00	AAPL	Stock	44.865	44.9525	44.7875	44.8825	3408464.0
2018-03-15 13:00:00	AAPL	Stock	44.88	44.905	44.7075	44.78	3865936.0
2018-03-15 13:30:00	AAPL	Stock	44.7825	44.795	44.525	44.545	5085736.0
2018-03-15 14:00:00	AAPL	Stock	44.5425	44.6825	44.5175	44.5975	4265688.0
2018-03-15 14:30:00	AAPL	Stock	44.6	44.74	44.58	44.738	3361500.0
2018-03-15 15:00:00	AAPL	Stock	44.7375	44.7772	44.6525	44.7725	4803236.0
2018-03-15 15:30:00	AAPL	Stock	44.77	44.815	44.6575	44.6625	9753012.0
2018-03-15 16:00:00	AAPL	Stock	44.6625	44.7375	44.6625	44.695	6565780.0
2018-03-15 16:30:00	AAPL	Stock	44.7	44.7425	44.6625	44.7425	18036.0
2018-03-15 17:00:00	AAPL	Stock	44.735	44.735	44.6875	44.7125	26540.0
2018-03-15 17:30:00	AAPL	Stock	44.72	44.7225	44.7	44.7175	7368.0
2018-03-15 18:00:00	AAPL	Stock	44.7225	44.725	44.7	44.725	7600.0
2018-03-15 18:30:00	AAPL	Stock	44.725	44.75	44.725	44.7475	10580.0
2018-03-15 19:00:00	AAPL	Stock	44.7475	44.7475	44.7475	44.7475	1120.0
2018-03-15 19:30:00	AAPL	Stock	44.7475	44.75	44.7475	44.75	14768.0
2018-03-15 04:30:00	MSFT	Stock	94.08	94.08	94.08	94.08	300.0
2018-03-15 05:00:00	MSFT	Stock	94.29	94.29	94.29	94.29	600.0
2018-03-15 06:00:00	MSFT	Stock	94.22	94.22	94.22	94.22	100.0
2018-03-15 06:30:00	MSFT	Stock	93.84	93.84	93.84	93.84	200.0
2018-03-15 07:00:00	MSFT	Stock	93.84	93.84	93.34	93.56	12755.0
2018-03-15 07:30:00	MSFT	Stock	93.64	93.65	93.45	93.45	2383.0
2018-03-15 08:00:00	MSFT	Stock	93.84	93.84	93.37	93.5	7632.0
2018-03-15 08:30:00	MSFT	Stock	93.53	93.75	93.53	93.65	11553.0
2018-03-15 09:00:00	MSFT	Stock	93.66	93.77	93.53	93.53	24277.0
2018-03-15 09:30:00	MSFT	Stock	93.53	93.829	92.83	93.77	3680975.0
2018-03-15 10:00:00	MSFT	Stock	93.78	94.02	93.73	93.975	1973219.0
2018-03-15 10:30:00	MSFT	Stock	93.97	94.18	93.82	94.105	1439538.0
2018-03-15 11:00:00	MSFT	Stock	94.105	94.44	94.105	94.41	1679462.0
2018-03-15 11:30:00	MSFT	Stock	94.42	94.58	94.25	94.385	1299142.0
2018-03-15 12:00:00	MSFT	Stock	94.39	94.47	94.2	94.265	861705.0
2018-03-15 12:30:00	MSFT	Stock	94.263	94.505	94.15	94.39	727465.0
2018-03-15 13:00:00	MSFT	Stock	94.38	94.5	94.15	94.3	684756.0
2018-03-15 13:30:00	MSFT	Stock	94.31	94.38	93.88	93.88	1192080.0
2018-03-15 14:00:00	MSFT	Stock	93.89	94.055	93.82	93.935	1127597.0

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

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