PREVIEW / stock_30min / 2018-03-08

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-08.parquet
  size:    1.7 MB
  rows:    84,548
  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-08 04:00:00	AAPL	Stock	43.75	43.7525	43.725	43.7525	12028.0
2018-03-08 04:30:00	AAPL	Stock	43.77	43.77	43.75	43.75	9200.0
2018-03-08 05:00:00	AAPL	Stock	43.75	43.75	43.75	43.75	2000.0
2018-03-08 05:30:00	AAPL	Stock	43.75	43.75	43.75	43.75	3968.0
2018-03-08 06:00:00	AAPL	Stock	43.7975	43.8625	43.7975	43.8625	6400.0
2018-03-08 06:30:00	AAPL	Stock	43.87	43.87	43.825	43.825	4400.0
2018-03-08 07:00:00	AAPL	Stock	43.85	43.9225	43.825	43.9075	157732.0
2018-03-08 07:30:00	AAPL	Stock	43.8875	43.915	43.8825	43.895	58352.0
2018-03-08 08:00:00	AAPL	Stock	43.845	43.915	43.845	43.8875	246276.0
2018-03-08 08:30:00	AAPL	Stock	43.875	43.875	43.825	43.825	51088.0
2018-03-08 09:00:00	AAPL	Stock	43.8475	43.9125	43.805	43.8525	235120.0
2018-03-08 09:30:00	AAPL	Stock	43.87	44.0225	43.81	43.835	13086668.0
2018-03-08 10:00:00	AAPL	Stock	43.8325	43.9225	43.7675	43.9025	7192248.0
2018-03-08 10:30:00	AAPL	Stock	43.9	43.9175	43.8125	43.8725	5741956.0
2018-03-08 11:00:00	AAPL	Stock	43.8725	44.0725	43.8598	44.055	6603624.0
2018-03-08 11:30:00	AAPL	Stock	44.055	44.1225	43.99	44.1025	4589652.0
2018-03-08 12:00:00	AAPL	Stock	44.1075	44.1775	44.015	44.135	5462528.0
2018-03-08 12:30:00	AAPL	Stock	44.135	44.17	44.0475	44.155	3117088.0
2018-03-08 13:00:00	AAPL	Stock	44.155	44.24	44.015	44.0675	5088928.0
2018-03-08 13:30:00	AAPL	Stock	44.07	44.1695	44.025	44.16	3563356.0
2018-03-08 14:00:00	AAPL	Stock	44.16	44.185	44.0625	44.1475	3563856.0
2018-03-08 14:30:00	AAPL	Stock	44.145	44.275	44.0725	44.2425	4795324.0
2018-03-08 15:00:00	AAPL	Stock	44.24	44.28	44.185	44.2212	4933060.0
2018-03-08 15:30:00	AAPL	Stock	44.22	44.245	44.07	44.2375	9999348.0
2018-03-08 16:00:00	AAPL	Stock	44.235	44.25	44.2075	44.22	5541412.0
2018-03-08 16:30:00	AAPL	Stock	44.22	44.235	44.205	44.205	35752.0
2018-03-08 17:00:00	AAPL	Stock	44.225	44.2425	44.2025	44.2225	108548.0
2018-03-08 17:30:00	AAPL	Stock	44.2225	44.2225	44.2	44.2125	10732.0
2018-03-08 18:00:00	AAPL	Stock	44.2	44.2125	44.2	44.2125	3600.0
2018-03-08 18:30:00	AAPL	Stock	44.2	44.25	44.2	44.25	10536.0
2018-03-08 19:00:00	AAPL	Stock	44.2475	44.2475	44.21	44.225	14200.0
2018-03-08 19:30:00	AAPL	Stock	44.235	44.2675	44.235	44.2675	28864.0
2018-03-08 04:00:00	MSFT	Stock	93.68	93.68	93.68	93.68	100.0
2018-03-08 07:00:00	MSFT	Stock	94.0	94.15	94.0	94.01	5350.0
2018-03-08 07:30:00	MSFT	Stock	94.14	94.15	94.14	94.15	2671.0
2018-03-08 08:00:00	MSFT	Stock	94.15	94.15	94.02	94.07	12363.0
2018-03-08 08:30:00	MSFT	Stock	94.11	94.16	94.08	94.1	11668.0
2018-03-08 09:00:00	MSFT	Stock	94.14	94.35	94.05	94.13	13479.0
2018-03-08 09:30:00	MSFT	Stock	94.27	95.1	94.04	94.685	3592745.0
2018-03-08 10:00:00	MSFT	Stock	94.685	95.03	94.605	94.61	1993880.0
2018-03-08 10:30:00	MSFT	Stock	94.603	94.77	94.34	94.73	1499682.0
2018-03-08 11:00:00	MSFT	Stock	94.735	95.06	94.66	94.82	1330341.0
2018-03-08 11:30:00	MSFT	Stock	94.825	94.87	94.574	94.673	895638.0
2018-03-08 12:00:00	MSFT	Stock	94.67	94.72	94.39	94.55	911593.0
2018-03-08 12:30:00	MSFT	Stock	94.54	94.57	94.281	94.35	874098.0
2018-03-08 13:00:00	MSFT	Stock	94.36	94.46	93.85	94.0	947666.0
2018-03-08 13:30:00	MSFT	Stock	94.0	94.12	93.84	94.032	1174425.0
2018-03-08 14:00:00	MSFT	Stock	94.03	94.06	93.82	93.995	774884.0
2018-03-08 14:30:00	MSFT	Stock	93.99	94.35	93.89	94.15	1231726.0
2018-03-08 15:00:00	MSFT	Stock	94.16	94.47	94.155	94.465	1495798.0

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

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