PREVIEW / stock_30min / 2017-09-01

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-01.parquet
  size:    1.6 MB
  rows:    79,227
  symbols: 2,964

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
2017-09-01 04:00:00	AAPL	Stock	41.095	41.095	41.095	41.095	4000.0
2017-09-01 05:00:00	AAPL	Stock	41.095	41.095	41.095	41.095	2976.0
2017-09-01 06:00:00	AAPL	Stock	41.11	41.12	41.105	41.12	3944.0
2017-09-01 06:30:00	AAPL	Stock	41.12	41.125	41.12	41.12	10892.0
2017-09-01 07:00:00	AAPL	Stock	41.1125	41.175	41.1125	41.1575	64252.0
2017-09-01 07:30:00	AAPL	Stock	41.155	41.17	41.15	41.165	31536.0
2017-09-01 08:00:00	AAPL	Stock	41.15	41.1825	41.1125	41.1775	165980.0
2017-09-01 08:30:00	AAPL	Stock	41.1825	41.195	41.115	41.1375	281624.0
2017-09-01 09:00:00	AAPL	Stock	41.1425	41.2075	41.1425	41.2	180572.0
2017-09-01 09:30:00	AAPL	Stock	41.2	41.235	40.9875	40.9975	13665468.0
2017-09-01 10:00:00	AAPL	Stock	40.99	41.06	40.9525	41.0275	7183340.0
2017-09-01 10:30:00	AAPL	Stock	41.0262	41.0475	40.9625	41.0275	4183604.0
2017-09-01 11:00:00	AAPL	Stock	41.025	41.095	40.9875	40.9908	4555972.0
2017-09-01 11:30:00	AAPL	Stock	40.9925	41.05	40.9925	41.046	2721584.0
2017-09-01 12:00:00	AAPL	Stock	41.046	41.0575	41.0025	41.0125	2061664.0
2017-09-01 12:30:00	AAPL	Stock	41.0125	41.0275	40.9825	40.9875	2299472.0
2017-09-01 13:00:00	AAPL	Stock	40.994	41.0175	40.955	40.9675	2249044.0
2017-09-01 13:30:00	AAPL	Stock	40.969	40.979	40.9075	40.9565	3262700.0
2017-09-01 14:00:00	AAPL	Stock	40.955	40.9985	40.953	40.9725	2420800.0
2017-09-01 14:30:00	AAPL	Stock	40.97	40.9925	40.9575	40.98	2288316.0
2017-09-01 15:00:00	AAPL	Stock	40.98	41.0325	40.9725	41.029	2624544.0
2017-09-01 15:30:00	AAPL	Stock	41.0288	41.03	40.9925	41.01	6818076.0
2017-09-01 16:00:00	AAPL	Stock	41.0025	41.02	41.0	41.015	3131044.0
2017-09-01 16:30:00	AAPL	Stock	41.0125	41.015	40.985	41.0125	19108.0
2017-09-01 17:00:00	AAPL	Stock	41.0125	41.015	40.9925	41.005	30456.0
2017-09-01 17:30:00	AAPL	Stock	41.0125	41.0175	41.0	41.005	11416.0
2017-09-01 18:00:00	AAPL	Stock	41.0	41.0	40.9925	40.9925	7168.0
2017-09-01 18:30:00	AAPL	Stock	40.995	40.995	40.9875	40.99	11068.0
2017-09-01 19:00:00	AAPL	Stock	40.9925	41.005	40.9925	41.005	6772.0
2017-09-01 19:30:00	AAPL	Stock	41.005	41.01	41.005	41.01	11052.0
2017-09-01 04:00:00	MSFT	Stock	74.83	74.9	74.83	74.9	1064.0
2017-09-01 05:00:00	MSFT	Stock	74.78	74.78	74.78	74.78	100.0
2017-09-01 05:30:00	MSFT	Stock	74.78	74.78	74.78	74.78	100.0
2017-09-01 07:00:00	MSFT	Stock	74.8	74.8	74.7	74.8	7439.0
2017-09-01 07:30:00	MSFT	Stock	74.8	74.85	74.8	74.85	276.0
2017-09-01 08:00:00	MSFT	Stock	74.89	74.89	74.8	74.8	1522.0
2017-09-01 08:30:00	MSFT	Stock	74.8	74.98	74.77	74.84	16683.0
2017-09-01 09:00:00	MSFT	Stock	74.84	74.89	74.4	74.65	75838.0
2017-09-01 09:30:00	MSFT	Stock	74.64	74.74	74.162	74.23	2771264.0
2017-09-01 10:00:00	MSFT	Stock	74.25	74.26	73.88	74.146	1621131.0
2017-09-01 10:30:00	MSFT	Stock	74.15	74.16	73.81	73.81	1136133.0
2017-09-01 11:00:00	MSFT	Stock	73.81	73.94	73.64	73.755	1518143.0
2017-09-01 11:30:00	MSFT	Stock	73.75	73.87	73.73	73.869	859893.0
2017-09-01 12:00:00	MSFT	Stock	73.865	73.896	73.671	73.835	1021017.0
2017-09-01 12:30:00	MSFT	Stock	73.83	73.92	73.74	73.745	627718.0
2017-09-01 13:00:00	MSFT	Stock	73.745	73.79	73.7	73.74	666326.0
2017-09-01 13:30:00	MSFT	Stock	73.745	73.92	73.73	73.92	773703.0
2017-09-01 14:00:00	MSFT	Stock	73.915	74.07	73.91	74.05	1077604.0
2017-09-01 14:30:00	MSFT	Stock	74.04	74.16	74.011	74.13	1103173.0
2017-09-01 15:00:00	MSFT	Stock	74.13	74.13	74.035	74.09	937792.0

> showing 50 of 79,227 rows — these rows as CSV

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