PREVIEW / stock_30min / 2019-03-19

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-19.parquet
  size:    1.7 MB
  rows:    85,063
  symbols: 2,641

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-03-19 04:00:00	AAPL	Stock	47.0375	47.085	47.0375	47.085	4928.0
2019-03-19 05:00:00	AAPL	Stock	47.2175	47.2175	47.2175	47.2175	3768.0
2019-03-19 05:30:00	AAPL	Stock	47.2175	47.24	47.2175	47.24	7604.0
2019-03-19 06:00:00	AAPL	Stock	47.24	47.25	47.2	47.225	44904.0
2019-03-19 06:30:00	AAPL	Stock	47.25	47.25	47.2	47.2	19504.0
2019-03-19 07:00:00	AAPL	Stock	47.205	47.25	47.1525	47.25	53292.0
2019-03-19 07:30:00	AAPL	Stock	47.25	47.315	47.2075	47.23	103132.0
2019-03-19 08:00:00	AAPL	Stock	47.1625	47.3125	47.1625	47.225	213860.0
2019-03-19 08:30:00	AAPL	Stock	47.2175	47.25	47.195	47.2225	149356.0
2019-03-19 09:00:00	AAPL	Stock	47.23	47.2475	47.075	47.075	563392.0
2019-03-19 09:30:00	AAPL	Stock	47.06	47.2475	47.0	47.0375	16599808.0
2019-03-19 10:00:00	AAPL	Stock	47.04	47.1125	46.8525	46.8638	11860484.0
2019-03-19 10:30:00	AAPL	Stock	46.866	46.9225	46.78	46.7975	7973256.0
2019-03-19 11:00:00	AAPL	Stock	46.7975	46.9475	46.7075	46.8815	8184144.0
2019-03-19 11:30:00	AAPL	Stock	46.8825	47.01	46.835	47.005	5435572.0
2019-03-19 12:00:00	AAPL	Stock	47.0075	47.0975	46.99	47.003	5100936.0
2019-03-19 12:30:00	AAPL	Stock	47.005	47.025	46.7325	46.9225	7554764.0
2019-03-19 13:00:00	AAPL	Stock	46.9275	46.9462	46.82	46.8325	3870388.0
2019-03-19 13:30:00	AAPL	Stock	46.8275	46.845	46.71	46.7675	4568676.0
2019-03-19 14:00:00	AAPL	Stock	46.765	46.82	46.71	46.785	3857728.0
2019-03-19 14:30:00	AAPL	Stock	46.79	46.8792	46.7725	46.825	3985396.0
2019-03-19 15:00:00	AAPL	Stock	46.8275	46.8325	46.6025	46.64	5475280.0
2019-03-19 15:30:00	AAPL	Stock	46.64	46.6925	46.48	46.635	14007128.0
2019-03-19 16:00:00	AAPL	Stock	46.6325	46.6875	46.55	46.55	15085908.0
2019-03-19 16:30:00	AAPL	Stock	46.525	46.6325	46.515	46.555	99972.0
2019-03-19 17:00:00	AAPL	Stock	46.5625	46.575	46.545	46.555	19024.0
2019-03-19 17:30:00	AAPL	Stock	46.5375	46.5375	46.5175	46.52	29904.0
2019-03-19 18:00:00	AAPL	Stock	46.5375	46.5375	46.52	46.53	48452.0
2019-03-19 18:30:00	AAPL	Stock	46.52	46.5625	46.51	46.51	24460.0
2019-03-19 19:00:00	AAPL	Stock	46.5025	46.5325	46.5025	46.5125	5608.0
2019-03-19 19:30:00	AAPL	Stock	46.5125	46.5625	46.4875	46.5	33340.0
2019-03-19 05:00:00	MSFT	Stock	118.15	118.15	118.15	118.15	600.0
2019-03-19 05:30:00	MSFT	Stock	118.1	118.1	118.1	118.1	100.0
2019-03-19 06:00:00	MSFT	Stock	117.91	117.91	117.91	117.91	100.0
2019-03-19 06:30:00	MSFT	Stock	118.1	118.1	118.09	118.09	800.0
2019-03-19 07:00:00	MSFT	Stock	118.11	118.19	118.11	118.16	5685.0
2019-03-19 07:30:00	MSFT	Stock	118.13	118.17	117.97	117.97	10704.0
2019-03-19 08:00:00	MSFT	Stock	118.08	118.2	117.94	118.07	17778.0
2019-03-19 08:30:00	MSFT	Stock	118.08	118.12	118.0	118.06	9966.0
2019-03-19 09:00:00	MSFT	Stock	118.09	118.15	118.0	118.0	12215.0
2019-03-19 09:30:00	MSFT	Stock	118.03	118.44	117.62	117.62	3152494.0
2019-03-19 10:00:00	MSFT	Stock	117.64	118.005	117.44	117.589	2154870.0
2019-03-19 10:30:00	MSFT	Stock	117.58	117.7	117.28	117.32	1822979.0
2019-03-19 11:00:00	MSFT	Stock	117.32	117.79	117.273	117.71	1804058.0
2019-03-19 11:30:00	MSFT	Stock	117.72	117.845	117.6	117.79	1948128.0
2019-03-19 12:00:00	MSFT	Stock	117.8	118.05	117.55	117.57	1557372.0
2019-03-19 12:30:00	MSFT	Stock	117.57	117.77	117.08	117.76	1856367.0
2019-03-19 13:00:00	MSFT	Stock	117.76	117.895	117.59	117.84	891779.0
2019-03-19 13:30:00	MSFT	Stock	117.84	118.005	117.67	117.766	1008243.0
2019-03-19 14:00:00	MSFT	Stock	117.77	117.83	117.52	117.77	944331.0

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

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