PREVIEW / stock_30min / 2018-02-05

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-05.parquet
  size:    1.8 MB
  rows:    89,758
  symbols: 2,912

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
2018-02-05 04:00:00	AAPL	Stock	40.0	40.0375	39.9375	40.0375	71988.0
2018-02-05 04:30:00	AAPL	Stock	40.025	40.175	40.0125	40.125	23332.0
2018-02-05 05:00:00	AAPL	Stock	40.09	40.15	40.0725	40.09	21320.0
2018-02-05 05:30:00	AAPL	Stock	40.125	40.17	40.125	40.14	19228.0
2018-02-05 06:00:00	AAPL	Stock	40.1375	40.1375	39.9625	40.0	76776.0
2018-02-05 06:30:00	AAPL	Stock	40.0	40.0525	39.75	39.8875	201580.0
2018-02-05 07:00:00	AAPL	Stock	39.8875	39.9	39.5925	39.76	566892.0
2018-02-05 07:30:00	AAPL	Stock	39.75	39.86	39.5675	39.6625	586032.0
2018-02-05 08:00:00	AAPL	Stock	40.0	40.0125	39.57	39.7125	1019968.0
2018-02-05 08:30:00	AAPL	Stock	39.7125	39.995	39.7	39.8475	558808.0
2018-02-05 09:00:00	AAPL	Stock	39.85	39.925	39.675	39.7775	1095480.0
2018-02-05 09:30:00	AAPL	Stock	39.7775	40.8	39.5	40.7825	45443088.0
2018-02-05 10:00:00	AAPL	Stock	40.785	40.97	40.6525	40.885	21476800.0
2018-02-05 10:30:00	AAPL	Stock	40.8842	40.89	40.6975	40.84	14020764.0
2018-02-05 11:00:00	AAPL	Stock	40.845	40.9625	40.66	40.665	11199196.0
2018-02-05 11:30:00	AAPL	Stock	40.6625	40.6655	40.275	40.4112	11880800.0
2018-02-05 12:00:00	AAPL	Stock	40.4075	40.4475	40.1675	40.28	10963344.0
2018-02-05 12:30:00	AAPL	Stock	40.275	40.51	40.255	40.38	8909900.0
2018-02-05 13:00:00	AAPL	Stock	40.375	40.385	40.1918	40.2675	10277772.0
2018-02-05 13:30:00	AAPL	Stock	40.2675	40.6175	40.24	40.6095	10416976.0
2018-02-05 14:00:00	AAPL	Stock	40.604	40.62	40.265	40.3225	9184032.0
2018-02-05 14:30:00	AAPL	Stock	40.3225	40.4725	40.0975	40.1675	13621936.0
2018-02-05 15:00:00	AAPL	Stock	40.1638	40.2725	39.0	40.0212	33789392.0
2018-02-05 15:30:00	AAPL	Stock	40.0325	40.0675	39.1075	39.1225	36524400.0
2018-02-05 16:00:00	AAPL	Stock	39.1225	40.1875	38.955	39.075	15788780.0
2018-02-05 16:30:00	AAPL	Stock	39.08	39.1225	38.9475	39.01	1064148.0
2018-02-05 17:00:00	AAPL	Stock	39.01	39.05	38.9	38.9375	181492.0
2018-02-05 17:30:00	AAPL	Stock	38.9375	39.05	38.9	38.975	147436.0
2018-02-05 18:00:00	AAPL	Stock	39.0	39.125	38.945	39.1125	219920.0
2018-02-05 18:30:00	AAPL	Stock	39.125	39.125	38.9375	38.965	194752.0
2018-02-05 19:00:00	AAPL	Stock	39.0	39.025	38.8425	38.875	225336.0
2018-02-05 19:30:00	AAPL	Stock	38.925	38.98	38.85	38.855	94060.0
2018-02-05 04:00:00	MSFT	Stock	91.25	91.25	91.02	91.02	329.0
2018-02-05 04:30:00	MSFT	Stock	91.01	91.2	91.0	91.2	1920.0
2018-02-05 05:30:00	MSFT	Stock	91.0	91.0	91.0	91.0	100.0
2018-02-05 06:00:00	MSFT	Stock	91.11	91.23	91.06	91.06	3849.0
2018-02-05 06:30:00	MSFT	Stock	91.05	91.05	90.82	90.88	4166.0
2018-02-05 07:00:00	MSFT	Stock	90.88	90.88	90.0	90.42	45144.0
2018-02-05 07:30:00	MSFT	Stock	90.35	90.48	90.08	90.3	52270.0
2018-02-05 08:00:00	MSFT	Stock	90.345	91.2	90.0	90.45	110362.0
2018-02-05 08:30:00	MSFT	Stock	90.37	91.01	90.37	90.98	32815.0
2018-02-05 09:00:00	MSFT	Stock	90.96	90.96	90.45	90.51	56024.0
2018-02-05 09:30:00	MSFT	Stock	90.56	91.9	90.25	91.79	4946085.0
2018-02-05 10:00:00	MSFT	Stock	91.792	92.98	91.58	92.886	3086909.0
2018-02-05 10:30:00	MSFT	Stock	92.89	93.24	92.56	92.72	2226355.0
2018-02-05 11:00:00	MSFT	Stock	92.72	92.9	92.3	92.33	1477583.0
2018-02-05 11:30:00	MSFT	Stock	92.33	92.42	91.94	92.36	1480230.0
2018-02-05 12:00:00	MSFT	Stock	92.36	92.4	91.77	91.98	1489694.0
2018-02-05 12:30:00	MSFT	Stock	91.97	92.5	91.78	92.14	1237693.0
2018-02-05 13:00:00	MSFT	Stock	92.13	92.14	91.27	91.48	2198208.0

> showing 50 of 89,758 rows — these rows as CSV

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