PREVIEW / stock_30min / 2019-01-18

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-18.parquet
  size:    1.7 MB
  rows:    84,108
  symbols: 2,699

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-18 04:00:00	AAPL	Stock	39.125	39.1625	39.125	39.1625	5680.0
2019-01-18 04:30:00	AAPL	Stock	39.195	39.23	39.185	39.195	11000.0
2019-01-18 05:00:00	AAPL	Stock	39.2	39.2	39.0025	39.0025	19260.0
2019-01-18 05:30:00	AAPL	Stock	39.0125	39.0325	39.0125	39.0325	5076.0
2019-01-18 06:00:00	AAPL	Stock	39.075	39.125	39.075	39.125	3192.0
2019-01-18 06:30:00	AAPL	Stock	39.15	39.1675	39.15	39.1675	4872.0
2019-01-18 07:00:00	AAPL	Stock	39.175	39.24	39.1325	39.225	121012.0
2019-01-18 07:30:00	AAPL	Stock	39.225	39.235	39.155	39.155	61492.0
2019-01-18 08:00:00	AAPL	Stock	39.2382	39.25	39.125	39.2325	267140.0
2019-01-18 08:30:00	AAPL	Stock	39.245	39.29	39.225	39.255	316640.0
2019-01-18 09:00:00	AAPL	Stock	39.255	39.4925	39.2375	39.38	1056192.0
2019-01-18 09:30:00	AAPL	Stock	39.38	39.43	39.055	39.135	25312968.0
2019-01-18 10:00:00	AAPL	Stock	39.135	39.47	39.055	39.26	11364364.0
2019-01-18 10:30:00	AAPL	Stock	39.26	39.375	39.2175	39.2525	6398984.0
2019-01-18 11:00:00	AAPL	Stock	39.2528	39.3625	39.185	39.2825	5984848.0
2019-01-18 11:30:00	AAPL	Stock	39.2825	39.325	39.215	39.325	3980272.0
2019-01-18 12:00:00	AAPL	Stock	39.325	39.3675	39.2125	39.2708	6657944.0
2019-01-18 12:30:00	AAPL	Stock	39.2725	39.4075	39.2725	39.3608	4704796.0
2019-01-18 13:00:00	AAPL	Stock	39.365	39.4025	39.0375	39.32	5586524.0
2019-01-18 13:30:00	AAPL	Stock	39.3188	39.36	39.2675	39.3575	2902936.0
2019-01-18 14:00:00	AAPL	Stock	39.355	39.3675	39.1875	39.1875	4800640.0
2019-01-18 14:30:00	AAPL	Stock	39.185	39.205	39.07	39.1725	5563272.0
2019-01-18 15:00:00	AAPL	Stock	39.1738	39.1788	39.055	39.0688	4528924.0
2019-01-18 15:30:00	AAPL	Stock	39.07	39.2175	38.9952	39.205	13300872.0
2019-01-18 16:00:00	AAPL	Stock	39.22	39.22	39.0935	39.1225	13892848.0
2019-01-18 16:30:00	AAPL	Stock	39.125	39.171	39.1125	39.1625	39908.0
2019-01-18 17:00:00	AAPL	Stock	39.15	39.1625	39.125	39.1375	30936.0
2019-01-18 17:30:00	AAPL	Stock	39.1375	39.205	39.1192	39.15	522264.0
2019-01-18 18:00:00	AAPL	Stock	39.1625	39.205	39.115	39.115	138708.0
2019-01-18 18:30:00	AAPL	Stock	39.1775	39.1775	39.14	39.14	7380.0
2019-01-18 19:00:00	AAPL	Stock	39.15	39.15	39.125	39.125	7420.0
2019-01-18 19:30:00	AAPL	Stock	39.15	39.1725	39.1125	39.14	22668.0
2019-01-18 04:00:00	MSFT	Stock	106.59	106.75	106.59	106.75	600.0
2019-01-18 04:30:00	MSFT	Stock	106.78	106.78	106.78	106.78	600.0
2019-01-18 05:00:00	MSFT	Stock	106.77	106.78	106.41	106.49	3911.0
2019-01-18 05:30:00	MSFT	Stock	106.4	106.5	106.4	106.5	5665.0
2019-01-18 06:00:00	MSFT	Stock	106.5	106.55	106.5	106.55	1000.0
2019-01-18 06:30:00	MSFT	Stock	106.64	106.77	106.64	106.72	3325.0
2019-01-18 07:00:00	MSFT	Stock	106.85	107.07	106.85	106.92	29461.0
2019-01-18 07:30:00	MSFT	Stock	106.94	106.95	106.85	106.85	3233.0
2019-01-18 08:00:00	MSFT	Stock	106.98	106.99	106.8	106.82	21811.0
2019-01-18 08:30:00	MSFT	Stock	106.85	106.96	106.81	106.82	10030.0
2019-01-18 09:00:00	MSFT	Stock	106.94	107.8	106.81	107.47	330125.0
2019-01-18 09:30:00	MSFT	Stock	107.45	107.71	106.19	106.375	8978207.0
2019-01-18 10:00:00	MSFT	Stock	106.38	106.68	105.91	106.29	3385279.0
2019-01-18 10:30:00	MSFT	Stock	106.3	107.12	106.3	106.965	1950353.0
2019-01-18 11:00:00	MSFT	Stock	106.97	107.59	106.9	107.49	2018465.0
2019-01-18 11:30:00	MSFT	Stock	107.48	107.51	107.18	107.36	1190004.0
2019-01-18 12:00:00	MSFT	Stock	107.37	107.7	107.28	107.7	1480138.0
2019-01-18 12:30:00	MSFT	Stock	107.7	107.89	107.61	107.885	1415035.0

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

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