PREVIEW / stock_30min / 2019-01-29

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-29.parquet
  size:    1.7 MB
  rows:    82,793
  symbols: 2,696

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-01-29 04:00:00	AAPL	Stock	38.9125	39.05	38.9125	39.05	4244.0
2019-01-29 04:30:00	AAPL	Stock	39.055	39.055	39.0525	39.055	2652.0
2019-01-29 05:00:00	AAPL	Stock	39.1	39.125	39.1	39.1	1728.0
2019-01-29 05:30:00	AAPL	Stock	39.12	39.125	39.0875	39.125	6100.0
2019-01-29 06:00:00	AAPL	Stock	39.055	39.055	39.0275	39.0275	800.0
2019-01-29 06:30:00	AAPL	Stock	39.0275	39.075	39.0275	39.075	14692.0
2019-01-29 07:00:00	AAPL	Stock	39.04	39.0875	39.0225	39.035	47660.0
2019-01-29 07:30:00	AAPL	Stock	39.0325	39.1625	39.0325	39.12	75808.0
2019-01-29 08:00:00	AAPL	Stock	39.1	39.1725	39.025	39.15	228556.0
2019-01-29 08:30:00	AAPL	Stock	39.16	39.175	39.1125	39.1275	130956.0
2019-01-29 09:00:00	AAPL	Stock	39.125	39.16	39.055	39.055	186408.0
2019-01-29 09:30:00	AAPL	Stock	39.0625	39.5325	38.975	39.3312	15547772.0
2019-01-29 10:00:00	AAPL	Stock	39.3325	39.495	39.1325	39.262	10857324.0
2019-01-29 10:30:00	AAPL	Stock	39.2625	39.275	38.88	38.94	8266056.0
2019-01-29 11:00:00	AAPL	Stock	38.9375	38.96	38.8112	38.9315	6635464.0
2019-01-29 11:30:00	AAPL	Stock	38.935	39.125	38.885	39.1025	6869724.0
2019-01-29 12:00:00	AAPL	Stock	39.1	39.2475	38.9975	39.1425	4940728.0
2019-01-29 12:30:00	AAPL	Stock	39.1452	39.25	39.1025	39.1862	4247268.0
2019-01-29 13:00:00	AAPL	Stock	39.185	39.1875	38.9938	39.0288	5012376.0
2019-01-29 13:30:00	AAPL	Stock	39.03	39.0975	38.9875	39.0288	4807032.0
2019-01-29 14:00:00	AAPL	Stock	39.0295	39.045	38.7625	38.7755	7073160.0
2019-01-29 14:30:00	AAPL	Stock	38.775	38.8525	38.655	38.6775	7871556.0
2019-01-29 15:00:00	AAPL	Stock	38.6825	38.7175	38.5525	38.58	11417316.0
2019-01-29 15:30:00	AAPL	Stock	38.5825	38.7075	38.5275	38.6595	19177116.0
2019-01-29 16:00:00	AAPL	Stock	38.67	39.125	38.6275	38.9475	5832380.0
2019-01-29 16:30:00	AAPL	Stock	38.9425	40.4225	37.75	40.1575	15247256.0
2019-01-29 17:00:00	AAPL	Stock	40.1525	41.2125	40.0025	41.07	7492780.0
2019-01-29 17:30:00	AAPL	Stock	41.0375	41.165	40.64	40.785	2979220.0
2019-01-29 18:00:00	AAPL	Stock	40.82	40.92	40.75	40.825	748888.0
2019-01-29 18:30:00	AAPL	Stock	40.8275	40.9925	40.825	40.9	685036.0
2019-01-29 19:00:00	AAPL	Stock	40.8975	40.8975	40.75	40.755	549700.0
2019-01-29 19:30:00	AAPL	Stock	40.755	40.885	40.7325	40.875	404476.0
2019-01-29 04:00:00	MSFT	Stock	104.85	105.05	104.85	105.05	600.0
2019-01-29 04:30:00	MSFT	Stock	105.23	105.23	105.0	105.0	1170.0
2019-01-29 05:00:00	MSFT	Stock	105.0	105.05	104.99	105.05	4678.0
2019-01-29 05:30:00	MSFT	Stock	104.96	104.96	104.91	104.91	423.0
2019-01-29 06:00:00	MSFT	Stock	104.83	104.83	104.75	104.8	4153.0
2019-01-29 06:30:00	MSFT	Stock	104.86	104.9	104.86	104.9	1278.0
2019-01-29 07:00:00	MSFT	Stock	104.95	105.05	104.84	104.99	1566.0
2019-01-29 07:30:00	MSFT	Stock	105.02	105.2	105.0	105.0	15174.0
2019-01-29 08:00:00	MSFT	Stock	104.854	105.34	104.81	105.0	52973.0
2019-01-29 08:30:00	MSFT	Stock	105.02	105.24	105.0	105.15	29943.0
2019-01-29 09:00:00	MSFT	Stock	105.22	105.25	104.88	104.88	27512.0
2019-01-29 09:30:00	MSFT	Stock	104.83	104.97	103.84	103.935	3077122.0
2019-01-29 10:00:00	MSFT	Stock	103.93	104.19	103.73	103.88	2443445.0
2019-01-29 10:30:00	MSFT	Stock	103.89	103.99	102.52	102.617	3046230.0
2019-01-29 11:00:00	MSFT	Stock	102.62	102.975	102.51	102.6	1956155.0
2019-01-29 11:30:00	MSFT	Stock	102.6	102.705	102.28	102.29	1918398.0
2019-01-29 12:00:00	MSFT	Stock	102.28	102.68	102.17	102.593	1867697.0
2019-01-29 12:30:00	MSFT	Stock	102.6	102.86	102.52	102.764	1209924.0

> showing 50 of 82,793 rows — these rows as CSV

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