PREVIEW / stock_30min / 2015-08-25

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-08-25.parquet
  size:    1.7 MB
  rows:    86,811
  symbols: 3,497

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-25 04:00:00	AAPL	Stock	26.4575	27.0625	26.4575	27.0625	104348.0
2015-08-25 04:30:00	AAPL	Stock	27.02	27.0875	26.955	27.05	58868.0
2015-08-25 05:00:00	AAPL	Stock	27.05	27.0675	26.9625	27.025	97208.0
2015-08-25 05:30:00	AAPL	Stock	27.02	27.175	27.0	27.025	81548.0
2015-08-25 06:00:00	AAPL	Stock	27.1125	27.5575	27.04	27.41	492696.0
2015-08-25 06:30:00	AAPL	Stock	27.41	27.4875	27.325	27.35	644300.0
2015-08-25 07:00:00	AAPL	Stock	27.35	27.4375	27.2775	27.2775	586504.0
2015-08-25 07:30:00	AAPL	Stock	27.28	27.3625	27.2525	27.285	533624.0
2015-08-25 08:00:00	AAPL	Stock	27.285	27.5	27.03	27.1125	2326288.0
2015-08-25 08:30:00	AAPL	Stock	27.1125	27.2375	26.9875	27.0475	1555660.0
2015-08-25 09:00:00	AAPL	Stock	27.04	27.7775	27.035	27.7775	4944652.0
2015-08-25 09:30:00	AAPL	Stock	27.7775	27.79	26.8325	26.9125	78847436.0
2015-08-25 10:00:00	AAPL	Stock	26.9075	27.2275	26.8675	26.9825	33846716.0
2015-08-25 10:30:00	AAPL	Stock	26.98	27.14	26.9175	27.1225	19873808.0
2015-08-25 11:00:00	AAPL	Stock	27.1225	27.31	27.122	27.22	24748084.0
2015-08-25 11:30:00	AAPL	Stock	27.2225	27.3125	27.1425	27.2325	14836236.0
2015-08-25 12:00:00	AAPL	Stock	27.2325	27.3175	27.125	27.2075	14143772.0
2015-08-25 12:30:00	AAPL	Stock	27.205	27.2875	27.15	27.1575	10568052.0
2015-08-25 13:00:00	AAPL	Stock	27.16	27.1975	26.75	26.78	19132252.0
2015-08-25 13:30:00	AAPL	Stock	26.7788	27.075	26.75	27.0225	21700448.0
2015-08-25 14:00:00	AAPL	Stock	27.0212	27.045	26.785	26.9425	16779176.0
2015-08-25 14:30:00	AAPL	Stock	26.94	27.1	26.8638	27.0375	14248728.0
2015-08-25 15:00:00	AAPL	Stock	27.0375	27.1	26.675	26.7025	20936812.0
2015-08-25 15:30:00	AAPL	Stock	26.7012	26.7925	25.875	25.9375	57285824.0
2015-08-25 16:00:00	AAPL	Stock	25.935	27.2638	25.8	25.87	21493844.0
2015-08-25 16:30:00	AAPL	Stock	25.8675	25.935	25.805	25.82	1068188.0
2015-08-25 17:00:00	AAPL	Stock	25.8375	25.86	25.6318	25.6325	702736.0
2015-08-25 17:30:00	AAPL	Stock	25.6325	25.9	25.575	25.8925	350364.0
2015-08-25 18:00:00	AAPL	Stock	25.895	25.9	25.8	25.8125	197956.0
2015-08-25 18:30:00	AAPL	Stock	25.8025	25.8025	25.69	25.7075	189448.0
2015-08-25 19:00:00	AAPL	Stock	25.7475	25.7875	25.725	25.7375	59760.0
2015-08-25 19:30:00	AAPL	Stock	25.7375	25.7425	25.525	25.545	232268.0
2015-08-25 04:00:00	MSFT	Stock	42.51	42.72	42.51	42.72	6400.0
2015-08-25 04:30:00	MSFT	Stock	42.82	42.82	42.5	42.5	900.0
2015-08-25 05:00:00	MSFT	Stock	42.51	42.51	42.5	42.5	2100.0
2015-08-25 05:30:00	MSFT	Stock	42.7	42.7	42.57	42.57	250.0
2015-08-25 06:00:00	MSFT	Stock	42.69	42.97	42.5	42.97	3100.0
2015-08-25 06:30:00	MSFT	Stock	42.95	43.42	42.86	42.9	17059.0
2015-08-25 07:00:00	MSFT	Stock	42.65	43.02	42.65	43.02	12551.0
2015-08-25 07:30:00	MSFT	Stock	42.95	43.06	42.95	43.02	7760.0
2015-08-25 08:00:00	MSFT	Stock	42.98	43.44	42.6	42.74	33541.0
2015-08-25 08:30:00	MSFT	Stock	42.78	42.84	42.5	42.55	18840.0
2015-08-25 09:00:00	MSFT	Stock	42.59	42.9	42.5	42.62	89491.0
2015-08-25 09:30:00	MSFT	Stock	42.62	42.94	41.62	42.62	9834804.0
2015-08-25 10:00:00	MSFT	Stock	42.62	42.89	42.48	42.62	4964502.0
2015-08-25 10:30:00	MSFT	Stock	42.63	42.78	42.47	42.7	3004744.0
2015-08-25 11:00:00	MSFT	Stock	42.7	43.24	42.69	43.04	2578347.0
2015-08-25 11:30:00	MSFT	Stock	43.04	43.1	42.67	42.68	2716076.0
2015-08-25 12:00:00	MSFT	Stock	42.69	42.78	42.51	42.66	2419267.0
2015-08-25 12:30:00	MSFT	Stock	42.65	42.71	42.48	42.5	1780368.0

> showing 50 of 86,811 rows — these rows as CSV

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