PREVIEW / stock_30min / 2019-06-17

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-17.parquet
  size:    1.7 MB
  rows:    83,414
  symbols: 2,574

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-17 04:00:00	AAPL	Stock	48.375	48.375	48.16	48.2925	2600.0
2019-06-17 04:30:00	AAPL	Stock	48.29	48.29	48.2625	48.2625	800.0
2019-06-17 05:00:00	AAPL	Stock	48.2925	48.2925	48.25	48.25	2400.0
2019-06-17 05:30:00	AAPL	Stock	48.25	48.25	48.25	48.25	2600.0
2019-06-17 06:00:00	AAPL	Stock	48.2	48.2475	48.1875	48.2475	2300.0
2019-06-17 06:30:00	AAPL	Stock	48.175	48.25	48.175	48.225	22876.0
2019-06-17 07:00:00	AAPL	Stock	48.225	48.345	48.225	48.3375	36072.0
2019-06-17 07:30:00	AAPL	Stock	48.325	48.38	48.3	48.38	41828.0
2019-06-17 08:00:00	AAPL	Stock	48.3125	48.37	48.25	48.3575	42740.0
2019-06-17 08:30:00	AAPL	Stock	48.315	48.36	48.225	48.25	67840.0
2019-06-17 09:00:00	AAPL	Stock	48.25	48.3475	48.194	48.195	88560.0
2019-06-17 09:30:00	AAPL	Stock	48.225	48.7125	48.0425	48.66	9697464.0
2019-06-17 10:00:00	AAPL	Stock	48.67	48.6975	48.5375	48.63	4315148.0
2019-06-17 10:30:00	AAPL	Stock	48.6375	48.74	48.6125	48.6625	3407784.0
2019-06-17 11:00:00	AAPL	Stock	48.6575	48.6725	48.51	48.53	3167052.0
2019-06-17 11:30:00	AAPL	Stock	48.53	48.625	48.5112	48.5375	2652516.0
2019-06-17 12:00:00	AAPL	Stock	48.5325	48.5725	48.4775	48.519	2133428.0
2019-06-17 12:30:00	AAPL	Stock	48.515	48.5875	48.5	48.5538	1652740.0
2019-06-17 13:00:00	AAPL	Stock	48.5525	48.5925	48.535	48.5538	1461468.0
2019-06-17 13:30:00	AAPL	Stock	48.555	48.66	48.5475	48.6488	2049568.0
2019-06-17 14:00:00	AAPL	Stock	48.65	48.6925	48.5575	48.5712	1968280.0
2019-06-17 14:30:00	AAPL	Stock	48.5712	48.62	48.5425	48.5575	1644260.0
2019-06-17 15:00:00	AAPL	Stock	48.5575	48.6225	48.5	48.5988	2188012.0
2019-06-17 15:30:00	AAPL	Stock	48.6	48.6	48.39	48.4875	7123188.0
2019-06-17 16:00:00	AAPL	Stock	48.4875	48.4925	48.4675	48.4725	4712176.0
2019-06-17 16:30:00	AAPL	Stock	48.4775	48.4975	48.465	48.4975	102300.0
2019-06-17 17:00:00	AAPL	Stock	48.497	48.5	48.475	48.4875	29852.0
2019-06-17 17:30:00	AAPL	Stock	48.4975	48.5125	48.4875	48.5	11456.0
2019-06-17 18:00:00	AAPL	Stock	48.5125	48.535	48.5	48.5075	8200.0
2019-06-17 18:30:00	AAPL	Stock	48.525	48.57	48.5	48.57	12316.0
2019-06-17 19:00:00	AAPL	Stock	48.55	48.55	48.54	48.54	1236.0
2019-06-17 19:30:00	AAPL	Stock	48.5625	48.5625	48.5225	48.5225	6800.0
2019-06-17 04:30:00	MSFT	Stock	132.8	132.8	132.8	132.8	820.0
2019-06-17 05:30:00	MSFT	Stock	132.94	132.94	132.85	132.85	200.0
2019-06-17 06:00:00	MSFT	Stock	132.91	132.97	132.77	132.8	1750.0
2019-06-17 06:30:00	MSFT	Stock	132.9	132.95	132.65	132.65	2000.0
2019-06-17 07:00:00	MSFT	Stock	132.65	132.78	132.65	132.78	2970.0
2019-06-17 07:30:00	MSFT	Stock	132.8	132.9	132.8	132.9	4633.0
2019-06-17 08:00:00	MSFT	Stock	132.79	132.95	132.56	132.83	9328.0
2019-06-17 08:30:00	MSFT	Stock	132.78	132.78	132.6	132.6	8180.0
2019-06-17 09:00:00	MSFT	Stock	132.6	132.74	132.5	132.59	6224.0
2019-06-17 09:30:00	MSFT	Stock	132.6	133.73	132.53	133.5	1679436.0
2019-06-17 10:00:00	MSFT	Stock	133.5	133.62	132.87	133.12	1140326.0
2019-06-17 10:30:00	MSFT	Stock	133.12	133.33	132.835	133.04	748020.0
2019-06-17 11:00:00	MSFT	Stock	133.04	133.19	132.82	132.9	583208.0
2019-06-17 11:30:00	MSFT	Stock	132.91	132.98	132.72	132.76	538673.0
2019-06-17 12:00:00	MSFT	Stock	132.75	132.92	132.65	132.815	413263.0
2019-06-17 12:30:00	MSFT	Stock	132.81	133.1	132.72	133.08	494833.0
2019-06-17 13:00:00	MSFT	Stock	133.08	133.23	133.03	133.12	458393.0
2019-06-17 13:30:00	MSFT	Stock	133.111	133.31	133.09	133.25	381677.0

> showing 50 of 83,414 rows — these rows as CSV

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