PREVIEW / stock_30min / 2019-04-30

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-30.parquet
  size:    1.7 MB
  rows:    85,615
  symbols: 2,624

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-04-30 04:00:00	AAPL	Stock	50.7525	50.795	50.6925	50.75	46812.0
2019-04-30 04:30:00	AAPL	Stock	50.7675	50.8375	50.7675	50.8375	21164.0
2019-04-30 05:00:00	AAPL	Stock	50.85	50.9	50.8125	50.9	13676.0
2019-04-30 05:30:00	AAPL	Stock	50.85	50.9125	50.8475	50.875	14572.0
2019-04-30 06:00:00	AAPL	Stock	50.875	50.875	50.85	50.85	1600.0
2019-04-30 06:30:00	AAPL	Stock	50.8925	50.925	50.875	50.925	7796.0
2019-04-30 07:00:00	AAPL	Stock	50.88	50.9375	50.84	50.9375	75040.0
2019-04-30 07:30:00	AAPL	Stock	50.9475	50.9475	50.8425	50.9125	69960.0
2019-04-30 08:00:00	AAPL	Stock	50.9125	50.9625	50.8125	50.895	298120.0
2019-04-30 08:30:00	AAPL	Stock	50.875	50.935	50.8125	50.825	193328.0
2019-04-30 09:00:00	AAPL	Stock	50.815	50.9	50.7275	50.785	373564.0
2019-04-30 09:30:00	AAPL	Stock	50.765	50.85	50.1525	50.1612	18298596.0
2019-04-30 10:00:00	AAPL	Stock	50.1675	50.3625	50.0825	50.2258	13875468.0
2019-04-30 10:30:00	AAPL	Stock	50.2275	50.33	50.1525	50.157	8004464.0
2019-04-30 11:00:00	AAPL	Stock	50.1525	50.165	49.7775	49.92	15948424.0
2019-04-30 11:30:00	AAPL	Stock	49.92	50.1925	49.92	50.1088	7530372.0
2019-04-30 12:00:00	AAPL	Stock	50.1125	50.2175	50.0675	50.2065	5284824.0
2019-04-30 12:30:00	AAPL	Stock	50.205	50.2225	50.0425	50.1975	6052588.0
2019-04-30 13:00:00	AAPL	Stock	50.1975	50.24	50.05	50.144	5339492.0
2019-04-30 13:30:00	AAPL	Stock	50.1448	50.3325	50.116	50.3158	5809448.0
2019-04-30 14:00:00	AAPL	Stock	50.315	50.375	50.2625	50.3388	6364312.0
2019-04-30 14:30:00	AAPL	Stock	50.34	50.3713	50.255	50.2788	6121756.0
2019-04-30 15:00:00	AAPL	Stock	50.2775	50.32	50.19	50.19	8002500.0
2019-04-30 15:30:00	AAPL	Stock	50.1912	50.25	50.125	50.1425	17071988.0
2019-04-30 16:00:00	AAPL	Stock	50.1375	50.625	50.0025	50.625	9559816.0
2019-04-30 16:30:00	AAPL	Stock	50.625	53.25	50.625	52.875	17765368.0
2019-04-30 17:00:00	AAPL	Stock	52.875	52.975	52.505	52.625	4106960.0
2019-04-30 17:30:00	AAPL	Stock	52.6875	52.7875	52.4725	52.7375	1122528.0
2019-04-30 18:00:00	AAPL	Stock	52.7325	52.7325	52.45	52.455	548920.0
2019-04-30 18:30:00	AAPL	Stock	52.4625	52.6	52.455	52.5575	278072.0
2019-04-30 19:00:00	AAPL	Stock	52.55	52.65	52.525	52.65	170920.0
2019-04-30 19:30:00	AAPL	Stock	52.6675	52.7125	52.5775	52.6975	380076.0
2019-04-30 04:00:00	MSFT	Stock	129.68	129.68	129.59	129.59	246.0
2019-04-30 04:30:00	MSFT	Stock	129.6	129.6	129.6	129.6	350.0
2019-04-30 05:00:00	MSFT	Stock	129.6	129.8	129.6	129.8	1650.0
2019-04-30 05:30:00	MSFT	Stock	129.71	129.71	129.71	129.71	848.0
2019-04-30 06:00:00	MSFT	Stock	129.76	129.79	129.76	129.79	700.0
2019-04-30 06:30:00	MSFT	Stock	129.73	129.98	129.7	129.85	3279.0
2019-04-30 07:00:00	MSFT	Stock	129.89	130.09	129.89	130.05	11054.0
2019-04-30 07:30:00	MSFT	Stock	130.06	130.09	129.9	129.96	1946.0
2019-04-30 08:00:00	MSFT	Stock	129.83	130.15	129.83	129.98	6965.0
2019-04-30 08:30:00	MSFT	Stock	130.0	130.0	129.7	129.8	11397.0
2019-04-30 09:00:00	MSFT	Stock	129.8	129.86	129.631	129.78	18068.0
2019-04-30 09:30:00	MSFT	Stock	129.83	130.493	129.41	130.455	2521511.0
2019-04-30 10:00:00	MSFT	Stock	130.45	130.68	129.86	130.0	1918802.0
2019-04-30 10:30:00	MSFT	Stock	130.0	130.165	129.74	129.86	1367976.0
2019-04-30 11:00:00	MSFT	Stock	129.85	129.88	129.395	129.58	1766029.0
2019-04-30 11:30:00	MSFT	Stock	129.59	130.03	129.58	129.9	985916.0
2019-04-30 12:00:00	MSFT	Stock	129.9	130.27	129.89	130.185	793093.0
2019-04-30 12:30:00	MSFT	Stock	130.19	130.45	130.16	130.365	865282.0

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

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