PREVIEW / stock_30min / 2019-07-03

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-03.parquet
  size:    1.1 MB
  rows:    50,426
  symbols: 2,521

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-07-03 04:00:00	AAPL	Stock	50.7625	50.925	50.7625	50.925	2480.0
2019-07-03 05:00:00	AAPL	Stock	50.935	50.935	50.935	50.935	800.0
2019-07-03 06:00:00	AAPL	Stock	50.9	50.925	50.8825	50.925	15324.0
2019-07-03 06:30:00	AAPL	Stock	50.93	50.9325	50.89	50.89	6592.0
2019-07-03 07:00:00	AAPL	Stock	50.8725	50.925	50.8725	50.875	23228.0
2019-07-03 07:30:00	AAPL	Stock	50.8725	50.885	50.85	50.87	25888.0
2019-07-03 08:00:00	AAPL	Stock	50.8925	50.925	50.85	50.875	103000.0
2019-07-03 08:30:00	AAPL	Stock	50.8525	50.8725	50.8375	50.8475	39672.0
2019-07-03 09:00:00	AAPL	Stock	50.8225	50.8675	50.79	50.81	73672.0
2019-07-03 09:30:00	AAPL	Stock	50.82	50.875	50.6725	50.83	6751480.0
2019-07-03 10:00:00	AAPL	Stock	50.8225	50.8425	50.7425	50.835	3699176.0
2019-07-03 10:30:00	AAPL	Stock	50.825	50.9558	50.7975	50.92	3624060.0
2019-07-03 11:00:00	AAPL	Stock	50.92	50.94	50.8575	50.895	2849188.0
2019-07-03 11:30:00	AAPL	Stock	50.895	50.9675	50.885	50.9265	2535192.0
2019-07-03 12:00:00	AAPL	Stock	50.9263	51.005	50.9175	50.98	3860876.0
2019-07-03 12:30:00	AAPL	Stock	50.9808	51.11	50.9575	51.1025	7320088.0
2019-07-03 13:00:00	AAPL	Stock	51.1025	51.14	51.0625	51.1125	6768276.0
2019-07-03 13:30:00	AAPL	Stock	51.1128	51.1475	51.1	51.1	75316.0
2019-07-03 14:00:00	AAPL	Stock	51.1	51.106	50.98	51.0588	49508.0
2019-07-03 14:30:00	AAPL	Stock	51.075	51.0812	51.065	51.0762	28152.0
2019-07-03 15:00:00	AAPL	Stock	51.077	51.12	51.065	51.065	10320.0
2019-07-03 15:30:00	AAPL	Stock	51.065	51.0825	51.0575	51.0825	4812.0
2019-07-03 16:00:00	AAPL	Stock	51.0825	51.0825	51.0375	51.0375	10380.0
2019-07-03 16:30:00	AAPL	Stock	51.0625	51.1	51.0475	51.1	9384.0
2019-07-03 04:00:00	MSFT	Stock	136.75	136.75	136.75	136.75	250.0
2019-07-03 05:00:00	MSFT	Stock	137.2	137.2	137.11	137.11	460.0
2019-07-03 06:00:00	MSFT	Stock	137.38	137.38	137.38	137.38	380.0
2019-07-03 06:30:00	MSFT	Stock	137.37	137.38	137.3	137.3	996.0
2019-07-03 07:00:00	MSFT	Stock	137.35	137.48	137.29	137.38	4681.0
2019-07-03 07:30:00	MSFT	Stock	137.37	137.37	137.03	137.05	4184.0
2019-07-03 08:00:00	MSFT	Stock	137.205	137.486	136.99	137.15	20230.0
2019-07-03 08:30:00	MSFT	Stock	137.01	137.02	136.9	137.02	13279.0
2019-07-03 09:00:00	MSFT	Stock	136.99	137.01	136.7	136.77	24545.0
2019-07-03 09:30:00	MSFT	Stock	136.8	137.0	136.295	136.88	2016960.0
2019-07-03 10:00:00	MSFT	Stock	136.87	137.14	136.69	137.114	1168246.0
2019-07-03 10:30:00	MSFT	Stock	137.105	137.57	137.1	137.54	1346009.0
2019-07-03 11:00:00	MSFT	Stock	137.54	137.74	137.05	137.18	1221266.0
2019-07-03 11:30:00	MSFT	Stock	137.17	137.324	137.1	137.273	994771.0
2019-07-03 12:00:00	MSFT	Stock	137.28	137.465	137.125	137.31	860901.0
2019-07-03 12:30:00	MSFT	Stock	137.32	137.6	137.24	137.45	1701559.0
2019-07-03 13:00:00	MSFT	Stock	137.45	137.57	137.206	137.5	2555097.0
2019-07-03 13:30:00	MSFT	Stock	137.48	137.5	137.38	137.46	761.0
2019-07-03 14:00:00	MSFT	Stock	137.38	137.48	137.37	137.48	35806.0
2019-07-03 14:30:00	MSFT	Stock	137.37	137.48	137.37	137.48	1275.0
2019-07-03 15:00:00	MSFT	Stock	137.48	137.48	137.46	137.47	1062.0
2019-07-03 15:30:00	MSFT	Stock	137.46	137.46	137.46	137.46	100.0
2019-07-03 16:00:00	MSFT	Stock	137.46	137.46	137.46	137.46	200.0
2019-07-03 16:30:00	MSFT	Stock	137.46	137.48	137.46	137.48	2193.0
2019-07-03 04:30:00	NVDA	Stock	4.1045	4.105	4.1038	4.1048	28600.0
2019-07-03 05:00:00	NVDA	Stock	4.1	4.1	4.0925	4.0928	36040.0

> showing 50 of 50,426 rows — these rows as CSV

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