PREVIEW / stock_30min / 2020-05-07

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-07.parquet
  size:    1.9 MB
  rows:    93,115
  symbols: 2,358

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
2020-05-07 04:00:00	AAPL	Stock	75.7875	75.8625	75.7675	75.8625	18684.0
2020-05-07 04:30:00	AAPL	Stock	75.86	76.0	75.86	76.0	6388.0
2020-05-07 05:00:00	AAPL	Stock	76.0	76.0325	76.0	76.02	11400.0
2020-05-07 05:30:00	AAPL	Stock	76.02	76.175	76.02	76.1675	3904.0
2020-05-07 06:00:00	AAPL	Stock	76.1075	76.2	76.05	76.1425	29912.0
2020-05-07 06:30:00	AAPL	Stock	76.125	76.15	75.94	75.94	41500.0
2020-05-07 07:00:00	AAPL	Stock	75.94	75.94	75.6375	75.725	330448.0
2020-05-07 07:30:00	AAPL	Stock	75.75	75.925	75.74	75.8875	111432.0
2020-05-07 08:00:00	AAPL	Stock	75.8875	75.9225	75.645	75.79	185224.0
2020-05-07 08:30:00	AAPL	Stock	75.75	75.925	75.705	75.875	244924.0
2020-05-07 09:00:00	AAPL	Stock	75.8975	75.925	75.7825	75.8	131744.0
2020-05-07 09:30:00	AAPL	Stock	75.8	76.2925	75.79	76.14	16763568.0
2020-05-07 10:00:00	AAPL	Stock	76.1375	76.225	75.8175	75.9925	8745324.0
2020-05-07 10:30:00	AAPL	Stock	75.9875	76.08	75.4925	75.7225	9378048.0
2020-05-07 11:00:00	AAPL	Stock	75.73	75.9025	75.655	75.7887	5619284.0
2020-05-07 11:30:00	AAPL	Stock	75.7925	76.095	75.7575	75.99	5100688.0
2020-05-07 12:00:00	AAPL	Stock	75.9875	76.1	75.93	76.0638	3704024.0
2020-05-07 12:30:00	AAPL	Stock	76.065	76.0875	75.8935	76.0425	4392820.0
2020-05-07 13:00:00	AAPL	Stock	76.045	76.095	75.9525	75.97	3118088.0
2020-05-07 13:30:00	AAPL	Stock	75.9725	76.0625	75.9205	75.9875	3226924.0
2020-05-07 14:00:00	AAPL	Stock	75.985	76.04	75.8	75.885	4105716.0
2020-05-07 14:30:00	AAPL	Stock	75.89	75.9712	75.805	75.9082	4240488.0
2020-05-07 15:00:00	AAPL	Stock	75.905	75.975	75.64	75.8325	7540580.0
2020-05-07 15:30:00	AAPL	Stock	75.8325	75.975	75.74	75.9375	11330120.0
2020-05-07 16:00:00	AAPL	Stock	75.935	76.1	75.885	76.0375	6029480.0
2020-05-07 16:30:00	AAPL	Stock	76.07	76.14	76.06	76.0625	182556.0
2020-05-07 17:00:00	AAPL	Stock	76.075	76.075	75.9525	75.97	37844.0
2020-05-07 17:30:00	AAPL	Stock	75.97	76.025	75.9525	76.0025	33236.0
2020-05-07 18:00:00	AAPL	Stock	76.05	76.15	76.0	76.135	65724.0
2020-05-07 18:30:00	AAPL	Stock	76.0325	76.25	76.0325	76.25	106532.0
2020-05-07 19:00:00	AAPL	Stock	76.25	76.275	76.175	76.175	98984.0
2020-05-07 19:30:00	AAPL	Stock	76.21	76.375	76.0825	76.345	101820.0
2020-05-07 04:00:00	MSFT	Stock	184.41	184.57	184.31	184.57	4639.0
2020-05-07 04:30:00	MSFT	Stock	184.51	185.1	184.51	185.07	3757.0
2020-05-07 05:00:00	MSFT	Stock	184.76	185.15	184.68	185.15	2120.0
2020-05-07 05:30:00	MSFT	Stock	185.22	185.69	185.11	185.69	5240.0
2020-05-07 06:00:00	MSFT	Stock	185.39	185.67	185.06	185.31	6964.0
2020-05-07 06:30:00	MSFT	Stock	185.3	185.38	185.0	185.0	3513.0
2020-05-07 07:00:00	MSFT	Stock	184.6	184.75	184.31	184.49	27304.0
2020-05-07 07:30:00	MSFT	Stock	184.49	184.81	184.35	184.67	30230.0
2020-05-07 08:00:00	MSFT	Stock	184.44	184.706	184.3	184.55	50636.0
2020-05-07 08:30:00	MSFT	Stock	184.55	184.8	184.42	184.7	23624.0
2020-05-07 09:00:00	MSFT	Stock	184.7	184.86	184.2	184.2	34560.0
2020-05-07 09:30:00	MSFT	Stock	184.15	184.55	183.0	184.27	4082485.0
2020-05-07 10:00:00	MSFT	Stock	184.268	184.515	183.43	183.75	2190353.0
2020-05-07 10:30:00	MSFT	Stock	183.755	183.92	182.58	182.95	1864797.0
2020-05-07 11:00:00	MSFT	Stock	182.96	183.48	182.96	183.35	1376384.0
2020-05-07 11:30:00	MSFT	Stock	183.35	184.16	183.1	183.816	1605416.0
2020-05-07 12:00:00	MSFT	Stock	183.84	184.0	183.635	183.83	954695.0
2020-05-07 12:30:00	MSFT	Stock	183.829	183.9	183.46	183.83	952400.0

> showing 50 of 93,115 rows — these rows as CSV

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