PREVIEW / stock_30min / 2019-01-07

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-07.parquet
  size:    1.7 MB
  rows:    85,210
  symbols: 2,698

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-07 04:00:00	AAPL	Stock	37.1625	37.225	37.095	37.095	30772.0
2019-01-07 04:30:00	AAPL	Stock	37.115	37.115	37.0375	37.0375	9868.0
2019-01-07 05:00:00	AAPL	Stock	37.05	37.1475	37.05	37.1475	28600.0
2019-01-07 05:30:00	AAPL	Stock	37.12	37.135	37.0	37.125	40564.0
2019-01-07 06:00:00	AAPL	Stock	37.125	37.125	36.9975	37.05	15580.0
2019-01-07 06:30:00	AAPL	Stock	37.0625	37.07	37.0075	37.0575	15788.0
2019-01-07 07:00:00	AAPL	Stock	37.0525	37.1725	37.0475	37.0625	61124.0
2019-01-07 07:30:00	AAPL	Stock	37.0875	37.115	37.0025	37.1	165640.0
2019-01-07 08:00:00	AAPL	Stock	37.1882	37.1882	37.0	37.0125	267544.0
2019-01-07 08:30:00	AAPL	Stock	37.0375	37.0375	36.925	37.0	278720.0
2019-01-07 09:00:00	AAPL	Stock	37.025	37.21	36.9875	37.1625	258496.0
2019-01-07 09:30:00	AAPL	Stock	37.16	37.205	36.6075	36.825	25819544.0
2019-01-07 10:00:00	AAPL	Stock	36.815	37.0775	36.675	36.9925	14850032.0
2019-01-07 10:30:00	AAPL	Stock	36.9925	37.2075	36.9575	37.0075	13815088.0
2019-01-07 11:00:00	AAPL	Stock	37.0075	37.0075	36.475	36.57	23480776.0
2019-01-07 11:30:00	AAPL	Stock	36.5725	36.8775	36.515	36.8175	13441000.0
2019-01-07 12:00:00	AAPL	Stock	36.8175	36.9712	36.7025	36.9052	10769804.0
2019-01-07 12:30:00	AAPL	Stock	36.905	36.95	36.785	36.92	8500608.0
2019-01-07 13:00:00	AAPL	Stock	36.92	37.03	36.729	36.81	10972848.0
2019-01-07 13:30:00	AAPL	Stock	36.81	36.835	36.6515	36.7125	8624928.0
2019-01-07 14:00:00	AAPL	Stock	36.7125	36.7975	36.635	36.6445	7292184.0
2019-01-07 14:30:00	AAPL	Stock	36.6425	36.76	36.5525	36.748	8991176.0
2019-01-07 15:00:00	AAPL	Stock	36.7475	37.095	36.7375	37.06	15819420.0
2019-01-07 15:30:00	AAPL	Stock	37.065	37.1	36.8875	36.9725	18090128.0
2019-01-07 16:00:00	AAPL	Stock	36.9825	37.0462	36.9325	36.9525	12471444.0
2019-01-07 16:30:00	AAPL	Stock	36.9625	36.9825	36.945	36.9625	292264.0
2019-01-07 17:00:00	AAPL	Stock	36.945	36.9825	36.925	36.9825	43204.0
2019-01-07 17:30:00	AAPL	Stock	36.95	36.975	36.9375	36.95	71164.0
2019-01-07 18:00:00	AAPL	Stock	36.9525	36.9525	36.94	36.9475	8608.0
2019-01-07 18:30:00	AAPL	Stock	36.9325	36.9725	36.9025	36.9125	40808.0
2019-01-07 19:00:00	AAPL	Stock	36.925	36.97	36.9025	36.945	52792.0
2019-01-07 19:30:00	AAPL	Stock	36.945	37.015	36.9425	37.015	58500.0
2019-01-07 04:00:00	MSFT	Stock	102.18	102.18	101.99	101.99	3047.0
2019-01-07 04:30:00	MSFT	Stock	101.7	102.0	101.7	101.85	1671.0
2019-01-07 05:00:00	MSFT	Stock	102.0	102.0	101.75	101.91	2704.0
2019-01-07 05:30:00	MSFT	Stock	101.78	101.78	101.05	101.51	8903.0
2019-01-07 06:00:00	MSFT	Stock	101.7	101.7	100.51	100.95	8925.0
2019-01-07 06:30:00	MSFT	Stock	101.04	101.4	100.82	101.4	2922.0
2019-01-07 07:00:00	MSFT	Stock	101.16	101.85	101.16	101.35	23707.0
2019-01-07 07:30:00	MSFT	Stock	101.5	101.7	101.21	101.21	24184.0
2019-01-07 08:00:00	MSFT	Stock	101.6	101.66	101.05	101.05	41432.0
2019-01-07 08:30:00	MSFT	Stock	101.25	101.29	100.75	101.05	44443.0
2019-01-07 09:00:00	MSFT	Stock	101.17	101.73	101.08	101.5	40645.0
2019-01-07 09:30:00	MSFT	Stock	101.64	102.01	101.25	101.609	3908520.0
2019-01-07 10:00:00	MSFT	Stock	101.6	101.8	100.98	101.63	2180540.0
2019-01-07 10:30:00	MSFT	Stock	101.61	102.54	101.61	102.28	2721982.0
2019-01-07 11:00:00	MSFT	Stock	102.275	102.56	102.159	102.33	2005882.0
2019-01-07 11:30:00	MSFT	Stock	102.33	103.268	102.28	103.18	2697784.0
2019-01-07 12:00:00	MSFT	Stock	103.18	103.24	102.74	102.94	1280410.0
2019-01-07 12:30:00	MSFT	Stock	102.945	103.135	102.81	103.07	1040459.0

> showing 50 of 85,210 rows — these rows as CSV

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