PREVIEW / stock_30min / 2020-01-30

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-30.parquet
  size:    1.8 MB
  rows:    87,124
  symbols: 2,448

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-01-30 04:00:00	AAPL	Stock	80.25	80.6025	80.2	80.48	77628.0
2020-01-30 04:30:00	AAPL	Stock	80.5625	80.57	80.2625	80.3525	64164.0
2020-01-30 05:00:00	AAPL	Stock	80.32	80.35	80.195	80.255	32960.0
2020-01-30 05:30:00	AAPL	Stock	80.2575	80.3475	80.25	80.3475	33188.0
2020-01-30 06:00:00	AAPL	Stock	80.255	80.255	80.04	80.15	51300.0
2020-01-30 06:30:00	AAPL	Stock	80.175	80.275	80.125	80.2125	40096.0
2020-01-30 07:00:00	AAPL	Stock	80.25	80.375	80.2	80.2625	233592.0
2020-01-30 07:30:00	AAPL	Stock	80.24	80.25	80.025	80.045	205580.0
2020-01-30 08:00:00	AAPL	Stock	80.2625	80.3625	79.8125	80.05	609980.0
2020-01-30 08:30:00	AAPL	Stock	80.05	80.25	80.0125	80.1925	511088.0
2020-01-30 09:00:00	AAPL	Stock	80.19	80.3675	80.125	80.175	358968.0
2020-01-30 09:30:00	AAPL	Stock	80.136	81.0225	80.0325	80.5925	16142012.0
2020-01-30 10:00:00	AAPL	Stock	80.59	80.9325	80.5152	80.66	7087800.0
2020-01-30 10:30:00	AAPL	Stock	80.66	80.66	79.695	79.74	10629400.0
2020-01-30 11:00:00	AAPL	Stock	79.745	80.4122	79.6875	80.375	8708660.0
2020-01-30 11:30:00	AAPL	Stock	80.385	80.6325	80.2325	80.4835	6153084.0
2020-01-30 12:00:00	AAPL	Stock	80.4838	80.525	80.2075	80.225	3992448.0
2020-01-30 12:30:00	AAPL	Stock	80.21	80.2925	79.97	80.1075	5546240.0
2020-01-30 13:00:00	AAPL	Stock	80.1125	80.1625	79.8275	79.969	4364616.0
2020-01-30 13:30:00	AAPL	Stock	79.9675	80.1138	79.915	80.0	3550044.0
2020-01-30 14:00:00	AAPL	Stock	80.0	80.31	79.94	80.1455	3832028.0
2020-01-30 14:30:00	AAPL	Stock	80.1488	80.47	79.8875	80.23	7464464.0
2020-01-30 15:00:00	AAPL	Stock	80.2575	80.5825	80.1588	80.4463	6530512.0
2020-01-30 15:30:00	AAPL	Stock	80.4475	80.9925	80.39	80.969	10813720.0
2020-01-30 16:00:00	AAPL	Stock	80.9675	81.19	80.415	81.045	6454252.0
2020-01-30 16:30:00	AAPL	Stock	81.0475	81.0875	80.9675	81.0325	174984.0
2020-01-30 17:00:00	AAPL	Stock	81.0275	81.045	81.0	81.0	130024.0
2020-01-30 17:30:00	AAPL	Stock	81.0	81.0	80.89	80.975	58584.0
2020-01-30 18:00:00	AAPL	Stock	80.9525	80.9925	80.8875	80.9	64232.0
2020-01-30 18:30:00	AAPL	Stock	80.8875	80.93	80.75	80.7875	55732.0
2020-01-30 19:00:00	AAPL	Stock	80.8125	80.825	80.7075	80.7075	35228.0
2020-01-30 19:30:00	AAPL	Stock	80.7725	80.9125	80.7625	80.9	72800.0
2020-01-30 04:00:00	MSFT	Stock	174.2	174.32	173.6	174.18	21132.0
2020-01-30 04:30:00	MSFT	Stock	174.1	174.1	173.8	173.8	9964.0
2020-01-30 05:00:00	MSFT	Stock	173.8	173.92	173.6	173.6	8653.0
2020-01-30 05:30:00	MSFT	Stock	173.6	173.85	173.6	173.85	8039.0
2020-01-30 06:00:00	MSFT	Stock	173.5	173.69	173.2	173.36	7616.0
2020-01-30 06:30:00	MSFT	Stock	173.65	174.25	173.65	174.25	15781.0
2020-01-30 07:00:00	MSFT	Stock	174.1	174.33	173.42	173.8	98774.0
2020-01-30 07:30:00	MSFT	Stock	173.75	175.0	173.74	173.95	231409.0
2020-01-30 08:00:00	MSFT	Stock	173.8	174.85	173.55	174.58	226623.0
2020-01-30 08:30:00	MSFT	Stock	174.6	175.05	174.15	174.35	176668.0
2020-01-30 09:00:00	MSFT	Stock	174.35	174.89	173.75	174.02	309573.0
2020-01-30 09:30:00	MSFT	Stock	174.02	174.05	172.41	172.44	11100417.0
2020-01-30 10:00:00	MSFT	Stock	172.44	172.79	171.33	172.05	4590568.0
2020-01-30 10:30:00	MSFT	Stock	172.07	172.47	171.57	171.69	3223521.0
2020-01-30 11:00:00	MSFT	Stock	171.7	172.08	171.59	171.8	2118370.0
2020-01-30 11:30:00	MSFT	Stock	171.8	172.39	171.66	171.78	2056916.0
2020-01-30 12:00:00	MSFT	Stock	171.789	172.185	171.41	171.51	1613516.0
2020-01-30 12:30:00	MSFT	Stock	171.5	171.71	170.79	171.378	2296006.0

> showing 50 of 87,124 rows — these rows as CSV

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