PREVIEW / stock_30min / 2019-01-04

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-04.parquet
  size:    1.7 MB
  rows:    84,993
  symbols: 2,704

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-04 04:00:00	AAPL	Stock	35.95	36.0025	35.9125	36.0025	51528.0
2019-01-04 04:30:00	AAPL	Stock	36.0375	36.1625	35.95	35.9575	121580.0
2019-01-04 05:00:00	AAPL	Stock	35.98	36.125	35.9625	36.125	62368.0
2019-01-04 05:30:00	AAPL	Stock	36.1225	36.2375	36.0725	36.2025	76520.0
2019-01-04 06:00:00	AAPL	Stock	36.2025	36.2375	36.175	36.175	62640.0
2019-01-04 06:30:00	AAPL	Stock	36.1875	36.1975	36.0375	36.0825	149164.0
2019-01-04 07:00:00	AAPL	Stock	36.0525	36.115	35.965	36.0475	348228.0
2019-01-04 07:30:00	AAPL	Stock	36.0475	36.0875	35.99	36.0375	163700.0
2019-01-04 08:00:00	AAPL	Stock	35.9775	36.1125	35.9775	36.0725	519032.0
2019-01-04 08:30:00	AAPL	Stock	36.075	36.12	35.9375	35.9775	1028440.0
2019-01-04 09:00:00	AAPL	Stock	35.9775	36.145	35.9	36.145	895812.0
2019-01-04 09:30:00	AAPL	Stock	36.145	36.3525	35.95	36.3475	34520076.0
2019-01-04 10:00:00	AAPL	Stock	36.345	36.7875	36.295	36.71	27670620.0
2019-01-04 10:30:00	AAPL	Stock	36.7042	36.81	36.625	36.7975	16579552.0
2019-01-04 11:00:00	AAPL	Stock	36.7975	36.925	36.7425	36.9138	14047572.0
2019-01-04 11:30:00	AAPL	Stock	36.9125	36.9925	36.75	36.775	11510920.0
2019-01-04 12:00:00	AAPL	Stock	36.775	36.8875	36.7125	36.8375	9563096.0
2019-01-04 12:30:00	AAPL	Stock	36.835	36.965	36.8275	36.88	7058712.0
2019-01-04 13:00:00	AAPL	Stock	36.8825	37.115	36.8675	37.1125	10193720.0
2019-01-04 13:30:00	AAPL	Stock	37.1125	37.1375	36.9125	36.9638	9834432.0
2019-01-04 14:00:00	AAPL	Stock	36.965	37.075	36.895	37.037	7275644.0
2019-01-04 14:30:00	AAPL	Stock	37.037	37.0875	36.7875	36.7915	8366324.0
2019-01-04 15:00:00	AAPL	Stock	36.79	36.965	36.77	36.7912	9646320.0
2019-01-04 15:30:00	AAPL	Stock	36.79	37.0725	36.775	37.065	18040400.0
2019-01-04 16:00:00	AAPL	Stock	37.065	37.0848	36.772	37.015	15153548.0
2019-01-04 16:30:00	AAPL	Stock	37.0325	37.065	37.0025	37.0025	408036.0
2019-01-04 17:00:00	AAPL	Stock	37.0	37.0225	37.0	37.0225	72156.0
2019-01-04 17:30:00	AAPL	Stock	37.02	37.02	37.005	37.0075	66184.0
2019-01-04 18:00:00	AAPL	Stock	37.0075	37.02	37.005	37.015	41316.0
2019-01-04 18:30:00	AAPL	Stock	37.015	37.05	37.01	37.045	18648.0
2019-01-04 19:00:00	AAPL	Stock	37.0375	37.055	37.0225	37.0375	30680.0
2019-01-04 19:30:00	AAPL	Stock	37.0575	37.1	37.03	37.1	86492.0
2019-01-04 04:00:00	MSFT	Stock	98.23	98.5	98.05	98.5	2010.0
2019-01-04 04:30:00	MSFT	Stock	99.12	99.2	99.0	99.0	320.0
2019-01-04 05:00:00	MSFT	Stock	99.15	99.15	99.15	99.15	100.0
2019-01-04 05:30:00	MSFT	Stock	98.9	99.29	98.9	99.14	2829.0
2019-01-04 06:00:00	MSFT	Stock	99.15	99.49	99.15	99.49	2512.0
2019-01-04 06:30:00	MSFT	Stock	99.38	99.39	99.09	99.2	8570.0
2019-01-04 07:00:00	MSFT	Stock	99.2	99.25	98.81	99.02	41438.0
2019-01-04 07:30:00	MSFT	Stock	99.01	99.1	98.71	98.83	16552.0
2019-01-04 08:00:00	MSFT	Stock	98.9	99.25	98.78	98.85	41630.0
2019-01-04 08:30:00	MSFT	Stock	98.85	99.14	98.6	98.95	66489.0
2019-01-04 09:00:00	MSFT	Stock	98.9	99.68	98.8	99.65	80666.0
2019-01-04 09:30:00	MSFT	Stock	99.69	100.44	98.93	100.355	4498932.0
2019-01-04 10:00:00	MSFT	Stock	100.36	101.33	99.58	101.33	3271541.0
2019-01-04 10:30:00	MSFT	Stock	101.325	101.96	101.14	101.69	3762097.0
2019-01-04 11:00:00	MSFT	Stock	101.68	102.08	101.45	101.55	3266816.0
2019-01-04 11:30:00	MSFT	Stock	101.55	101.91	101.271	101.72	2362795.0
2019-01-04 12:00:00	MSFT	Stock	101.7	102.05	101.37	101.88	1691931.0
2019-01-04 12:30:00	MSFT	Stock	101.87	102.37	101.755	102.143	1831728.0

> showing 50 of 84,993 rows — these rows as CSV

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