PREVIEW / stock_30min / 2019-06-10

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-10.parquet
  size:    1.7 MB
  rows:    84,338
  symbols: 2,601

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-06-10 04:00:00	AAPL	Stock	47.8025	47.8025	47.7975	47.7975	1800.0
2019-06-10 04:30:00	AAPL	Stock	47.8625	47.8625	47.8625	47.8625	1584.0
2019-06-10 05:00:00	AAPL	Stock	47.8475	47.8475	47.7625	47.7625	4760.0
2019-06-10 05:30:00	AAPL	Stock	47.7625	47.7625	47.65	47.65	19640.0
2019-06-10 06:00:00	AAPL	Stock	47.635	47.655	47.6	47.625	11732.0
2019-06-10 06:30:00	AAPL	Stock	47.665	47.7625	47.665	47.75	33456.0
2019-06-10 07:00:00	AAPL	Stock	47.75	48.1	47.75	48.1	149320.0
2019-06-10 07:30:00	AAPL	Stock	48.125	48.4375	48.0375	48.3125	169628.0
2019-06-10 08:00:00	AAPL	Stock	47.8	48.3375	47.8	48.19	297764.0
2019-06-10 08:30:00	AAPL	Stock	48.21	48.3075	48.13	48.1875	344416.0
2019-06-10 09:00:00	AAPL	Stock	48.1875	48.2345	47.9475	48.0625	250700.0
2019-06-10 09:30:00	AAPL	Stock	48.0825	48.29	47.9025	48.1825	16314712.0
2019-06-10 10:00:00	AAPL	Stock	48.1825	48.5075	48.14	48.4575	9076544.0
2019-06-10 10:30:00	AAPL	Stock	48.4545	48.5075	48.255	48.3608	6604228.0
2019-06-10 11:00:00	AAPL	Stock	48.3575	48.595	48.3375	48.5575	6672800.0
2019-06-10 11:30:00	AAPL	Stock	48.5575	48.8425	48.5575	48.7825	7236532.0
2019-06-10 12:00:00	AAPL	Stock	48.78	48.8258	48.5325	48.5725	6120436.0
2019-06-10 12:30:00	AAPL	Stock	48.5725	48.5925	48.3775	48.405	4563636.0
2019-06-10 13:00:00	AAPL	Stock	48.405	48.5375	48.32	48.325	3256360.0
2019-06-10 13:30:00	AAPL	Stock	48.3235	48.375	48.175	48.225	3549716.0
2019-06-10 14:00:00	AAPL	Stock	48.22	48.2325	48.01	48.175	4819672.0
2019-06-10 14:30:00	AAPL	Stock	48.1775	48.325	48.1475	48.321	3888560.0
2019-06-10 15:00:00	AAPL	Stock	48.325	48.36	48.2175	48.2433	4366952.0
2019-06-10 15:30:00	AAPL	Stock	48.245	48.4125	48.115	48.13	8261492.0
2019-06-10 16:00:00	AAPL	Stock	48.145	48.4102	48.1325	48.2	6710912.0
2019-06-10 16:30:00	AAPL	Stock	48.1875	48.2175	48.145	48.1875	175792.0
2019-06-10 17:00:00	AAPL	Stock	48.2125	48.225	48.1725	48.225	18084.0
2019-06-10 17:30:00	AAPL	Stock	48.22	48.2225	48.1875	48.22	4932.0
2019-06-10 18:00:00	AAPL	Stock	48.2	48.2	48.175	48.2	18840.0
2019-06-10 18:30:00	AAPL	Stock	48.2	48.2325	48.1875	48.2325	13508.0
2019-06-10 19:00:00	AAPL	Stock	48.2075	48.215	48.1875	48.1875	7288.0
2019-06-10 19:30:00	AAPL	Stock	48.245	48.245	48.185	48.19	20328.0
2019-06-10 04:00:00	MSFT	Stock	132.09	132.25	132.05	132.15	1269.0
2019-06-10 04:30:00	MSFT	Stock	132.15	132.15	132.15	132.15	224.0
2019-06-10 05:00:00	MSFT	Stock	132.2	132.98	132.2	132.98	867.0
2019-06-10 05:30:00	MSFT	Stock	132.77	132.89	132.69	132.8	6000.0
2019-06-10 06:00:00	MSFT	Stock	132.67	132.67	132.67	132.67	1000.0
2019-06-10 06:30:00	MSFT	Stock	132.4	132.49	132.39	132.49	3625.0
2019-06-10 07:00:00	MSFT	Stock	132.25	132.88	132.0	132.85	29476.0
2019-06-10 07:30:00	MSFT	Stock	132.9	133.43	132.78	133.07	20397.0
2019-06-10 08:00:00	MSFT	Stock	132.25	133.23	132.2	132.9	48324.0
2019-06-10 08:30:00	MSFT	Stock	132.95	133.09	132.7	132.8	28077.0
2019-06-10 09:00:00	MSFT	Stock	132.82	133.06	131.94	131.94	64683.0
2019-06-10 09:30:00	MSFT	Stock	132.59	132.82	132.0	132.75	3666098.0
2019-06-10 10:00:00	MSFT	Stock	132.748	133.64	132.55	133.57	2506448.0
2019-06-10 10:30:00	MSFT	Stock	133.563	133.86	133.36	133.43	1667529.0
2019-06-10 11:00:00	MSFT	Stock	133.43	133.72	133.37	133.63	1203209.0
2019-06-10 11:30:00	MSFT	Stock	133.63	134.08	133.63	133.85	1268000.0
2019-06-10 12:00:00	MSFT	Stock	133.848	133.88	133.27	133.385	1294342.0
2019-06-10 12:30:00	MSFT	Stock	133.387	133.422	133.08	133.305	1074826.0

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

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