PREVIEW / stock_30min / 2019-11-13

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-13.parquet
  size:    1.7 MB
  rows:    84,398
  symbols: 2,512

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-11-13 04:00:00	AAPL	Stock	65.3675	65.3775	65.155	65.2	25716.0
2019-11-13 04:30:00	AAPL	Stock	65.195	65.2	65.0	65.0375	43744.0
2019-11-13 05:00:00	AAPL	Stock	65.085	65.145	65.075	65.145	13664.0
2019-11-13 05:30:00	AAPL	Stock	65.145	65.15	65.055	65.095	24784.0
2019-11-13 06:00:00	AAPL	Stock	65.1	65.135	65.0325	65.135	34128.0
2019-11-13 06:30:00	AAPL	Stock	65.1325	65.135	65.1025	65.1025	5712.0
2019-11-13 07:00:00	AAPL	Stock	65.185	65.25	65.17	65.225	114684.0
2019-11-13 07:30:00	AAPL	Stock	65.235	65.345	65.225	65.3	139828.0
2019-11-13 08:00:00	AAPL	Stock	65.49	65.49	65.1375	65.3375	81088.0
2019-11-13 08:30:00	AAPL	Stock	65.315	65.4	65.3125	65.3625	120712.0
2019-11-13 09:00:00	AAPL	Stock	65.3625	65.375	65.265	65.2775	180992.0
2019-11-13 09:30:00	AAPL	Stock	65.2775	65.695	65.2675	65.625	11104596.0
2019-11-13 10:00:00	AAPL	Stock	65.6225	65.7725	65.5725	65.7575	6090540.0
2019-11-13 10:30:00	AAPL	Stock	65.76	65.9175	65.6525	65.9018	7927688.0
2019-11-13 11:00:00	AAPL	Stock	65.9075	66.0325	65.8675	65.91	7114916.0
2019-11-13 11:30:00	AAPL	Stock	65.9125	66.0425	65.8575	66.0225	4987744.0
2019-11-13 12:00:00	AAPL	Stock	66.02	66.0475	65.9225	65.9412	3665056.0
2019-11-13 12:30:00	AAPL	Stock	65.9425	66.0475	65.94	66.01	3289636.0
2019-11-13 13:00:00	AAPL	Stock	66.0075	66.1462	66.005	66.0625	4183396.0
2019-11-13 13:30:00	AAPL	Stock	66.065	66.17	65.8275	65.9975	5640088.0
2019-11-13 14:00:00	AAPL	Stock	66.0	66.0	65.645	65.8295	9364696.0
2019-11-13 14:30:00	AAPL	Stock	65.825	66.04	65.8125	66.015	4467260.0
2019-11-13 15:00:00	AAPL	Stock	66.02	66.195	66.02	66.1158	5542960.0
2019-11-13 15:30:00	AAPL	Stock	66.1125	66.1725	66.01	66.1175	8077352.0
2019-11-13 16:00:00	AAPL	Stock	66.1238	66.1625	66.0725	66.1525	6584400.0
2019-11-13 16:30:00	AAPL	Stock	66.155	66.1875	66.1175	66.1875	76232.0
2019-11-13 17:00:00	AAPL	Stock	66.15	66.2	66.15	66.1775	27696.0
2019-11-13 17:30:00	AAPL	Stock	66.175	66.1875	66.1675	66.1775	15032.0
2019-11-13 18:00:00	AAPL	Stock	66.1775	66.18	66.14	66.1525	27124.0
2019-11-13 18:30:00	AAPL	Stock	66.155	66.1775	66.14	66.1625	24024.0
2019-11-13 19:00:00	AAPL	Stock	66.1625	66.18	66.1575	66.1625	18836.0
2019-11-13 19:30:00	AAPL	Stock	66.165	66.175	66.1375	66.15	24760.0
2019-11-13 04:00:00	MSFT	Stock	146.62	146.77	146.6	146.77	530.0
2019-11-13 04:30:00	MSFT	Stock	146.59	146.59	146.32	146.32	797.0
2019-11-13 05:00:00	MSFT	Stock	146.46	146.5	146.46	146.5	1272.0
2019-11-13 05:30:00	MSFT	Stock	146.45	146.45	146.45	146.45	300.0
2019-11-13 06:00:00	MSFT	Stock	146.45	146.45	146.45	146.45	1571.0
2019-11-13 06:30:00	MSFT	Stock	146.45	146.45	146.35	146.35	2533.0
2019-11-13 07:00:00	MSFT	Stock	146.45	146.6	146.45	146.51	3712.0
2019-11-13 07:30:00	MSFT	Stock	146.5	146.57	146.45	146.55	8534.0
2019-11-13 08:00:00	MSFT	Stock	147.07	147.07	146.365	146.6	14780.0
2019-11-13 08:30:00	MSFT	Stock	146.6	146.88	146.5	146.6	6025.0
2019-11-13 09:00:00	MSFT	Stock	146.74	146.84	146.55	146.84	13943.0
2019-11-13 09:30:00	MSFT	Stock	146.84	147.15	146.28	147.14	1883955.0
2019-11-13 10:00:00	MSFT	Stock	147.14	147.462	147.09	147.26	1230194.0
2019-11-13 10:30:00	MSFT	Stock	147.262	147.46	147.01	147.35	986222.0
2019-11-13 11:00:00	MSFT	Stock	147.35	147.4	146.86	146.86	800782.0
2019-11-13 11:30:00	MSFT	Stock	146.87	147.14	146.85	147.09	621520.0
2019-11-13 12:00:00	MSFT	Stock	147.086	147.208	146.99	147.02	433842.0
2019-11-13 12:30:00	MSFT	Stock	147.021	147.22	147.01	147.174	715921.0

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

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