PREVIEW / stock_30min / 2019-08-19

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-19.parquet
  size:    1.7 MB
  rows:    85,288
  symbols: 2,561

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-08-19 04:00:00	AAPL	Stock	52.15	52.3725	52.15	52.3	33744.0
2019-08-19 04:30:00	AAPL	Stock	52.25	52.25	52.15	52.15	10000.0
2019-08-19 05:00:00	AAPL	Stock	52.2675	52.2675	52.22	52.22	800.0
2019-08-19 05:30:00	AAPL	Stock	52.245	52.3075	52.245	52.3075	4600.0
2019-08-19 06:00:00	AAPL	Stock	52.36	52.44	52.3375	52.44	31092.0
2019-08-19 06:30:00	AAPL	Stock	52.35	52.5825	52.35	52.4975	20588.0
2019-08-19 07:00:00	AAPL	Stock	52.4275	52.5625	52.4125	52.535	148808.0
2019-08-19 07:30:00	AAPL	Stock	52.5475	52.635	52.525	52.6	120684.0
2019-08-19 08:00:00	AAPL	Stock	52.48	52.6325	52.4425	52.6225	399056.0
2019-08-19 08:30:00	AAPL	Stock	52.6	52.7125	52.6	52.6375	182876.0
2019-08-19 09:00:00	AAPL	Stock	52.675	52.6875	52.6175	52.655	270972.0
2019-08-19 09:30:00	AAPL	Stock	52.6725	53.1828	52.5062	53.0275	21310612.0
2019-08-19 10:00:00	AAPL	Stock	53.025	53.0598	52.812	52.816	7361040.0
2019-08-19 10:30:00	AAPL	Stock	52.815	53.03	52.78	52.985	6451664.0
2019-08-19 11:00:00	AAPL	Stock	52.9842	53.045	52.9625	52.995	4337048.0
2019-08-19 11:30:00	AAPL	Stock	52.99	53.045	52.895	52.935	4087328.0
2019-08-19 12:00:00	AAPL	Stock	52.935	52.9675	52.8525	52.88	3220120.0
2019-08-19 12:30:00	AAPL	Stock	52.8812	52.985	52.845	52.98	3213100.0
2019-08-19 13:00:00	AAPL	Stock	52.9788	53.03	52.94	52.9975	3365776.0
2019-08-19 13:30:00	AAPL	Stock	52.9975	53.0025	52.95	52.9625	2254720.0
2019-08-19 14:00:00	AAPL	Stock	52.9625	52.97	52.875	52.9175	2932784.0
2019-08-19 14:30:00	AAPL	Stock	52.92	52.9212	52.725	52.7685	3778216.0
2019-08-19 15:00:00	AAPL	Stock	52.7725	52.8355	52.71	52.8325	3611488.0
2019-08-19 15:30:00	AAPL	Stock	52.8312	52.84	52.5325	52.585	9109196.0
2019-08-19 16:00:00	AAPL	Stock	52.5875	52.6125	52.5275	52.575	8590016.0
2019-08-19 16:30:00	AAPL	Stock	52.5875	52.6225	52.3775	52.6125	239840.0
2019-08-19 17:00:00	AAPL	Stock	52.5875	52.5875	52.5075	52.525	23312.0
2019-08-19 17:30:00	AAPL	Stock	52.5375	52.545	52.51	52.515	5068.0
2019-08-19 18:00:00	AAPL	Stock	52.51	52.575	52.5025	52.5625	32084.0
2019-08-19 18:30:00	AAPL	Stock	52.56	52.575	52.55	52.56	20616.0
2019-08-19 19:00:00	AAPL	Stock	52.575	52.5875	52.5625	52.5625	9260.0
2019-08-19 19:30:00	AAPL	Stock	52.5875	52.6	52.5125	52.525	22940.0
2019-08-19 04:00:00	MSFT	Stock	137.62	137.69	137.31	137.52	2882.0
2019-08-19 04:30:00	MSFT	Stock	137.53	137.53	136.62	136.84	2755.0
2019-08-19 05:00:00	MSFT	Stock	137.1	137.1	137.1	137.1	100.0
2019-08-19 05:30:00	MSFT	Stock	137.43	137.5	137.43	137.5	3506.0
2019-08-19 06:00:00	MSFT	Stock	137.59	137.59	137.51	137.51	1131.0
2019-08-19 06:30:00	MSFT	Stock	137.4	137.9	137.37	137.8	1878.0
2019-08-19 07:00:00	MSFT	Stock	137.68	137.84	137.55	137.83	5338.0
2019-08-19 07:30:00	MSFT	Stock	137.84	138.0	137.76	137.8	13793.0
2019-08-19 08:00:00	MSFT	Stock	137.875	138.0	137.56	137.75	50730.0
2019-08-19 08:30:00	MSFT	Stock	137.7	137.89	137.66	137.79	15865.0
2019-08-19 09:00:00	MSFT	Stock	137.78	137.97	137.61	137.79	43403.0
2019-08-19 09:30:00	MSFT	Stock	137.86	138.262	137.44	137.647	2822323.0
2019-08-19 10:00:00	MSFT	Stock	137.65	137.71	136.885	137.5	1550450.0
2019-08-19 10:30:00	MSFT	Stock	137.505	137.86	137.47	137.7	1078312.0
2019-08-19 11:00:00	MSFT	Stock	137.7	137.95	137.68	137.78	924316.0
2019-08-19 11:30:00	MSFT	Stock	137.77	137.99	137.69	137.82	950438.0
2019-08-19 12:00:00	MSFT	Stock	137.81	137.84	137.64	137.82	620744.0
2019-08-19 12:30:00	MSFT	Stock	137.82	138.165	137.73	138.09	1538849.0

> showing 50 of 85,288 rows — these rows as CSV

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