PREVIEW / stock_30min / 2019-04-16

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-16.parquet
  size:    1.7 MB
  rows:    84,206
  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-16 04:00:00	AAPL	Stock	49.8975	49.9975	49.8475	49.9425	11016.0
2019-04-16 04:30:00	AAPL	Stock	50.0175	50.0175	50.0175	50.0175	400.0
2019-04-16 05:30:00	AAPL	Stock	50.0225	50.025	50.0225	50.025	872.0
2019-04-16 06:00:00	AAPL	Stock	49.975	49.975	49.975	49.975	3140.0
2019-04-16 06:30:00	AAPL	Stock	49.9675	49.9675	49.9675	49.9675	2160.0
2019-04-16 07:00:00	AAPL	Stock	49.9275	49.97	49.915	49.9475	47968.0
2019-04-16 07:30:00	AAPL	Stock	49.94	49.9875	49.94	49.9875	45396.0
2019-04-16 08:00:00	AAPL	Stock	49.97	50.0125	49.915	49.9875	153944.0
2019-04-16 08:30:00	AAPL	Stock	49.9925	49.9925	49.9625	49.97	36196.0
2019-04-16 09:00:00	AAPL	Stock	49.9675	50.01	49.785	49.85	198976.0
2019-04-16 09:30:00	AAPL	Stock	49.865	50.0	49.7525	49.9655	10310024.0
2019-04-16 10:00:00	AAPL	Stock	49.9675	50.3425	49.91	50.3388	13566088.0
2019-04-16 10:30:00	AAPL	Stock	50.34	50.34	50.1125	50.1625	6763792.0
2019-04-16 11:00:00	AAPL	Stock	50.1675	50.1825	50.0125	50.0312	5234840.0
2019-04-16 11:30:00	AAPL	Stock	50.03	50.035	49.945	49.98	4125100.0
2019-04-16 12:00:00	AAPL	Stock	49.9775	50.0225	49.95	49.9875	2720468.0
2019-04-16 12:30:00	AAPL	Stock	49.9875	50.0	49.8975	49.99	2921844.0
2019-04-16 13:00:00	AAPL	Stock	49.99	50.01	49.8912	49.8925	2640340.0
2019-04-16 13:30:00	AAPL	Stock	49.8905	49.945	49.8388	49.93	3436676.0
2019-04-16 14:00:00	AAPL	Stock	49.93	49.9625	49.875	49.95	2702732.0
2019-04-16 14:30:00	AAPL	Stock	49.9525	49.9625	49.64	49.94	7473180.0
2019-04-16 15:00:00	AAPL	Stock	49.935	50.1325	49.855	49.945	14599528.0
2019-04-16 15:30:00	AAPL	Stock	49.9425	49.9425	49.693	49.8125	10071184.0
2019-04-16 16:00:00	AAPL	Stock	49.8125	49.8875	49.66	49.8125	4671220.0
2019-04-16 16:30:00	AAPL	Stock	49.765	49.8125	49.6875	49.725	90480.0
2019-04-16 17:00:00	AAPL	Stock	49.7425	49.85	49.7425	49.775	35468.0
2019-04-16 17:30:00	AAPL	Stock	49.7625	49.8	49.76	49.8	20656.0
2019-04-16 18:00:00	AAPL	Stock	49.775	49.8	49.7	49.775	22832.0
2019-04-16 18:30:00	AAPL	Stock	49.75	49.775	49.75	49.77	5168.0
2019-04-16 19:00:00	AAPL	Stock	49.7325	49.775	49.7325	49.7375	7464.0
2019-04-16 19:30:00	AAPL	Stock	49.75	49.7725	49.6775	49.6825	23336.0
2019-04-16 04:00:00	MSFT	Stock	121.58	121.58	121.58	121.58	109.0
2019-04-16 05:00:00	MSFT	Stock	121.5	121.5	121.5	121.5	1600.0
2019-04-16 05:30:00	MSFT	Stock	121.5	121.5	121.5	121.5	402.0
2019-04-16 06:00:00	MSFT	Stock	121.5	121.5	121.5	121.5	632.0
2019-04-16 07:00:00	MSFT	Stock	121.69	121.73	121.65	121.66	7537.0
2019-04-16 07:30:00	MSFT	Stock	121.66	121.8	121.66	121.8	17145.0
2019-04-16 08:00:00	MSFT	Stock	121.73	121.83	121.57	121.79	12969.0
2019-04-16 08:30:00	MSFT	Stock	121.75	121.75	121.56	121.75	8898.0
2019-04-16 09:00:00	MSFT	Stock	121.652	121.75	121.52	121.52	16944.0
2019-04-16 09:30:00	MSFT	Stock	121.64	121.65	120.94	121.26	1977331.0
2019-04-16 10:00:00	MSFT	Stock	121.25	121.54	121.14	121.2	1080641.0
2019-04-16 10:30:00	MSFT	Stock	121.21	121.23	121.015	121.148	754528.0
2019-04-16 11:00:00	MSFT	Stock	121.15	121.315	121.07	121.109	716557.0
2019-04-16 11:30:00	MSFT	Stock	121.1	121.229	121.01	121.12	618345.0
2019-04-16 12:00:00	MSFT	Stock	121.12	121.17	120.97	121.045	654080.0
2019-04-16 12:30:00	MSFT	Stock	121.05	121.2	120.97	121.18	414810.0
2019-04-16 13:00:00	MSFT	Stock	121.175	121.22	121.12	121.13	330959.0
2019-04-16 13:30:00	MSFT	Stock	121.13	121.17	121.04	121.12	377645.0
2019-04-16 14:00:00	MSFT	Stock	121.11	121.16	121.01	121.07	573174.0

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

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