PREVIEW / stock_30min / 2016-04-18

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-18.parquet
  size:    1.6 MB
  rows:    83,199
  symbols: 3,326

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
2016-04-18 04:00:00	AAPL	Stock	27.4	27.4	27.2525	27.2525	20624.0
2016-04-18 04:30:00	AAPL	Stock	27.3025	27.3025	27.3025	27.3025	800.0
2016-04-18 05:00:00	AAPL	Stock	27.345	27.345	27.3025	27.31	4000.0
2016-04-18 05:30:00	AAPL	Stock	27.3	27.36	27.3	27.36	11264.0
2016-04-18 06:00:00	AAPL	Stock	27.36	27.3625	27.36	27.36	18400.0
2016-04-18 06:30:00	AAPL	Stock	27.35	27.35	27.3125	27.3125	6812.0
2016-04-18 07:00:00	AAPL	Stock	27.325	27.34	27.2775	27.29	121244.0
2016-04-18 07:30:00	AAPL	Stock	27.29	27.2925	27.125	27.2125	203924.0
2016-04-18 08:00:00	AAPL	Stock	27.2125	27.3325	27.205	27.2825	356388.0
2016-04-18 08:30:00	AAPL	Stock	27.275	27.2975	27.2375	27.25	314720.0
2016-04-18 09:00:00	AAPL	Stock	27.25	27.285	27.2025	27.225	433996.0
2016-04-18 09:30:00	AAPL	Stock	27.225	27.2375	26.9525	26.98	31331744.0
2016-04-18 10:00:00	AAPL	Stock	26.98	27.16	26.9762	27.05	18274916.0
2016-04-18 10:30:00	AAPL	Stock	27.0525	27.085	26.99	27.0138	11180300.0
2016-04-18 11:00:00	AAPL	Stock	27.0125	27.0765	26.9875	27.0125	7926828.0
2016-04-18 11:30:00	AAPL	Stock	27.0112	27.05	26.9938	27.0225	7780688.0
2016-04-18 12:00:00	AAPL	Stock	27.0225	27.0775	26.98	26.9888	7487556.0
2016-04-18 12:30:00	AAPL	Stock	26.9875	27.0262	26.94	26.9525	9274908.0
2016-04-18 13:00:00	AAPL	Stock	26.95	26.955	26.8675	26.885	10052256.0
2016-04-18 13:30:00	AAPL	Stock	26.8838	26.9075	26.7875	26.82	9814984.0
2016-04-18 14:00:00	AAPL	Stock	26.82	26.8475	26.735	26.765	11260140.0
2016-04-18 14:30:00	AAPL	Stock	26.765	26.81	26.75	26.78	9194876.0
2016-04-18 15:00:00	AAPL	Stock	26.7785	26.815	26.7575	26.7922	9761944.0
2016-04-18 15:30:00	AAPL	Stock	26.7925	26.9125	26.7625	26.85	25637984.0
2016-04-18 16:00:00	AAPL	Stock	26.85	27.0135	26.805	26.85	12416912.0
2016-04-18 16:30:00	AAPL	Stock	26.85	26.87	26.7775	26.8275	931864.0
2016-04-18 17:00:00	AAPL	Stock	26.825	26.855	26.82	26.855	19032.0
2016-04-18 17:30:00	AAPL	Stock	26.85	26.86	26.83	26.8475	13260.0
2016-04-18 18:00:00	AAPL	Stock	26.8425	26.8425	26.825	26.825	14620.0
2016-04-18 18:30:00	AAPL	Stock	26.8375	26.8425	26.825	26.8425	13728.0
2016-04-18 19:00:00	AAPL	Stock	26.8375	26.8475	26.8275	26.8275	20400.0
2016-04-18 19:30:00	AAPL	Stock	26.8275	26.8625	26.8275	26.8625	23240.0
2016-04-18 05:00:00	MSFT	Stock	55.47	55.52	55.47	55.52	2535.0
2016-04-18 06:00:00	MSFT	Stock	55.51	55.51	55.51	55.51	200.0
2016-04-18 06:30:00	MSFT	Stock	55.22	55.23	55.22	55.22	10799.0
2016-04-18 07:00:00	MSFT	Stock	55.49	55.49	55.34	55.34	645.0
2016-04-18 08:00:00	MSFT	Stock	55.45	55.45	55.34	55.4	9756.0
2016-04-18 08:30:00	MSFT	Stock	55.44	55.46	55.4	55.44	3324.0
2016-04-18 09:00:00	MSFT	Stock	55.41	55.41	55.36	55.36	4367.0
2016-04-18 09:30:00	MSFT	Stock	55.35	55.745	55.21	55.71	1574661.0
2016-04-18 10:00:00	MSFT	Stock	55.71	56.04	55.7	56.015	1650928.0
2016-04-18 10:30:00	MSFT	Stock	56.01	56.25	56.0	56.186	1362756.0
2016-04-18 11:00:00	MSFT	Stock	56.18	56.19	55.98	56.05	1195422.0
2016-04-18 11:30:00	MSFT	Stock	56.055	56.11	56.0	56.05	868653.0
2016-04-18 12:00:00	MSFT	Stock	56.05	56.43	56.05	56.39	2098655.0
2016-04-18 12:30:00	MSFT	Stock	56.392	56.59	56.34	56.35	2095128.0
2016-04-18 13:00:00	MSFT	Stock	56.345	56.41	56.23	56.295	1098739.0
2016-04-18 13:30:00	MSFT	Stock	56.3	56.48	56.26	56.47	939847.0
2016-04-18 14:00:00	MSFT	Stock	56.47	56.52	56.44	56.45	1142538.0
2016-04-18 14:30:00	MSFT	Stock	56.453	56.55	56.44	56.5	1067710.0

> showing 50 of 83,199 rows — these rows as CSV

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