PREVIEW / stock_30min / 2020-06-01

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-01.parquet
  size:    1.9 MB
  rows:    96,726
  symbols: 2,380

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
2020-06-01 04:00:00	AAPL	Stock	79.75	79.75	78.575	79.0	51060.0
2020-06-01 04:30:00	AAPL	Stock	78.9875	79.15	78.9375	79.125	8020.0
2020-06-01 05:00:00	AAPL	Stock	79.0875	79.25	79.075	79.1875	4340.0
2020-06-01 05:30:00	AAPL	Stock	79.125	79.13	78.95	79.0	9940.0
2020-06-01 06:00:00	AAPL	Stock	79.0	79.3	79.0	79.25	5132.0
2020-06-01 06:30:00	AAPL	Stock	79.25	79.3725	78.95	79.2775	9272.0
2020-06-01 07:00:00	AAPL	Stock	79.35	79.625	79.3025	79.4925	122700.0
2020-06-01 07:30:00	AAPL	Stock	79.495	79.4975	79.33	79.375	103976.0
2020-06-01 08:00:00	AAPL	Stock	79.55	79.625	79.3125	79.3125	228176.0
2020-06-01 08:30:00	AAPL	Stock	79.315	79.425	79.125	79.2875	222896.0
2020-06-01 09:00:00	AAPL	Stock	79.28	79.4475	79.13	79.4475	175396.0
2020-06-01 09:30:00	AAPL	Stock	79.4475	80.1225	79.3025	80.04	11026080.0
2020-06-01 10:00:00	AAPL	Stock	80.0475	80.4275	79.9625	80.25	9459216.0
2020-06-01 10:30:00	AAPL	Stock	80.2475	80.3025	80.0425	80.185	4980008.0
2020-06-01 11:00:00	AAPL	Stock	80.1875	80.215	79.925	80.035	3849732.0
2020-06-01 11:30:00	AAPL	Stock	80.0325	80.2	79.9825	80.1725	2594124.0
2020-06-01 12:00:00	AAPL	Stock	80.175	80.2375	80.0625	80.1925	2625384.0
2020-06-01 12:30:00	AAPL	Stock	80.195	80.2977	80.19	80.225	2644604.0
2020-06-01 13:00:00	AAPL	Stock	80.2275	80.5625	80.225	80.525	4376384.0
2020-06-01 13:30:00	AAPL	Stock	80.5175	80.5875	80.4375	80.4925	2847496.0
2020-06-01 14:00:00	AAPL	Stock	80.4925	80.5325	80.345	80.415	2712708.0
2020-06-01 14:30:00	AAPL	Stock	80.4175	80.5658	80.398	80.5575	2858432.0
2020-06-01 15:00:00	AAPL	Stock	80.565	80.5875	80.36	80.505	4040768.0
2020-06-01 15:30:00	AAPL	Stock	80.5	80.53	80.3275	80.44	6096384.0
2020-06-01 16:00:00	AAPL	Stock	80.4625	80.495	80.2255	80.465	3054144.0
2020-06-01 16:30:00	AAPL	Stock	80.495	80.5	80.475	80.5	13316.0
2020-06-01 17:00:00	AAPL	Stock	80.5	80.5	80.475	80.475	12584.0
2020-06-01 17:30:00	AAPL	Stock	80.5	80.5225	80.4975	80.5125	21960.0
2020-06-01 18:00:00	AAPL	Stock	80.51	80.51	80.44	80.475	32676.0
2020-06-01 18:30:00	AAPL	Stock	80.465	80.485	80.2525	80.2775	52180.0
2020-06-01 19:00:00	AAPL	Stock	80.2525	80.2525	80.005	80.235	49672.0
2020-06-01 19:30:00	AAPL	Stock	80.18	80.27	80.18	80.1875	64796.0
2020-06-01 04:00:00	MSFT	Stock	183.69	183.69	181.35	181.72	1322.0
2020-06-01 04:30:00	MSFT	Stock	182.01	182.01	182.01	182.01	300.0
2020-06-01 05:00:00	MSFT	Stock	182.5	182.5	182.5	182.5	100.0
2020-06-01 05:30:00	MSFT	Stock	182.25	182.55	182.22	182.22	1958.0
2020-06-01 06:00:00	MSFT	Stock	182.05	182.52	182.05	182.52	600.0
2020-06-01 06:30:00	MSFT	Stock	182.03	182.57	182.03	182.57	626.0
2020-06-01 07:00:00	MSFT	Stock	182.28	182.91	182.28	182.75	8501.0
2020-06-01 07:30:00	MSFT	Stock	182.9	183.08	182.71	182.77	11808.0
2020-06-01 08:00:00	MSFT	Stock	182.85	183.7	182.5	182.7	26587.0
2020-06-01 08:30:00	MSFT	Stock	182.81	182.82	182.27	182.49	16718.0
2020-06-01 09:00:00	MSFT	Stock	182.45	182.65	182.12	182.36	35034.0
2020-06-01 09:30:00	MSFT	Stock	182.48	182.79	181.46	182.45	3372965.0
2020-06-01 10:00:00	MSFT	Stock	182.5	182.92	181.97	182.12	2089353.0
2020-06-01 10:30:00	MSFT	Stock	182.15	182.44	181.75	182.325	1437920.0
2020-06-01 11:00:00	MSFT	Stock	182.33	182.41	181.78	182.065	1240652.0
2020-06-01 11:30:00	MSFT	Stock	182.06	182.42	181.99	182.35	988333.0
2020-06-01 12:00:00	MSFT	Stock	182.35	182.64	182.071	182.54	773014.0
2020-06-01 12:30:00	MSFT	Stock	182.53	183.0	182.5	182.69	809398.0

> showing 50 of 96,726 rows — these rows as CSV

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