PREVIEW / stock_30min / 2019-12-20

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-20.parquet
  size:    1.8 MB
  rows:    86,923
  symbols: 2,494

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-12-20 04:00:00	AAPL	Stock	70.025	70.025	70.025	70.025	2000.0
2019-12-20 04:30:00	AAPL	Stock	70.005	70.005	70.0	70.0	1008.0
2019-12-20 05:30:00	AAPL	Stock	70.0825	70.12	70.0825	70.12	3008.0
2019-12-20 06:00:00	AAPL	Stock	70.115	70.1675	70.085	70.0875	6644.0
2019-12-20 06:30:00	AAPL	Stock	70.1125	70.1125	70.075	70.075	6000.0
2019-12-20 07:00:00	AAPL	Stock	70.075	70.085	70.0325	70.0625	31008.0
2019-12-20 07:30:00	AAPL	Stock	70.06	70.25	70.055	70.2475	80592.0
2019-12-20 08:00:00	AAPL	Stock	70.07	70.2925	70.04	70.2575	171008.0
2019-12-20 08:30:00	AAPL	Stock	70.25	70.3	70.2375	70.2525	173256.0
2019-12-20 09:00:00	AAPL	Stock	70.2625	70.885	70.2	70.5525	1991700.0
2019-12-20 09:30:00	AAPL	Stock	70.5575	70.6625	70.215	70.2475	37316448.0
2019-12-20 10:00:00	AAPL	Stock	70.2488	70.4575	70.1625	70.2825	6532704.0
2019-12-20 10:30:00	AAPL	Stock	70.279	70.3725	70.1975	70.3475	3822408.0
2019-12-20 11:00:00	AAPL	Stock	70.3475	70.4825	70.29	70.3175	5988868.0
2019-12-20 11:30:00	AAPL	Stock	70.3225	70.3975	70.21	70.26	5158164.0
2019-12-20 12:00:00	AAPL	Stock	70.2575	70.2925	70.195	70.2285	3292140.0
2019-12-20 12:30:00	AAPL	Stock	70.2292	70.285	70.17	70.2212	3734808.0
2019-12-20 13:00:00	AAPL	Stock	70.2212	70.2725	70.205	70.215	2096860.0
2019-12-20 13:30:00	AAPL	Stock	70.2162	70.25	70.1862	70.1875	2109608.0
2019-12-20 14:00:00	AAPL	Stock	70.1875	70.1922	70.11	70.145	3156192.0
2019-12-20 14:30:00	AAPL	Stock	70.1462	70.19	70.0375	70.1175	4447132.0
2019-12-20 15:00:00	AAPL	Stock	70.1138	70.1225	69.9662	69.9662	5175720.0
2019-12-20 15:30:00	AAPL	Stock	69.9675	69.9925	69.64	69.82	15708804.0
2019-12-20 16:00:00	AAPL	Stock	69.86	69.905	69.7625	69.86	81156836.0
2019-12-20 16:30:00	AAPL	Stock	69.8725	69.8875	69.75	69.8525	88488.0
2019-12-20 17:00:00	AAPL	Stock	69.83	69.8535	69.755	69.795	50908.0
2019-12-20 17:30:00	AAPL	Stock	69.78	69.85	69.78	69.825	47376.0
2019-12-20 18:00:00	AAPL	Stock	69.85	69.88	69.8475	69.85	21036.0
2019-12-20 18:30:00	AAPL	Stock	69.85	69.8725	69.775	69.8025	49832.0
2019-12-20 19:00:00	AAPL	Stock	69.8275	69.85	69.8125	69.8425	20312.0
2019-12-20 19:30:00	AAPL	Stock	69.8425	69.875	69.8275	69.875	41368.0
2019-12-20 04:00:00	MSFT	Stock	155.8	155.8	155.5	155.5	300.0
2019-12-20 05:30:00	MSFT	Stock	155.7	155.7	155.67	155.67	500.0
2019-12-20 06:00:00	MSFT	Stock	155.67	155.8	155.67	155.7	3223.0
2019-12-20 06:30:00	MSFT	Stock	155.75	155.85	155.75	155.8	1169.0
2019-12-20 07:00:00	MSFT	Stock	155.8	155.8	155.8	155.8	1600.0
2019-12-20 07:30:00	MSFT	Stock	155.88	155.91	155.88	155.91	1374.0
2019-12-20 08:00:00	MSFT	Stock	155.87	156.0	155.75	155.92	35499.0
2019-12-20 08:30:00	MSFT	Stock	155.95	156.2	155.92	156.03	15441.0
2019-12-20 09:00:00	MSFT	Stock	156.1	158.0	156.0	157.3	624503.0
2019-12-20 09:30:00	MSFT	Stock	157.33	158.49	156.29	156.43	13434040.0
2019-12-20 10:00:00	MSFT	Stock	156.43	157.13	156.41	157.01	1385776.0
2019-12-20 10:30:00	MSFT	Stock	157.01	157.09	156.7	156.78	937901.0
2019-12-20 11:00:00	MSFT	Stock	156.78	157.14	156.69	156.883	905815.0
2019-12-20 11:30:00	MSFT	Stock	156.89	157.24	156.885	157.08	953325.0
2019-12-20 12:00:00	MSFT	Stock	157.07	157.19	156.99	157.149	676359.0
2019-12-20 12:30:00	MSFT	Stock	157.147	157.47	157.035	157.175	861940.0
2019-12-20 13:00:00	MSFT	Stock	157.17	157.21	156.963	157.035	677869.0
2019-12-20 13:30:00	MSFT	Stock	157.04	157.2	157.04	157.142	543464.0
2019-12-20 14:00:00	MSFT	Stock	157.145	157.15	156.99	157.15	575109.0

> showing 50 of 86,923 rows — these rows as CSV

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