PREVIEW / stock_30min / 2020-03-26

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-26.parquet
  size:    1.9 MB
  rows:    95,155
  symbols: 2,443

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-03-26 04:00:00	AAPL	Stock	60.8	61.0	60.5325	60.75	61500.0
2020-03-26 04:30:00	AAPL	Stock	60.6275	60.8375	60.5	60.825	29188.0
2020-03-26 05:00:00	AAPL	Stock	61.0	61.1325	60.75	60.75	10288.0
2020-03-26 05:30:00	AAPL	Stock	60.8675	61.03	60.7825	60.98	3752.0
2020-03-26 06:00:00	AAPL	Stock	61.03	61.125	61.025	61.1	13884.0
2020-03-26 06:30:00	AAPL	Stock	61.125	61.45	61.07	61.07	35812.0
2020-03-26 07:00:00	AAPL	Stock	61.0075	61.4	61.0	61.335	232724.0
2020-03-26 07:30:00	AAPL	Stock	61.3275	61.4	60.625	60.6725	257024.0
2020-03-26 08:00:00	AAPL	Stock	60.6275	61.4	60.1575	60.2475	640328.0
2020-03-26 08:30:00	AAPL	Stock	60.1625	61.575	60.1	61.5025	1329228.0
2020-03-26 09:00:00	AAPL	Stock	61.5	62.4475	61.2528	61.6625	1260056.0
2020-03-26 09:30:00	AAPL	Stock	61.6325	63.0475	61.59	62.1975	27097692.0
2020-03-26 10:00:00	AAPL	Stock	62.2	62.915	61.8475	62.6225	18022968.0
2020-03-26 10:30:00	AAPL	Stock	62.6438	63.155	62.3125	62.7322	13940500.0
2020-03-26 11:00:00	AAPL	Stock	62.7125	63.2622	62.4775	63.2175	9773880.0
2020-03-26 11:30:00	AAPL	Stock	63.2058	63.669	63.075	63.445	12681780.0
2020-03-26 12:00:00	AAPL	Stock	63.4575	63.745	63.2075	63.5575	9360512.0
2020-03-26 12:30:00	AAPL	Stock	63.585	63.75	63.3475	63.5475	7697348.0
2020-03-26 13:00:00	AAPL	Stock	63.555	63.7325	62.86	63.0125	9484384.0
2020-03-26 13:30:00	AAPL	Stock	62.995	63.1075	62.54	62.985	8904228.0
2020-03-26 14:00:00	AAPL	Stock	62.9825	63.3925	62.9275	63.3325	9084668.0
2020-03-26 14:30:00	AAPL	Stock	63.3325	63.5888	63.005	63.2408	10398656.0
2020-03-26 15:00:00	AAPL	Stock	63.2325	63.3375	62.6475	63.24	9766872.0
2020-03-26 15:30:00	AAPL	Stock	63.24	64.67	62.6525	64.62	31949236.0
2020-03-26 16:00:00	AAPL	Stock	64.4375	64.62	63.1992	64.3	28292928.0
2020-03-26 16:30:00	AAPL	Stock	64.295	64.39	64.25	64.375	161644.0
2020-03-26 17:00:00	AAPL	Stock	64.3925	64.4375	64.18	64.25	97852.0
2020-03-26 17:30:00	AAPL	Stock	64.245	64.49	64.245	64.49	76896.0
2020-03-26 18:00:00	AAPL	Stock	64.4575	64.55	64.335	64.425	171088.0
2020-03-26 18:30:00	AAPL	Stock	64.425	64.5225	64.125	64.125	103224.0
2020-03-26 19:00:00	AAPL	Stock	64.15	64.3625	64.0525	64.35	74152.0
2020-03-26 19:30:00	AAPL	Stock	64.3	64.75	64.2475	64.7325	167692.0
2020-03-26 04:00:00	MSFT	Stock	144.99	145.97	144.28	144.3	13336.0
2020-03-26 04:30:00	MSFT	Stock	144.1	144.5	144.05	144.16	3275.0
2020-03-26 05:00:00	MSFT	Stock	144.56	145.24	144.45	145.06	4359.0
2020-03-26 05:30:00	MSFT	Stock	145.16	145.5	145.0	145.38	5232.0
2020-03-26 06:00:00	MSFT	Stock	145.52	145.52	145.52	145.52	138.0
2020-03-26 06:30:00	MSFT	Stock	145.75	147.24	145.75	146.4	15639.0
2020-03-26 07:00:00	MSFT	Stock	146.85	146.88	146.0	146.44	26782.0
2020-03-26 07:30:00	MSFT	Stock	146.1	146.2	144.88	145.0	34565.0
2020-03-26 08:00:00	MSFT	Stock	146.5	146.9	143.9	144.0	85193.0
2020-03-26 08:30:00	MSFT	Stock	144.0	148.35	143.65	148.2	139782.0
2020-03-26 09:00:00	MSFT	Stock	148.0	149.91	147.26	148.24	164439.0
2020-03-26 09:30:00	MSFT	Stock	148.42	152.63	148.1	151.94	6031198.0
2020-03-26 10:00:00	MSFT	Stock	152.0	153.36	151.22	152.69	4301764.0
2020-03-26 10:30:00	MSFT	Stock	152.64	154.24	151.8	153.2	3812243.0
2020-03-26 11:00:00	MSFT	Stock	153.14	153.5	151.76	153.07	2682202.0
2020-03-26 11:30:00	MSFT	Stock	153.06	153.975	152.75	153.4	2621805.0
2020-03-26 12:00:00	MSFT	Stock	153.47	154.0	152.84	153.134	2577587.0
2020-03-26 12:30:00	MSFT	Stock	153.14	154.0	153.02	153.85	1794162.0

> showing 50 of 95,155 rows — these rows as CSV

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