PREVIEW / stock_30min / 2015-08-28

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-08-28.parquet
  size:    1.6 MB
  rows:    84,113
  symbols: 3,468

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
2015-08-28 04:00:00	AAPL	Stock	28.325	28.325	28.1	28.1525	56092.0
2015-08-28 04:30:00	AAPL	Stock	28.145	28.1675	28.1125	28.12	37576.0
2015-08-28 05:00:00	AAPL	Stock	28.1325	28.1325	28.0575	28.1125	34396.0
2015-08-28 05:30:00	AAPL	Stock	28.125	28.1825	28.125	28.1825	12940.0
2015-08-28 06:00:00	AAPL	Stock	28.195	28.2475	28.0825	28.085	59440.0
2015-08-28 06:30:00	AAPL	Stock	28.1	28.1475	28.0425	28.0425	55352.0
2015-08-28 07:00:00	AAPL	Stock	28.0225	28.0575	27.9875	28.0575	69216.0
2015-08-28 07:30:00	AAPL	Stock	28.0575	28.1175	28.0375	28.065	43524.0
2015-08-28 08:00:00	AAPL	Stock	28.0675	28.1125	27.965	28.0225	479916.0
2015-08-28 08:30:00	AAPL	Stock	28.025	28.0575	27.98	28.0425	224040.0
2015-08-28 09:00:00	AAPL	Stock	28.0375	28.0475	27.8125	28.045	816764.0
2015-08-28 09:30:00	AAPL	Stock	28.0425	28.21	27.95	28.025	28978992.0
2015-08-28 10:00:00	AAPL	Stock	28.025	28.1	27.885	28.0688	19138892.0
2015-08-28 10:30:00	AAPL	Stock	28.0675	28.129	27.94	28.0275	13666552.0
2015-08-28 11:00:00	AAPL	Stock	28.0228	28.2575	28.015	28.2375	13834356.0
2015-08-28 11:30:00	AAPL	Stock	28.235	28.3175	28.0475	28.0925	16856744.0
2015-08-28 12:00:00	AAPL	Stock	28.0925	28.215	28.0675	28.168	10505572.0
2015-08-28 12:30:00	AAPL	Stock	28.1675	28.245	28.1175	28.19	7405484.0
2015-08-28 13:00:00	AAPL	Stock	28.1948	28.2175	28.0798	28.085	6679180.0
2015-08-28 13:30:00	AAPL	Stock	28.0875	28.165	28.005	28.1	11693888.0
2015-08-28 14:00:00	AAPL	Stock	28.1012	28.23	28.095	28.1775	9071752.0
2015-08-28 14:30:00	AAPL	Stock	28.1775	28.27	28.1075	28.1925	11225668.0
2015-08-28 15:00:00	AAPL	Stock	28.1925	28.2075	28.0675	28.1225	12955868.0
2015-08-28 15:30:00	AAPL	Stock	28.1225	28.3275	28.055	28.32	24589888.0
2015-08-28 16:00:00	AAPL	Stock	28.32	28.3625	28.0638	28.335	12546084.0
2015-08-28 16:30:00	AAPL	Stock	28.3425	28.345	28.2575	28.27	484656.0
2015-08-28 17:00:00	AAPL	Stock	28.28	28.3175	28.2525	28.3	143088.0
2015-08-28 17:30:00	AAPL	Stock	28.2982	28.3275	28.2975	28.3258	54460.0
2015-08-28 18:00:00	AAPL	Stock	28.3275	28.3425	28.325	28.3375	61904.0
2015-08-28 18:30:00	AAPL	Stock	28.34	28.34	28.3125	28.32	41396.0
2015-08-28 19:00:00	AAPL	Stock	28.3225	28.3375	28.3175	28.3175	13060.0
2015-08-28 19:30:00	AAPL	Stock	28.3375	28.3425	28.3225	28.3425	98080.0
2015-08-28 04:00:00	MSFT	Stock	43.8	43.8	43.8	43.8	1867.0
2015-08-28 05:30:00	MSFT	Stock	43.49	43.77	43.49	43.77	298.0
2015-08-28 06:00:00	MSFT	Stock	43.77	43.8	43.51	43.77	3525.0
2015-08-28 07:00:00	MSFT	Stock	43.48	43.48	43.48	43.48	100.0
2015-08-28 07:30:00	MSFT	Stock	43.7	43.7	43.52	43.65	500.0
2015-08-28 08:00:00	MSFT	Stock	43.48	43.69	43.48	43.62	800.0
2015-08-28 08:30:00	MSFT	Stock	43.74	43.75	43.63	43.69	2521.0
2015-08-28 09:00:00	MSFT	Stock	43.7	43.7	43.43	43.45	39163.0
2015-08-28 09:30:00	MSFT	Stock	43.4	43.86	43.39	43.81	4273623.0
2015-08-28 10:00:00	MSFT	Stock	43.8	43.805	43.52	43.69	2025144.0
2015-08-28 10:30:00	MSFT	Stock	43.69	43.87	43.67	43.81	1699896.0
2015-08-28 11:00:00	MSFT	Stock	43.81	44.076	43.8	44.03	1362821.0
2015-08-28 11:30:00	MSFT	Stock	44.03	44.15	43.67	43.73	1855724.0
2015-08-28 12:00:00	MSFT	Stock	43.73	43.88	43.68	43.83	1155123.0
2015-08-28 12:30:00	MSFT	Stock	43.83	44.0	43.815	43.965	968794.0
2015-08-28 13:00:00	MSFT	Stock	43.97	43.99	43.775	43.775	1056011.0
2015-08-28 13:30:00	MSFT	Stock	43.78	43.88	43.68	43.765	1270581.0
2015-08-28 14:00:00	MSFT	Stock	43.77	43.94	43.73	43.8	985883.0

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

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